Hi everyone,

I am trying to set up a worksheet which will be used at my workplace to count yeast cells under the microscope.

The numeric keypad will be used, where every time '1' is pressed,it will be for a live cell. Every time '2' is pressed, it will be for a budding cell and everytime '3' is pressed, it will be for a dead cell.

The particular spreadsheet cell with thus have a series of 1's, 2's and 3's anywhere from 100 to 600 caracters long.

I would like to know if there is a formula I can use to extract from that cell the number of times the number 1 appears, same thing for 2 and 3.

Once I know how many times each digit appears in the endlessly long number, I can perform the calculations I need.

Thanks in advance for your help, it is very much appreciated.

Gilles Lajoie