Posted to microsoft.public.excel.worksheet.functions

Tracey

external usenet poster

Posts: 78

Concatenate: in an IF Function

hello

I have 5 columns that I need to concatenate IF there is a value and if the
value isnt already in the other cells i.e:

A B C D E Conatenated:
UK France Japan UK Italy UK, France , Japan, Italy
USA USA
France Singapore Italy Spain France, Singapore, Italy, Spain,
UK France UK, France

Any help will be appreciated

Thank you!
T

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
Using the concatenate function	BIAKathy	Excel Discussion (Misc queries)	3	January 8th 09 11:46 PM
CONCATENATE FUNCTION!	pyager	Excel Worksheet Functions	4	September 29th 08 05:12 PM
CONCATENATE/& Function ?	Ash	Excel Discussion (Misc queries)	5	February 23rd 07 04:57 PM
Concatenate Function	BenG	Excel Discussion (Misc queries)	3	September 21st 06 10:08 PM
Concatenate function in vba	camerons	New Users to Excel	3	June 15th 05 12:09 AM

All times are GMT +1. The time now is 04:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us