Posted to microsoft.public.excel.misc

Lisa

external usenet poster

Posts: 328

Formula Help-ASAP

I need a formula that would concatenate only the blank cells between two
rows that have data. If the line below 10001 is blank (A3), concatenate all
the rows in B whose A value is blank.
I am using this formula =IF(A3="",B2&""&B3&""&B4&"",B2)
The problem is that sometimes, I might have two or more blank cells below
10001.
Could someone help!

Thanks!

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
NEED ASAP	Vick	Excel Discussion (Misc queries)	1	May 1st 07 09:12 PM
ASAP - need help with formula!	Jane	Excel Worksheet Functions	7	February 6th 07 05:51 PM
Complicated formula please help asap!	babiigirl	Excel Worksheet Functions	8	June 14th 06 04:26 PM
Need help asap	potsie	Excel Discussion (Misc queries)	3	April 11th 06 09:39 AM
Need a Formula ASAP	Korie	Excel Worksheet Functions	8	October 6th 05 04:48 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us