=LOOKUP(9.99999999E+307,K252:EJ252)
returns the last entry in the row.
What returns the first one?
I get the feeling this is simple, so I apologize in advance for not being able to figure it out on my own.
Row has blanks, first entry may be in any column.
TIA
Last edited by pay2play; 12-12-2008 at 07:02 AM.
=INDEX(k252:ej252,1,1)What returns the first one?
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Try
=INDEX(K252:EJ252,MATCH(TRUE,INDEX(K252:EJ252<>"",0),0))
It's 3am here, I'm bleary eyed working, and you guys answer within a matter of minutes?
God bless you both. TY.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks