Excel Tips and Tricks - Compare Two Lists In Excel

Excel Tips and Tricks - Compare Two Lists In Excel

Learn how to compare between two list of datasets and highlight them.

Here are the steps.
1) Select both column of cells.
2) Ctrl+G (or F5)
3) Special
4) Row differences
5) Ok
6) Highlight cell

Compare Two Lists In Excel, excel compare two lists and return differences,how to compare two inventory lists in excel,excel compare two cells text,excel formula to compare two columns and return a value,how to compare one cell with entire column in excel,how to compare two columns in excel and highlight the greater value,

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips