James has attended:
Excel Advanced course
If and OR Functions
I have a large set of data (250+ columns and 2500+ rows). This contains a few key columns that can contain blank cells in error. I can use an IF and OR function combined to identify rows with blank cells in particular columns. Is there a way for me to display multiple cell references for the blank cells (i.e. A1; D1; etc.) rather than just a word identifier.
RE: If and OR Functions
Hi James,
Thank you for the forum question.
I have attached a workbook with my solution. You can use a combination of the IF Function, the ADDRESS Function, the COLUMN Function and the ROW Function.
I hope this will do the job for you.
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
Find cell reference.xlsx
