Posted to microsoft.public.excel.misc

DaveO

external usenet poster

Posts: 94

Lookups

I have a row of data with either zeros or numbers in 24 cells. I would like
to create a formula in an adjacent cell which scans the 24 cells and records
the first nonzero number it finds.

I've thought of using a nested if-then but that seems to cumbersome. Would
appreciate your feedback...thx.

Daveo

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
Lookups	Warren Easton	Excel Discussion (Misc queries)	2	July 9th 08 03:38 PM
Lookups	RkB2008	Excel Discussion (Misc queries)	2	June 23rd 08 07:24 PM
Lookups...	ajayb	Excel Worksheet Functions	3	June 17th 08 02:18 AM
Maybe I need help with Lookups??	garry05	Excel Worksheet Functions	4	December 8th 05 02:26 AM
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied.	Mr Wiffy	Excel Worksheet Functions	2	May 16th 05 04:29 AM

All times are GMT +1. The time now is 10:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us