Saved Bookmarks
| 1. |
Solve : how to find a character in a given range of cells in Excel? |
|
Answer» GOOD evening all, I am writing a simple program to find if there is a speicifc character in a given range of cells in Excel. Here is an example: From cells A1 to D10, there are 40 random characters, from A to Z. Let say, if a character B is found, then it will return 2; and it will return 3 if a character C is found, and so on. If a character happens more than once, for example, character B is found in cell A4 and cell D9, a number 2 will be RETURNED instead of 4. Here is what I can think of: =IF(A1='B', 2, 0) I don't know how to move on. Could you help me out please? Thanks in advance! KittyVLOOKUP might WORK here. Have a look at THIS thread. 07 should allow you to do this, but I dont really recall unless your using an older VERSION. |
|