Matching identical entries

[lukela85]

Hi all,

Hoping someone can help as I'm an Excel novice.

Basically what I need my spreadsheet to do is compare data in multiple cells and group the results. So for example if the data in cells in A2:A5 is identical to that in cells C2:C5 then return the values of cells A1 & C1 in another cell. Then to repeat this for up to 70 sets of data. All identical matches would be listed in different cells. So if D2:D5 matched with E2:E5 that would be listed in a separate cell and so on.

Hope this makes sense. Thanks in advance.

Luke

[JBeaucaire]

If you wanted to check if the A2 value was in C2:C5, you could put this formula in D2:

=IF(ISNUMBER(MATCH($A2, $C$2:$C$5, 0)), $A2, "")

Copy that cell down through D5 and your matching numbers would appear. Adjust and repeat as needed for other sets.

[lukela85]

Ideally I'm looking for a formula that would check if all the values in A2:A5 identically matched the values in C2:C5, and then if true group the entries in A1 & C1 (ie the header data) in another cell. Then to repeat this for all sets of data (up to 70). All identical matches would be grouped in cells together with their header data. So if A2:A5 matched with C2:C5 then the values of A1 and C1 could be displayed in A6, then if the data in D2:D5 matched with E2:E5 the values of D1 & E1 could be displayed in D6.

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates manually mocked examples of your desired results.

[lukela85]

Here it is, in a very very basic form.

[JBeaucaire]

"basic form" to me translates to: Whatever solution you come up with won't work in the real form

If this data does not fully represent ALL the variations then I don't want to spend time on it just to have to "fix" it later.

So, whatever is missing from this, add it back in, it needs to be 100% complete example of all the hurdles. More than two matches? Text AND numbers for data? Whatever...

[lukela85]

Marked as solved. No help given.

[JBeaucaire]

Ok, if you change your mind we'll be here.