Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel advanced
Resolved · Low Priority · Version 2003
Emmanuel has attended:
Excel Advanced course
how to find mismatching numbers between 2 range values
Hi Emmanuel
How are you sorry i didn't get back to you earlier
the best way to do what your looking for is as follows:
the formula is an IF statement like this one,
=IF(b4=c4,"true","false")
This should do the trick
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
|
|
Excel tip:Using basic functions without doing formulasWhen you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
