See the example attached. I'm trying to make it so the IF formula in A10 will simply place the COUNTIF calculation (that's currently done in B10) in the middle of the sentence without having to reference B10, as surely there's no need to essentially do the same calculation twice. So the "&$B$10&" part of the formula in A10 should just be the formula in B10, but I can't work out how to do this correctly.
Thanks.
Bookmarks