ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Concatenate formula (https://www.excelbanter.com/excel-discussion-misc-queries/248116-concatenate-formula.html)

Bricky

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.





All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com