How to find the Top 5

Serenidy

I am trying to find the top 5 majors. I created a "helper" column as some have suggested in other posts. This column gave a number for how many people are in school for that major. Now I just need a formula to find the top majors.

Amber Eakin

Hello, @Serenidy ! I have two possible options.

1. Rather than a Helper column, I'd recommend a separate sheet. You could use the type of formula you would use for the Helper column, but it would be in a separate sheet that would list only the majors. That way, you could then sort by the totals column.
2. Alternatively, do you have Pivot Apps? That would be perfect for this.

https://help.smartsheet.com/articles/2476736-get-started-pivot

Amber Eakin

Hello, @Serenidy ! I have two possible options.

1. Rather than a Helper column, I'd recommend a separate sheet. You could use the type of formula you would use for the Helper column, but it would be in a separate sheet that would list only the majors. That way, you could then sort by the totals column.
2. Alternatively, do you have Pivot Apps? That would be perfect for this.

https://help.smartsheet.com/articles/2476736-get-started-pivot

Serenidy

Thank you for your reply @Amber Eakin,

That is a separate sheet I created for the majors. I unfortunately do not have the Pivot App. For the Helper column I used =COUNTIF(Major:Major,Major@row) would I be able to use RANKEQ or LARGE ?

Amber Eakin

I wouldn't; you'll end up getting the same result because you have those items repeating. So everything with 334, for instance, would show up as the largest.

If this is a separate sheet, you could use the Summary fields. You could do a Text field for each major. The formula would be =COUNTIF(Major:Major, "[INSERT MAJOR NAME HERE]"). You would update the major name for each summary field. Then you could see which have the highest.

Serenidy

@Amber Eakin Thank you for your help!

Amber Eakin

@Serenidy My pleasure!