• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 43
  • Last Modified:

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
0
racepro
Asked:
racepro
1 Solution
 
Ejgil HedegaardCommented:
Use this in D5, copy down
=IF(ISERROR(SEARCH("(NR)",A5)),G5,1001)
Data-NR.xlsx
0
 
raceproAuthor Commented:
Thanks Ejgil,

Works perfectly
Ian
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now