Since a pivot table changes in size, I can't use a formula referencing a specific cell. I'm trying to figure out a way to write a formula that will seach a column of a pivot table for a specific text string, and if it exists, use the value in the next cell in a calculation. The pivot table has two columns and resides in column L and M.
So basically, what formula would I use if the word "Special" is found anywhere in COLUMN L of a pivot table, and if so, it will take the value found in the next cell in COLUMN M, and divide it by the value found in J25.
Bookmarks