Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

A consolidating formula?

Hi again,

Am Thu, 27 Nov 2014 03:50:31 -0800 (PST) schrieb L. Howard:

Thanks again.

you are welcome

You can also try in C1:

=IFERROR(INDIRECT("B"&SMALL(IF(B1:B2000<"",ROW(1: 2000)),ROW(A1))),"")
and insert the formula with CTRL+Shift+Enter and copy down

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
consolidating data - 3d formula changes from what I type in	dorsecraig	Excel Discussion (Misc queries)	1	August 12th 09 05:57 AM
Consolidating a formula	juliejg1	Excel Worksheet Functions	0	December 18th 07 10:11 PM
consolidating my BOM	James Smouse	Excel Programming	2	July 22nd 05 07:44 PM
Consolidating???	neil	Excel Discussion (Misc queries)	1	February 14th 05 12:51 AM
Help with worksheet consolidating	Malcolm	Excel Programming	1	August 8th 03 03:58 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us