Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Tally marks in an excel worksheet
Is there a way to use a tally mark type system in an excel spreadsheet?
|
#2
|
|||
|
|||
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, though.) jkahn wrote: Is there a way to use a tally mark type system in an excel spreadsheet? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
how do I name ranges in an Excel worksheet | Excel Worksheet Functions |