#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default special lookup

I am looking for a function or combination of functions that will return the
1st value in an array not equal to specified cell or cells.

Hope you can help.

Thanks,
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default special lookup

Post an example.


--
Biff
Microsoft Excel MVP


"Jasper" wrote in message
...
I am looking for a function or combination of functions that will return
the
1st value in an array not equal to specified cell or cells.

Hope you can help.

Thanks,



Reply
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
special lookup tjh Excel Worksheet Functions 2 May 17th 07 05:17 PM
SPECIAL LOOKUP FORMULA 4 MULTIPLE CRITERIA FARAZ QURESHI Excel Discussion (Misc queries) 1 May 5th 07 02:32 AM
Special Lookup Formula DoooWhat Excel Discussion (Misc queries) 4 March 13th 07 02:03 AM
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup JBush Excel Worksheet Functions 3 January 4th 07 12:14 AM
Special lookup need Rajat Excel Worksheet Functions 1 December 31st 04 08:51 PM


All times are GMT +1. The time now is 09:46 PM.

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

About Us

"It's about Microsoft Excel"