ExcelBanter - How do you use tally marks in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do you use tally marks in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/209844-how-do-you-use-tally-marks-excel.html)

Eileen204

How do you use tally marks in Excel?

I saw a worksheet that had tally marks. How do you get them?

Sheeloo[_3_]

How do you use tally marks in Excel?

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))
__________________________________________________ _______

"Eileen204" wrote:

I saw a worksheet that had tally marks. How do you get them?

All times are GMT +1. The time now is 08:46 AM.