Compare Data in Two Excel Sheets - Compare Two Worksheets Quickly
This Excel Tutorial explains, How to compare data in two excel sheets with simple formula.
We can compare two data sets in 2 excel sheets using simple if formula.
Formula used in tutorial is : =IF(Sheet1!B2=Sheet2!B2,"True","Sheet1 : "&Sheet1!B2&"Sheet2 : "&Sheet2!B2)
Пікірлер: 7
very helpful, thank you!
thank you
@ExcelDestination
3 жыл бұрын
You're welcome
Unbelievable.........10000000000000000%....👍👍👍👍👍👍👍👍👍👍
Very helpful thank you so much
@ExcelDestination
3 жыл бұрын
You're welcome!
is mai filter kistra kare ke row per click kar ke + ya - (plus ya minus) row show kare jesa conolidation ki tara