How to resolve the #NUM! error in .xlsb file?

[rajamdade]

Hi,

Attached is the excel ".xlsb" formulated file, I am getting error as "#NUM!" in the "Results" sheet from the row 116 onwards. Moreover, I have also enabled iterative calculation box, but still the issue has not been resolved.

I would appreciate it if you could help us to resolve the issue in the file attached hereby.

Download test file

Kind regards,
Rahul

 

[Fluff]

You are only catering for 100 values per row, but you have more than that. Try dividing by 1000 instead of 100 in the col A formula & changing your col C formula accordingly.

 

[Toadstool]

Hi,

Attached is the excel ".xlsb" formulated file, I am getting error as "#NUM!" in the "Results" sheet from the row 116 onwards.

Hi Rahul,

I believe the #NUM! is because the AGGREGATE is trying to take the next key, which is more than 9, so fails to find an entry in Data.