Excel - return a picture or range rows as the result of a formula
I want to be able to return either a range of rows or a picture dependant on
the result of a formula. ie if the sum of b6is10 return rows a1:d1. Using
the if function I can return a single cell but need to return more than one
or else make a picture and return that.
|