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

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.

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.