G
Guest
Is there a way to retrieve the text content of a cell in the same way that a
SUMPRODUCT function will retrieve numeric content? If not is it possible to
retrieve the ROW number of the cell in a SUMPRODUCT (?) in order to use it in
an INDIRECT function?
I need to retrieve content from a cell (both text and numeric) according to
a combination of values (criteria) in other cells in the same row.
SUMPRODUCT function will retrieve numeric content? If not is it possible to
retrieve the ROW number of the cell in a SUMPRODUCT (?) in order to use it in
an INDIRECT function?
I need to retrieve content from a cell (both text and numeric) according to
a combination of values (criteria) in other cells in the same row.