Posted to microsoft.public.excel.worksheet.functions

BryGuy77

external usenet poster

Posts: 4

Only adding nonzeroes

Hello all,

In Excel 2007, have a data array that contains blank lines. Is it possible
to list only the cells with values? Ill give an example:

A1='blank'
A2='blank'
A3=5/5/08
A4='blank'
A5=7/7/08

Can I list this so it ends with: 5/5/08, 7/7/08? I tried CONCATENATE, but
the blanks return ", ". And now I'm lost.

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
Adding	Sarah_Lecturer	Excel Discussion (Misc queries)	2	April 17th 08 01:46 PM
adding ref #	John K	Excel Worksheet Functions	2	March 7th 07 06:06 PM
Help with adding 10%	Jennifer	Excel Worksheet Functions	2	January 31st 07 08:56 PM
adding	A.S.	Excel Discussion (Misc queries)	1	December 6th 06 09:35 PM
Adding * to the end	Lin Light	Excel Discussion (Misc queries)	0	March 14th 05 10:41 PM

All times are GMT +1. The time now is 07:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us