Avatar of wfcrr
wfcrrFlag for United States of America

asked on 

Excel problem

See the attached excel sheet. One of you brainiaks came up with formula I have in Column H.  All I know how to do is paste it into column H and then go find the differences.  It helps me find numbers that don't match and I use this to reconcile our Amex account. Anyway, today something is wrong.  Normally after I run the formula in column H, it will say "false" when it encounters a difference. I have isolated all the difference and removed them to Column E.  Now that I have done that, column F should have the same total as column G.  But they are off by a couple dollars. Why?  Maybe I am just stupid today, but can't seem to find any cell in F or G that doesn't match. match-formula.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
Jacques Geday
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

If you use this formula somewhere at the top (not in column H)

=MATCH(FALSE,H:H,0)

That will tell you the first row with FALSE in column H - I get 2292 - that row and the next 4 are all FALSE

regards, barry
Avatar of wfcrr
wfcrr
Flag of United States of America image

ASKER

Hey Barry, I am completely stupid when it comes to excel. Where do I place that formula, exactly?
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo