how to insert tally mark in excel

Discussion in 'Microsoft Excel Worksheet Functions' started by shawn, Mar 7, 2009.

  1. shawn

    shawn Guest

    how to insert tally mark in excel
     
    shawn, Mar 7, 2009
    #1
    1. Advertisements

  2. 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.
     
    Shane Devenshire, Mar 8, 2009
    #2
    1. Advertisements

  3. shawn

    Gord Dibben Guest

    You mean like a checkmark?

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


    Gord Dibben MS Excel MVP
     
    Gord Dibben, Mar 8, 2009
    #3
  4. shawn

    Sheeloo Guest

    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... :)
     
    Sheeloo, Mar 8, 2009
    #4
  5. 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.)
     
    Dave Peterson, Mar 8, 2009
    #5
  6. shawn

    Sheeloo Guest

    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/
     
    Sheeloo, Mar 8, 2009
    #6
  7. shawn

    Gord Dibben Guest

    Thanks Sheeloo

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


    Gord
     
    Gord Dibben, Mar 8, 2009
    #7
  8. shawn

    PJ Guest

    PJ, Mar 9, 2009
    #8
  9. shawn

    pablonet

    Joined:
    Sep 17, 2013
    Likes Received:
    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.
     
    pablonet, Sep 17, 2013
    #9
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.