katkth7533
New member
- Joined
- Jul 29, 2014
- Messages
- 17
- Reaction score
- 0
- Points
- 0
I am trying to figure out a solution for the following scenario: I have a spreadsheet with multiple rows and columns of data. I want to come up with a formula (or macro?) that will search the data that is entered in cells A2, A4, A6, A8, A10, A12 and insert the highest "level" results in cell A1 based on a hierarchy. Cells A2, A4, A6, A8, A10, A12 will either have "Level 1", "Level 2", "Exempt" or nothing entered. I want this formula (or macro?) to look in those cells and insert the highest "level" entry of my list, which is "Exempt", into cell A1. If there are no "Exempt" entries in the target cells, then it should insert the next highest level it finds ("Level 2"). If it doesn't find "Level 2" in the target cells, it needs to look for "Level 1" and insert that. If all target fields are blank, it will leave cell A1 blank. I have over 800 rows in the spreadsheet (each for a different vendor), so this formula or macro would have to be replicated for each row.