Search a row for cell formatted as currency
I'm looking for a method or formula to return a value from within a row if a cell within that row is formatted as currency. The currency cell is not in the same column for each row and there are multiple numbers in the row that are not currency. Also the currency cell itself does not actually contain a currency symbol like "$" although it is displayed that way.
I've tried =MATCH("$*",A7:S7,0) and that does not work as, like I said, there is not really a currency symbol in any of the cells.
Any ideas?
|