how to insert tally mark in excel

[shawn]

how to insert tally mark in excel

 

[Shane Devenshire]

Hi,

Since you didn't show us what you have or what you want displayed, suppose
A1 contains 6 and you want to see |||||| in B1

=REPT("|",A6)

We can't put a slash though every 5.

 

[Gord Dibben]

You mean like a checkmark?

Format the cells to Marlett Font then type an "a" without quotes.


Gord Dibben MS Excel MVP

 

[Sheeloo]

The process is slightly complicated ...

1. You need to install a FONT which supports tally marks...

You can get one from http://www.subtangent.com/maths/resources/tally.zip

Download the zip file and extract the ttf file and put in C:\Windows

2. Now you need to convert your numbers like this

1 to 1
..
..
6 to 51
7 to 52
..
..
11 to 551
and so on
which you can do using a formula like

=REPT(5,INT(A1/5))&MOD(A1,5)
in cell B1 with your number in A1

Now put this in C1
=B1

Copy the formulas in B1 & C1 down if you many numbers...

Now choose the TALLY FONT for Column C

That is all...

 

[Dave Peterson]

Saved from a previous post:

I like this one (it simulates the cross mark on the 5th entry):

=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.)

 

[Sheeloo]

Gord,

Tally marks are a quick way of keeping track of numbers in groups of five.
One vertical line is made for each of the first four numbers; the fifth
number is represented by a diagonal line across the previous four.

See http://www.enchantedlearning.com/math/tally/

 

[Gord Dibben]

Thanks Sheeloo

I had sort of sussed that out from watching the other posts but you just
confirmed it.


Gord

 

[PJ]

Thanks Sheeloo

I had sort of sussed that out from watching the other posts but you just
confirmed it.

Gord




- Show quoted text -

Check out this link!

http://www.mrexcel.com/forum/showthread.php?t=284515&highlight=tally+Marks