| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count consecutive characters within a cell
assume your data in A1
Create a lookup list A5= AAAA A6= CCCC A7= GGGG A8= TTTT =IF(SUMPRODUCT(--(ISNUMBER(SEARCH(A5:A8,A1))))0,"yes","no") "Jshendel" wrote: I have a genetic sequence such as: AATTCAGTTACTTTTGCA I need a formula that will tell me if this cell has a run of 4 or more consecutive letters. The run can consist of 4 or more A, T, C, or G. The above example can return simply as "yes" or can be as complex as "this cell has 4 consecutive T's" Thanks, Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count the number of characters on a cell? | Excel Discussion (Misc queries) | |||
| Count Characters with space in a cell | Excel Discussion (Misc queries) | |||
| count of tab characters in a single cell | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
