Excel Compare Cells Between Workbooks

I would like to create a macro that compares cells within Column E and if they are found to be matching then it would check/compare the date fields in Column H and the oldest date the macro would mark "yes" in Column R.

I'm newer to excel and not sure how to do this.

Answers


Assuming that you are creating a formula on Book1 to compare to Book2, then put this formula in Book1, Column R

=IF(E1=[Book2]Sheet1!E1,IF(H1=[Book2]Sheet1!H1,"yes",""),"")

Obviously you would need to change the Book Names and Sheet Names.

What did you mean by "Oldest Date"?


Need Your Help

In app mute for Apple-Push-Notifications

ios iphone notifications apple-push-notifications

My team and I are currently developing an iOS app with push notifications.

How to read large number of files in raw in ANDROID?

java android

I have 201 text files in my raw folder naming level0.txt,level1.txt,level2.txt........