Hello, first time here, so I am not sure exactly what to write, but hear goes.
I have a spreadsheet to report on
appointments booked and closed, the data is exported from a CRM to excel and then the excel spreadsheet formats this into
various reports. Appointments can be post QA'd and as such need to count for two different people as they will both have the
sale recorded against them. To this end I have it all working except for when there are two different people;
there is one spreadsheet with all the raw data, and then the report which pulls the data with various formulas for each
person such as;
So if the value in Ex is "Sasha Hopkins" and the value in Dx is "Aida
Omerovic" then it retuns 1 result and counts up until it gives the total number of appointments for Sasha that were booked by
This works fine, but sometimes there will be a value in Opportunities!$D:$D that may be;
Omerovic, Vahe Kassardjian"
In this case I would still want it to count this figure but of course because the
strings are different it returns a result of 0 instead of 1 and does not count it. How can I get it to look for "Aida
Omerovic" within any part of Opportunities!$D:$D whether it is the whole cell or simply part of the cell? I can then
replicate this for each cell in the report and do a replace x with y and it should be easy, I just need to know where to
start if possible.
I have had a look at the find and search and they seem related to what I need but I am unsure
how to implement them.
Any help would be greatly appreciated!