I am new in working with excel and I need help for a formula to get all matched values (in sheet 1) and copying those values in one cell (in sheet 2) with format like following below
matched1, matched2, matched3
I did some work in excel but I couldn't get all matched values listed in once cell, only first matched value is appreared (expected format is shown in the picture)
If anyone could help, I really appreciate it.
Thank you
Last edited by softindo; 01-31-2012 at 03:21 AM. Reason: SOLVED
I can't see the relationship between your two sheets, what are you trying to match?
Your sample result shows A6 (Mapping!C4) what does this refer to?
As a side note
Does this in Report!D2 dragged down give you the answers you need
=$B$1&INT(B2)&$C$1&INT(C2)
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Hi Marcol, my apologies if you get confused.
A X Y Position
A1 2 1 X2Y1
A2 1 1 X1Y1
A3 2 1 X2Y1
A4 2 1 X2Y1
A5 1 1 X1Y1
A6 1 1 X1Y1
A7 1 1 X1Y1
What I would like to achieve basically is a formula to get all values in column A for each position. Values will be stored in one cell and separated with a comma symbol . For example:
Position X2Y1 = A1, A3, A4
Position X1Y1 = A2, A5, A6, A7
I hope this is clear
See if this workbook gets you started.
1/. Concatenation is always limiting with Excel formulae. Do without Column N if you can.
2/. The formula in H2 is an array formula and must be confirmed with Ctrl+Shift+Enter not just Enter before Dragging Right then Down.
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks