#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Interesting problem. I think I know how I would do it in VBA, but I looked at the options under Excel Find and didn't see anything likely. Seems to me you may have to write your own Excel worksheet function for it.
|
#3
|
||||
|
||||
Try cell("type",A1), cells formatted currency will return a format code starting with C.
|
#4
|
|||
|
|||
formula like =CELL("type",A2) returns "b" for any cell format for me. But =CELL("format",A2) returns depending on format of A2:
General - "G"; Number - ",0" or ",2", etc.; Currency - "C0" or "C2", etc.; Date - "D1" or "G"; Percentage - "P0" or "P2", etc; Text - "G". |
#5
|
|||
|
|||
Thanks for the replies and appreciate the efforts. The CELL function appears to work for only a single cell, not a range or array like I need. I'll go the VBA route for a solution.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Currency Field - Displaying Incorrect Value when Formatted | DarrenE | Mail Merge | 11 | 03-20-2019 01:40 PM |
Search Range Within Cell or Cells | COEngineer | Excel | 1 | 06-01-2016 11:50 AM |
Search the text in 3rd cell by using texts in 2 cells | Shinaj | Excel Programming | 1 | 05-09-2014 09:17 AM |
Search cell text from Excel into ms-word | ShailShin | Word VBA | 1 | 04-21-2014 02:12 AM |
search a list while typing in a cell | virsojour | Excel | 1 | 07-08-2010 03:10 AM |