Specified problem description.

Each cell in a column is containing a letter representing a discount value.
This discount value shall be converted into a percentage figure, that again
can be put into a currency calculating formula that finally puts the sales
prize next to the original cell holding the letter.

"JulieD" skrev:

Hi

i think you're after the COUNTIF function
with your column of letters in A1:A100
and the letter you're interested in in C1
then in D1
=COUNTIF(A1:A100,C1)

this will count the number of times the value in C1 occurs in your range.

If this isn't what you're after, could you type out a few examples of your
data and what you want to see in a reply post (please do not attach a
workbook)

Regards
JulieD

"Thorkild" wrote in message
...
Hi,

A selection of 4 different letters in a column representing different
values
to be used in a formula shall be run through. The calculated result of
each
cell in the column shall be placed in the cell next to the read one that
holds the letter.

Thanks in advance.