How to do a count of entries on a spreadsheet, but only return the results for items that appear more than a certain number of times.

[#1]

Hi, if I wanted to count the number of entries in a speadsheet, but I only want to include the results if the count is greater than a certain number. ie. I only want to get the results back for all items that appear more than 4 times. Can anyone help me with this. Thank you very much!

[Frank_Hartmann]

Please share a sample qwv in which you show your problem.

otherwise it would be diffcult to give precise help!

[#3]

Names
Will
Will
Will
Emma
Emma
Emma
Charles
Gary
Phil
Names	Count
Will	3
Emma	3
Charles	1
Gary	1
Phil	1

Thanks for your reply. As a basic example, i have attached the above table of names. Suppose I wanted qlik sense to only show me the names that appear 3 times or more (ie. only Will and Emma), do you know a formula for achieving this? Hope this makes sense and thank you again very much for your help.

[Anonymous · Accepted solution]

have you tried something like

if(count(Names)>2, count(Names), null())

[#5]

Thats great. Thanks so much.