Ranges

[vishwa0121]

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]

@vishwa0121 If you can live with a helper columns, perhaps the attached file can help.

[#3]

This is currently 365 insider only.

= LET(
  top, SCAN(360, count, LAMBDA(acc,count, acc+count)),
  base, 1 + top - count,
  base & " - " & top )