MS Excel / VBA help thread

You are reading a single comment by @Light_EDDed and its replies. Click here to read the full conversation.

•

Light_EDDed

I want a range

1-2
2-3
3-4

•

aggi in reply to @Light_EDDed
```
=SEQUENCE(100,1,0,10000)&" - "&SEQUENCE(100,1,10000,10000)
```
will do it if you have a reasonably recent version of excel.
```
=(ROW()-1)*10000&" - "&(ROW()*10000)
```
copied down for an old version of Excel (you may need to adjust what you are subtracting depending on which row you are starting at).
•

Chalfie in reply to @Light_EDDed

Yes, but I'm going to guess there's a reason you want to create these bins. Are you doing some sort of grouping for charting?
https://www.statology.org/data-binning-in-excel/

About

@Light_EDDed started