LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default Matching values in a row

Hi,

You can use =INDEX(B1:G2,1,match(min(B2:G2),B2:G2,0)). Please note that if
there are multiple minimum values, then this will work only for the first
minimum value.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"CeciliaPDX" wrote in message
...
Hello--

I have a min value that I pulled from a row that contains several columns.
I
am trying to identify what the column label for that min. value is:

So in the example below, I'm pulling the min value of 1 and would like to
be
able to return D since that corresponds to the MIN value.

Thanks!!!

A B C D E F
16 3 7 2 29 18


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching two values Anna Wood Excel Worksheet Functions 2 February 10th 09 08:13 PM
Matching Values Ed[_4_] Excel Worksheet Functions 1 October 11th 08 07:48 PM
Matching 2nd & 3rd values [email protected] Excel Worksheet Functions 1 June 9th 08 03:01 PM
Finding Most Recent Values in Col1 -- Summing Matching Values Rothman Excel Discussion (Misc queries) 5 December 20th 07 08:19 PM
matching two values denizcan Excel Discussion (Misc queries) 3 October 15th 07 03:20 AM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"