top 10 list

Hi, I am currently building a top 15 list for a report which is based off a table of data. Currently i have the below formula but it is only showing the first item when there multiple of the same value. My formula...

I have source data which copied as values....I am trying to work on some top 10 by values, by region and oldest date....for example assume I have data in column A to D ...A column contains region and B column contains Customer and C column contains Date and D column contains values...

I run reports for ticket analysis in Excel using exports from a case management system (very limited report functionality in an old system). I build up a set of data, each week/month adding the latest resolved/new cases within the period. From that I create a worksheet using CountIFS to...

For example, a product table has thousands of product numbers in the rows, but the unique product code distinguishes certain categories of the items by the third letter being A for Antennas, B for Brackets, C for Cones, and so on for dozens more, with numerous sizes and models available in each...

Hi all, I'm trying to find a dynamic way to get the top 10 books used in a library based on the length of time they've been checked out. The entries are logged with a date/time stamp via a command button on a form. The people have the opportunity to check in and out three books at a time. I'm...