I am trying to use concatenate formula to summarize my data but my problem is I want to detemine teh concatenate items depending on the preceding column. If i will use 10 in the column B, it will not use the data in column C but will use "10 - Others" insteadquestion_concatentate formula.xlsx
Just added to your formula:
Formula:
Please Login or Register to view this content.
Do you mean in F2 and copy down this?
Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
QUOTE=Fotis1991;3643536]Do you mean in F2 and copy down this?
[/QUOTE]Formula:Please Login or Register to view this content.
Thanks for the reply but I am sorry I was not clear with my question but you almost soved my problem
The formula you suggested is what I want except that the F2:F7 is not showing anything. It should still concatenate the column A, B and C
Ok. Then
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks