•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is it possible to give a formula to mark the differences between Columns A & B?
Our take
If you're looking to identify differences between Columns A and B in your spreadsheet, you're in the right place. In Google Sheets, you can use the formula `=FILTER(B:B, ISERROR(MATCH(B:B, A:A, 0)))` to find values in Column B that are missing from Column A. For Excel, the formula shifts slightly to `=IFERROR(INDEX(B:B, MATCH(0, COUNTIF(A:A, B:B), 0)), "")`. This approach empowers you to streamline your data analysis, ensuring you capture every crucial figure in your datasets.
Please suggest a formula for Google Sheets to find the missing (or extra) figure in B. Would the formula differ for Excel?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience