| View previous topic :: View next topic |
| Author |
Message |
robertkraus
Newbie
Joined: 13 May 2010
Posts: 4
|
 Posted: Sat May 29, 2010 11:11 am Post subject: [solved] a function like MODE for text |
 |
|
I am searching for a function in calc that checks the contents of cells in a range and returns me the most abundant entry. I searched for a while until I hit MODE. But this only works with numbers. What is a function like that for text?
What I have looks like this
| Code: |
A A G G T G A
A A A C C T -
- A T C C T -
A A A C C T -
|
Now I'd like to get a row that returns me the msot abundant character per column. A row like so as result:
Last edited by robertkraus on Sat May 29, 2010 2:40 pm; edited 1 time in total |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Sat May 29, 2010 1:11 pm Post subject: |
|
|
| Try =CHAR(MODE(CODE(A1:A3))) |
|
| Back to top |
|
|
robertkraus
Newbie
Joined: 13 May 2010
Posts: 4
|
| Posted: Sat May 29, 2010 2:40 pm Post subject: |
|
|
That's a cool trick! I am lucky that I only count over single letters  |
|
| Back to top |
|
|
|
