In Excel trying to compare two ranges
I have a three sheet excel document I want to compare a cell range on sheet3 if any of the cells in the range of C2 - G2 has the same value as any of the cells in the range of A10 - S10 I want to return a value of x on sheet 1.
Computers & Internet - Oracle - Database Enterprise Named User Plus
Answers & Comments
I imagine that the only way is with VBA coding. This is possible if you know programming in Excel (VBA - Visual Basic for Applications).