Learned how to compare to Excel sheet and find differences.

Comparing two data sets in Excel for differences involves looking for variations between the values in each set, which can be done by subtracting one set from the other or using functions like VLOOKUP or IF to identify discrepancies. Comparing two data cells in Excel is simple – you can use conditional formatting to visually highlight any differences between them. You can tell if two data sets are different by checking if their values vary or by using straightforward comparison methods.

Method 1
Conditional Formatting
1) Ctrl + A
2) Home ~ Style ~ Conditional Formatting
3) New Rule…
4) Select /”Use a formula to determine which cells to format/”.
5) =A1＜＞’421′!A1
6) Format
7) Fill tab.
8) Select font color as Red
9) OK
10) OK

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ

Please take the opportunity to connect and share this video with your friends and family if you find it useful.