How do you use tally marks in Excel?

S

Sheeloo

Following was provided by Dave Peterson
_________________________________________________________
I'd put the number in A1 and use this formula in B1:

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

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
Tally marks 2
Excel Count If Formula Question 1
Tally Survey Result in Excel 1
Excel 4
how do I show tally marks in word? 2
Can you tally cells by their fill color? 3
How Excel 2003 Highlight random cells and running tally appear? 1

Top