M myka New Member Jul 2, 2014 #1 Complete newbie here. I have data like this Row 1 Header 1 Header 2 Header 3 Row 2 2 3 4 I want to search all numbers in Row 2, find the minimum number and display the Header Text as listed in Row 1 for the returned minimum value in Row 2. Please help.
Complete newbie here. I have data like this Row 1 Header 1 Header 2 Header 3 Row 2 2 3 4 I want to search all numbers in Row 2, find the minimum number and display the Header Text as listed in Row 1 for the returned minimum value in Row 2. Please help.
Mike H.. Active Member Jul 2, 2014 #2 myka said: Complete newbie here. I have data like this Row 1 Header 1 Header 2 Header 3 Row 2 2 3 4 I want to search all numbers in Row 2, find the minimum number and display the Header Text as listed in Row 1 for the returned minimum value in Row 2. Please help. Click to expand... Hi, Try this. Drag down as required. =INDEX($A$1:$C$1,MATCH(MIN(A2:C2),A2:C2,0))
myka said: Complete newbie here. I have data like this Row 1 Header 1 Header 2 Header 3 Row 2 2 3 4 I want to search all numbers in Row 2, find the minimum number and display the Header Text as listed in Row 1 for the returned minimum value in Row 2. Please help. Click to expand... Hi, Try this. Drag down as required. =INDEX($A$1:$C$1,MATCH(MIN(A2:C2),A2:C2,0))
