•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Matching lists in excel
Hello, I have account numbers from two different systems - A & B. I want to confirm that these account numbers are present in both systems and if they’re not, which system does not have the account number
Right now they’re in two columns and I’m using =if(isnumber(match but it doesn’t seem to be the most efficient
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#rows.com
#Excel alternatives for data analysis
#Excel alternatives
#account numbers
#systems
#Excel
#matching lists
#columns
#confirm
#presence
#efficient
#IF
#function
#ISNUMBER
#MATCH
#comparison
#lookup
#spreadsheet
#data validation