Jan 06 2022 10:36 PM
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 |
Jan 09 2022 12:34 PM
Jan 09 2022 01:53 PM
This is currently 365 insider only.
= LET(
top, SCAN(360, count, LAMBDA(acc,count, acc+count)),
base, 1 + top - count,
base & " - " & top )