How ta display range of values

[Vinod]

Hi All.

Can anyone get me the following output,
For your reference, Please find the attached file. 

Thanks,

Vinod

[sunny_talwar]

Try like this in the script

Table:
LOAD MIS,
	 If(MIS < 6, Dual('0<=MIS<6', 1),
	 	If(MIS < 12, Dual('7<=MIS<12', 2),
	 		If(MIS <18, Dual('13<=MIS<18', 3),
	 			If(MIS < 24, Dual('19<=MIS<24', 4),
	 				If(MIS < 30, Dual('25<=MIS<30', 5)))))) as New_MIS
FROM
[..\..\Downloads\MIS Data.xlsx]
(ooxml, embedded labels, table is INPUT);