G
Guest
Hi Folks,
I have a Spread sheet that is 1430 rows deep by 39 columns long. I have
extracted from this the min value of each row into another spread sheet. Now
I want to use these min values to look back at the original spread sheet and
find what column the min value came from (i.e. its heading)
I’ve tried many machinations of hlookups, index, match but I can’t seem to
get the thing to work,
Cheers in advance,
I have a Spread sheet that is 1430 rows deep by 39 columns long. I have
extracted from this the min value of each row into another spread sheet. Now
I want to use these min values to look back at the original spread sheet and
find what column the min value came from (i.e. its heading)
I’ve tried many machinations of hlookups, index, match but I can’t seem to
get the thing to work,
Cheers in advance,