Tally marks in an excel worksheet




Dave Peterson

Do you mean have 7 in a cell (say A1) and have:

||||| ||

show up in B1 (say).

If yes, then try a formula like:

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

You'll see something like:
†††† ||

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


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 marks 1
How do you use tally marks in Excel? 1
Tally marks 2
Converting a letter to a numeric value 4
Excel Count If Formula Question 1
Tally Survey Result in Excel 1
Survey Tally 1
how to insert tally mark in excel 8