Posted to microsoft.public.excel.misc

Dave 2005

Posts: n/a

Help needed with this formula

Hi

I need to copy this formula down column B1 to B10546 and yet =Q1 must change
only to correspond to each row, Q2,Q3,etc.

I need Q1:Q$10546 and B1 to B10546 to stay the same

Hope I've been clear.

{=MCONCAT(IF(Q1:Q$10546=Q1,MOD(B1:B$10546,10),"")) }

Microsoft Excel 2002

Thanks in advance

Dave

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
Formula Help Needed	BDY	Excel Discussion (Misc queries)	3	October 26th 05 05:35 PM
Formula needed	audi	Excel Discussion (Misc queries)	4	August 3rd 05 12:09 PM
More Help Needed with Count formula	Greegan	Excel Worksheet Functions	4	July 31st 05 06:31 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula needed	Edgar Thoemmes	Excel Worksheet Functions	3	January 13th 05 02:07 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us