tally marks

**StrawberryFields** · 04-12-2011, 12:51 PM

Hello,

I have a project I'm working on where I have to tally survey results.

Is there an Excel function that will allow me to tally the old-fashioned way - something similar to 1111 with a hash mark across to symbolize 5 votes?

I'm just looking for an easy way to tally a messy survey that has several possible answers for each question.

**ChemistB** · 04-12-2011, 01:22 PM

No, there is not. Check out my workbook below. "X"'s are added to Column A (Between A2 and A50) by doubleclicking on the cell. The number of X's are counted in Column B. Is that something you could work with?

Macros must be enabled for this to work. The code is in Sheet1 module and is

Please Login or Register  to view this content.

**Sadath31** · 04-12-2011, 02:29 PM

you can use below formula to get tally mark from a given value,
=REPT("||||| ",INT(A1/5))&REPT("|",MOD(A1,5))

**StrawberryFields** · 04-12-2011, 06:08 PM

Wow. You guys go much deeper with Excel than I can! I'm afraid most of what you've offered is over my head!

ChemistB, I looked at your spreadsheet, and this formula seems to work just fine (unless I'm missing something important):
=IF(C12>0,LEN(C12),"")

Thanks!

**StrawberryFields** · 04-13-2011, 11:32 AM

I have one more question on this topic.

I've set up a 2nd sheet that looks up the tallied totals from the 1st sheet. Each question has 5 answers, and I want to just see the answer that received the most votes for each question.

Is there a formula to have Excel look at the 5 answers and display the one that is the biggest number?

**jwright650** · 04-13-2011, 11:39 AM

You probably need to use =MAX

Here is a list of functions and descriptions for Excel.

**ChemistB** · 04-13-2011, 11:40 AM

Yes, are we talking about comparing numbers in 5 cells (let's say A1, C4, D7, F9, G12)?

Then
=MAX(A1,C4, D7, F9, G12)
Is that what you are looking for?

**StrawberryFields** · 04-13-2011, 01:54 PM

Yes! That's it! Thank you!

P.S. ChemistB, thanks for the tip on how to mark thread as SOLVED.
jwright, thanks for the link to the functions and descriptions. I'll spend some time with that.

**SherEware** · 02-24-2014, 03:22 PM

Thank you so much for this formula!
Is there a way to assign a value so I can do a partial. ie: "X" has a value of one, but if I need a value of 0.5 (1/2) also.

**arlu1201** · 02-28-2014, 01:10 AM

SherEware,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.