| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
identify data in a cell that has a number as the second character
Hello,
In a particular range of cells I have a drop down list that allows me to pick from the following: 1b14, 1a14, 2a15, 2a15, 3a14,3b15, P1, P2, P3, P4 I have the forlmula that states if data starts with a number then return a certain cell. how would I write, If in range b1:c:4, the data's second character is a number then return A1? Thank You, Brian |
|
#2
|
|||
|
|||
|
One way, array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):
=IF(OR(ISNUMBER(-MID(B1:C4,2,1))),A1,"") In article , "Brian" wrote: Hello, In a particular range of cells I have a drop down list that allows me to pick from the following: 1b14, 1a14, 2a15, 2a15, 3a14,3b15, P1, P2, P3, P4 I have the forlmula that states if data starts with a number then return a certain cell. how would I write, If in range b1:c:4, the data's second character is a number then return A1? Thank You, Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify if Cell is Formula or written number | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
