Dan has attended:
Excel Intermediate course
Excel Advanced course
Excel Financial Modelling course
Compare two columns - =IF(COUNTIF($F:$F, $E) <>0, "-","different
Hi there,
I need to submit this sheet but I must compare two large columns to spot VALUE differences.
I try to use
=IF(COUNTIF($F:$F, $E) <>0, "-","different Value"
Not sure why is not working. You may have an alternative method and will be easy if the value_if_false was red.
Help please.
Many Thanks,
Dan
RE: Compare two columns - =IF(COUNTIF($F:$F, $E) <>0, "-","diffe
Hi Dan,
Thank you for the forum question.
Please find the attached workbook and have a look at sheet 1.
You are very close. I have used conditional formatting to highlight in red all different values.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
diff.xlsx
