kbay808
asked on
How to search a column of values in excel and check if value “A” is ever directly preceded by value “B” via a formula resulting in a true or false or via vba?
I have a file that has the data from a work log. I need to identify if any of the 3 sets of values are listed in order anywhere within cells “E4:E100” ignoring empty cells. I attached an example file
Example:
Test exact order of pair
1st value: Suspended
2nd value: WIP to Open
Dataset:
Unsuspended
Suspended <==========
(Result: True)
WIP to Open <==========
Open to WIP
Suspended
Open to WIP
WIP to Open
Example.xlsx
Example:
Test exact order of pair
1st value: Suspended
2nd value: WIP to Open
Dataset:
Unsuspended
Suspended <==========
(Result: True)
WIP to Open <==========
Open to WIP
Suspended
Open to WIP
WIP to Open
Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you can add a column, you can use SumProduct as in attached file.
Example1.xlsx
Example1.xlsx
ASKER