Identifying trends with =countif?

Jen Castillo

I have a drop down list of about five hundred items that my four vendors can select from. I'm trying to track trends of frequent selections, such as the top five things + how many times it's been selected within 30 days + who has selected what.

I've used =COUNTIFS(Item:Item, "item name", Date:Date, >=TODAY(-30)) in the sheet summary to count specific things on a small scale, but I know there's a solution for large scale data collection that I've overlooked/can't remember.

Could someone point me in the right direction? Thank you!

Ramzi K

@Jennifer Castillo

How does the vendor select at item? Is this one item per row? i.e. every time a vendor selects an item, it's a new row in your sheet?

If that's the case, you will need a separate sheet with a row for each item and then use your formula in the second column in that sheet to do your countif on your vendor selection sheet.

I hope that makes sense and helps you. If not, I can put together an example for you.

Cheers,

Ramzi

Jen Castillo

@Ramzi K

Yes! We have our vendors fill out a form which generates a new row in my vendor sheet.

Your answer does make sense!

I've set up a separate sheet with all the choices, and I think I have an idea of what to do next, but any examples you can give would be greatly appreciated.

Thank you!