Posted to microsoft.public.excel.worksheet.functions

MPI Planner[_2_] MPI Planner[_2_] is offline

external usenet poster

Posts: 10

locate first value greater than

I would like to be able to return the first column that has a number greater
than zero. For instance

3/2 3/9 3/16 3/23 3/30
Product A 0 0 12 0 20

How could I get a result that either returned 3/16 as the first date or
column 4 as the first instance?

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
STILL CAN'T LOCATE XML	emi	New Users to Excel	1	July 24th 07 11:04 PM
Locate Duplicates	Gary	Excel Worksheet Functions	3	December 29th 06 10:48 PM
Locate Workbook	Kev	Excel Discussion (Misc queries)	2	December 28th 06 04:07 PM
Cannot locate icons ??	Koko	New Users to Excel	3	August 3rd 05 08:52 AM
How can I locate the second to last value in a range?	A shink	Excel Worksheet Functions	5	June 4th 05 01:17 AM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us