I have Account Numbers starting from 100000 to 999999 and corresponding Balances .
I want to show the output as below
100002 and till <200000
200002 and Till <300000
how to achieve the requirement,please find the attached data file and out put put format in second tab of the sheet.
Can you please clarify few observation on output tab.
Is 390100 belong 300000 or 4000000?
Also you only have 100000, 200000, 3000000 but not beyond that. Is that how it should be?
we are not financial specialist !
you are Vijay maybe it'only under 4000000
so if(accountnumb<4000000,floor(num(AccountNumber)/100000)*100000, accountNumber)
if rule is complex : it's better to create a hierarchy
You can try this in script
div([PARENTA/C'],100000)*100000 as Parent_Acc,
[PARENTA/C'] as Acc,
[From & 2.xlsx]
(ooxml, embedded labels, table is source);