I have a spreadsheet with 6 text columns in 2 sets. 1st set is column A,B,C. 2nd set is column D,E,F.
The columns have data populated from a drop down list.
Column A and D have the drop down options: Yes, No
Column B,C,E,F have the drop down options: Automated, Advanced, Intermediate, Basic, N/A
I want to compare column A to D; B to E and C to F and o/p a numeric value based on each comparison in column G, H & I.
i.e. compare column A to D and o/p in column G
Compare column B to E and o/p in column H
Compare column C to F and o/p in column I
Example:
A D Value to be outoput
Yes No 0
Yes Yes 1
No Yes 2
No No 3
Column B Column E Value to be outoput
Automated Automated 0
Automated Advanced 1
Automated Intermediate 2
Automated Basic 3
Automated N/A 4
Advanced Automated 5
Advanced Advanced 6
Advanced Intermediate 7
Advanced Basic 8
Advanced N/A 9
Intermediate Automated 10
Intermediate Advanced 11
Intermediate Intermediate 12
Intermediate Basic 13
Intermediate N/A 14
Basic Automated 15
Basic Advanced 16
Basic Intermediate 17
Basic Basic 18
Basic N/A 19
N/A Automated 20
N/A Advanced 21
N/A Intermediate 22
N/A Basic 23
N/A N/A 24
I have attached the spreadsheet.
Thanks.
Bookmarks