Formula to find and fix data content

Hi,
I would like a formula to locate certain data as per attached spreadsheet
Please use column 'D' for formula
Many thanks
Ian
Data-NR.xlsx
raceproretiredAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
Use this in D5, copy down
=IF(ISERROR(SEARCH("(NR)",A5)),G5,1001)
Data-NR.xlsx
0
 
raceproretiredAuthor Commented:
Thanks Ejgil,

Works perfectly
Ian
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.