Hi guys, I'm not sure if there's a way, but I have several positions that include the name 'President' in my spreadsheet. I only want the actual President, not the SVPS referenced as I have been getting. Is there a way to do this? Thanks
| 2022 CONTRACT EXCEL 6.xlsx | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | John Doe | President | Attention | ||
| 2 | Jane Doe | Senior Vice President | Attention | ||
| 3 | John Jones | Senior Vice President | Attention | ||
| 4 | Jane Jones | Secretary | |||
Sheet5 | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C1:C4 | C1 | =IF(ISNUMBER(SEARCH("President",B1:B4)),"Attention","") |
| Dynamic array formulas. | ||
