Hi, I hope someone can tell me how to to a lookup as follows:
I have a large sheet that contains columns of variable data (sometimes empty cells). The cols are arb. numbered 1 to nnn. I would like to have a summary column at the end that returns the header number of the column that contains the maximum value in each row (i.e. the winning bidder). LOOKUP would work save for the fact that the row must be sorted, which I am loath to do - each row would need to be sorted separately....
Any ideas?
Boz
I have a large sheet that contains columns of variable data (sometimes empty cells). The cols are arb. numbered 1 to nnn. I would like to have a summary column at the end that returns the header number of the column that contains the maximum value in each row (i.e. the winning bidder). LOOKUP would work save for the fact that the row must be sorted, which I am loath to do - each row would need to be sorted separately....
Any ideas?
Boz