Posted to microsoft.public.excel.worksheet.functions

Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline

external usenet poster

Posts: 1,045

Returning a value that hasn't already been found

On Thu, 23 Feb 2012 09:27:17 +0000, azlan270690 wrote:

Thanks for your help Ron. Yeah unfortunately I am unable to use a filter
function for the particular spreadsheet I am using. But the formula was
exactly what I was after. Thanks again.

Glad to help. Thanks for the feedback.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Returning 0 instead of #N/A when no value is found	RobertSD	Excel Worksheet Functions	8	October 27th 08 11:43 PM
Returning an alternative value if lookup cannot be found in array	Queen_Of_Thebes	Excel Discussion (Misc queries)	4	September 2nd 08 01:43 AM
I found a bug	Don Wiss	Excel Programming	2	August 22nd 07 01:44 AM
IF NOT FOUND	roy.okinawa	Excel Worksheet Functions	5	November 17th 05 03:26 AM
not found	Nathan[_4_]	Excel Programming	1	June 25th 04 05:26 AM

All times are GMT +1. The time now is 04:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us