I have an excel file with the columns subject ID and diagnosis (about 3000 rows).
For each subject ID there are 5 diagnosis: MDE, Manic, Hypomanic, Mixed and Dysthymic.
I need to automate the identification of all subject IDs where at least one of the 5 diagnoses in column B is followed by a number. Please see attached sample file. In the sample file, if at least of of the 5 diagnoses is followed by a number, I highlighted all five.
I would like to have code that would either highlight all five diagnosis for any subject where at least one of the five was followed by a number or copy and paste the subject ID and the data in the adjacent cells in row B into another spread sheet as shown in the sample file (output sheet).