Hi guys,
I have tons of calculations across multiple sheets and need to find which of the sheets holds the minimal value:
There are 10 sheets with a 100x100 matrix, each cell holding its own calculation. I have a "top level" sheet which holds a 100x100 matrix, where e.g cell B5 holds MIN(sheet1!B5;sheet2!B5;sheet3!B5;sheet4!B5...). This will tell me the overall minimum values selected from each underlying sheet, but I really need to identify _which_ sheet holds the minimum value for any given cell. All the MATCH, LOOKUP etc functions require an array. This would be dead simple if Excel would allow the creation of arrays from individual cells, but since it doesn't), I need to find some other way.
Does anyone have any tips?
Brgds Robert
Bookmarks