Posted to microsoft.public.excel.misc

Johnny

external usenet poster

Posts: 126

How to combin rows.

anyone know how create like look at all columns and fnd text then combin that
row and put it in different column.
like this is what I need, but this only can do it in the same row:
=IF(D125="FISH",A1&","&B1&","&C1&","&D1&","&E1,"")

exsample: there are many rows that has (fish), I want to look at all columns
and find the rows has(fish), combin that row, and by order put it at column
M1,M2,M3....

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
Combin	Andreas	Excel Worksheet Functions	25	July 25th 06 05:59 AM
=combin function	Jerry Kinder	New Users to Excel	3	February 25th 06 01:53 AM
=combin function	Jerry Kinder	New Users to Excel	2	February 24th 06 09:47 PM
Replace or Substitute for COMBIN function	Jaja	Excel Discussion (Misc queries)	6	January 1st 06 02:18 PM
Questions on combin and permut	mac_see	Excel Worksheet Functions	5	March 15th 05 07:28 PM

All times are GMT +1. The time now is 02:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us