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
Bookmarks