Forum Discussion
tviss64
Feb 22, 2021Copper Contributor
Need help with Excel Formula
I have two sheets that have the same headers, A1 Address, B1 City, C1 State, D1 Site ID. Sheet Old has 775 items and Sheet New has 1205. I want to compare address between the two and place the iden...
tviss64
Feb 22, 2021Copper Contributor
tviss64Attached is an example of New, Old and sheet 3, 4, 5 of what I am trying to do.
- Riny_van_EekelenFeb 22, 2021Platinum Contributor
tviss64 Why not manually indicate in your simplified example what you would expect to see in each of Sheets 3, 4 and 5. Including the colours and the logic behind it.
- tviss64Feb 22, 2021Copper Contributor
Riny_van_EekelenGood suggestion. I have added the example in the attached file.
- Riny_van_EekelenFeb 22, 2021Platinum Contributor
tviss64 Great! I'm on my way out now. Gladly leave it to someone else her to resolve. If not, I'll get back to you later.