Warren has attended:
Excel Intermediate course
Data Comparing
How do you compare data from two different worksheets to see if it appears on both of them?
RE: Data Comparing
Hello Warren,
My name is Greg Eze and I am one of the trainers at BEST.
One of the ways which you can compare data is by:
a - firstly creating a third worksheet in the same workbook,
b - using an IF statement e.g. =IF(Sheet1!A1=Sheet2!a1,"Same data","Not the same data") - this is just an example.
Is it possible for you to give me an example of the type of data you wish to compare.
Thank you
Greg