# How to find the Top 5

✭✭✭

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.

Tags:

• ✭✭✭✭✭✭

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.

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭✭✭✭

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.

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭

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 ?

• ✭✭✭✭✭✭

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.

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭

@Amber Eakin Thank you for your help!

• ✭✭✭✭✭✭

@Serenidy My pleasure!

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!