Prev: ordeing columns
Next: ranking numbers in a column
From: Dave Peterson on 18 Jan 2010 12:24
You got your answers, but here's an alternative that I like:

=REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5))

With 7 in A1, you'll see something like:
���� ||

(nice if you're using Arial--not sure how it'll show up in the newsgroup,
though.)



cvgairport wrote:
>
> Ok, here's a toughie. I have a list of numbers in column A and I would like
> in column B a smiliar number of asterisks like this:
>
> 4 ****
> 1 *
> 9 *********
>
> Any ideas?
>
> Amy

--

Dave Peterson
First  |  Prev  | 
Pages: 1 2
Prev: ordeing columns
Next: ranking numbers in a column