how to insert tally mark in excel


S

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.
 
Ad

Advertisements

G

Gord Dibben

You mean like a checkmark?

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


Gord Dibben MS Excel MVP
 
S

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... :)
 
D

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

Gord Dibben

Thanks Sheeloo

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


Gord
 
Ad

Advertisements

Joined
Sep 17, 2013
Messages
1
Reaction score
0
Sheeloo,

Thank you very much for the Tally font and especially the formula to translate regular numbers into tally marks. I am a 4th grade teacher and needed to both demonstrate the tally marks as a ways of collecting and recording data and the actual value of the tally marks to create charts.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tally function in excel 1
Tallies 1
Formula in excel to run a tally 1
tally 1
excel does not mark cell with inserted comments. 2
Tally feature 2
How to count/tally entries? 1
Array tally 3

Top