View Single Post
 
Old 05-17-2012, 03:51 AM
poobear poobear is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: May 2011
Posts: 6
poobear is on a distinguished road
Default Calculate differences between text cells?

Hi everyone!

I have several cells with characters (amino acid sequences), but let's simplify to this:

ABCDEF
ABADEF
ABCDEG
ABCDEF

I would like to compare all cells to the first cell and get the difference sort of like this:

ABCDEF: -
ABADEF: 1
ABCDEG: 1
ABCDEF: 0

Then I will calculate these changes to percentage, but that I know..

But how can I get the amount of one-letter substitutions for each cell?

Thanks!
Reply With Quote