Forum Discussion
Ranges
Hi Team
in below table my assigned range is 361-432. i need to split starting from 361 based on Count
For example staring number is 361 and number count in 6 so 361-366
like above i need to range the numbers based on Count
please help me out with formula or some thing to get this done
| Numbers count | Numbers range | |
| (361-432) | 6 | 361-366 |
| 8 | 367-374 | |
| 6 | ||
| 8 | ||
| 12 | ||
| 12 | ||
| 8 | ||
| 6 | ||
| 6 |
2 Replies
This is currently 365 insider only.
= LET( top, SCAN(360, count, LAMBDA(acc,count, acc+count)), base, 1 + top - count, base & " - " & top )
