John Darby
asked on
XLSX lookup value in cell
I have a list of 300 items where the Ticket Title column has various descriptions. I have created a column which I want to do a search against each adjacent Ticket Title field (same row) for existence of "SQL", with no quotes. I want it to return a 1 for EXISTS and 0 for NOT EXISTS. can you help me form the filter statement?
Thank you!
JohnD
Thank you!
JohnD
Can you upload a sample of the data?
ASKER
Surely can...
samplesheet.xlsx
samplesheet.xlsx
Now that we can see what you see:
What is the exact criteria you are looking for? How do you know which word you will be searching for for example?
What is the exact criteria you are looking for? How do you know which word you will be searching for for example?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works like a gem; thank you!
Glad to have helped!