Posted to microsoft.public.excel.misc

Vicki

external usenet poster

Posts: 70

ignore blank

column a column b column c column
d
john 3, 12 2,3
peter
Mary 12, 24 26

please help with the forumula on column d to show number "1" if column a to
c not blank

thanks again to all
--
vicki

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
ignore cells that are blank	Robert	Excel Discussion (Misc queries)	4	November 27th 08 02:52 AM
Ignore Blank or 0 cells	Dave	Excel Worksheet Functions	4	August 20th 08 12:06 AM
ignore blank	Naomi	Excel Discussion (Misc queries)	1	December 1st 06 12:55 PM
ignore blank cells	Leticia	Excel Discussion (Misc queries)	3	February 27th 06 05:41 PM
how do you ignore blank cells	Kerry	Excel Discussion (Misc queries)	1	February 16th 05 01:55 PM

All times are GMT +1. The time now is 08:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us