How do you use tally marks in Excel?

  • Thread starter Thread starter Eileen204
  • Start date Start date
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
Converting a letter to a numeric value 4
Tally Survey Result in Excel 1
Tally marks in an excel worksheet 2
Tallying more than one list of data into one main control list 1
how to insert tally mark in excel 8

Back
Top