Compare a string of values to a specific of value and return the header

**huy_le** · 12-19-2013, 09:36 PM

Hi guys,

Basically I have a string of dates, I want to get the max of the values that are before a specific date and return the header. Look at the file I provide for better understanding.

Thanks so much!!!

**JieJenn** · 12-19-2013, 09:46 PM

enter this formula with ctrl + shift + enter keys enter together

=INDEX($E$1:$J$1,MATCH(MAX(IF($E$2:$J$2<$B$10,$E$2:$J$2)),$E$2:$J$2,1))

**huy_le** · 12-19-2013, 10:02 PM

That works! Thanks so much bro!

Compare a string of values to a specific of value and return the header

LinkBack

Thread Tools

Rate This Thread

Display

Compare a string of values to a specific of value and return the header

Re: Compare a string of values to a specific of value and return the header

Re: Compare a string of values to a specific of value and return the header

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Compare a value to a range and return header

[SOLVED] Find specific value in table and return header row and header column value

Macro to identify column by header and replace number values with string values

[SOLVED] Compare dates across columns and return column header

[SOLVED] compare cell value with range of values and match row values with header

Bookmarks

Bookmarks

Posting Permissions