Hello,
I have a column with cells containing the same concatenate formula. I've set a condition with these formulas where concatenate will not occur unless "Best" shows in the column to the left.
I want to be able to display the only concatenate result (which could appear in any of the 300 rows found in the column) in one of my cells.
I would like to stick away from macros or VBA if possible.
Thanks!
I have a column with cells containing the same concatenate formula. I've set a condition with these formulas where concatenate will not occur unless "Best" shows in the column to the left.
I want to be able to display the only concatenate result (which could appear in any of the 300 rows found in the column) in one of my cells.
I would like to stick away from macros or VBA if possible.
Thanks!