Hello,
I'm trying to add a column to a table to use for a sum of the unique items in a pivot table.
I have seen a couple of formulas that will return a 1 for the first cell and 0 for all others that match, one such formula is
I need to take this a step further and include a mid formula so that I can have the formula look for specific text within the cell.
One issue that I'm trying to solve for is that my data is a list of the previous day's emails and the text field I'm looking at is the subject line.
If I have multiple emails with the same subject I want it to be able to ignore any RE: or FW:.
I've been playing around and have what I think it should be
but it doesn't return consistent results. Do I need to have a separate column to parse out the substring first and then use the countif on that?
Thank you in advance.
Tristan
Bookmarks