#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Concatenate formula

Hi
I'm trying to get a formula using concatenate that will identify numbers in
a row 3 (4&5) and returning the name of the column above into one cell. eg

Big small large larger
1 4 5 2

So in one cell I should get [small, large]
I can get this when only looking at one cell but not when Im trying to look
a multiple ones.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
concatenate formula Tacklemom Excel Discussion (Misc queries) 2 June 2nd 09 09:04 PM
Concatenate a Formula Michael Conroy Excel Worksheet Functions 4 June 25th 08 05:12 AM
Concatenate Formula doesn't do its job... Felix Excel Discussion (Misc queries) 4 December 28th 07 11:39 AM
help with formula...if -- concatenate sedonovan Excel Discussion (Misc queries) 1 June 22nd 06 12:31 PM
Evaluating results of a concatenate formula, as a formula dodger Excel Worksheet Functions 5 September 9th 05 01:55 PM


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"