top 5

Hello All, Have a question on how Excel creates charts. Input data: - Daily 'topics' with values. - Topics can vary daily. - Values can vary daily. I create a chart that shows ALL data from lets say January. - March 3rd, AND I choose the top 5 to view. My question is, at the bottom of the...

Hi! I am having some difficulties with my dynamic arrays I need to create two different dynamic arrays, in which I extract the Top 5 values aggregated by "Case". In the first scenario, I would need to obtain the Top 5 values when...

Hi All, I have a pivot table which currently shows the Top 5 purchased products but I only want it to show 5 results, regardless of any tied products. How do I do this? (I'm using O365) Thank you for the help!

How would I go about getting a listing of the oldest 5 dates from a column? Using the formula, it returns the date as a number with count My data in in columns A:F Results from formula in col I =INDEX(SORTBY(UNIQUE(F1:F9)&" =...

Hi, I have my workbook set up to show a separate worksheet for each state. The representative from each state will go into their own state worksheet and select their state from a drop down list. When the state is selected, I need to bring in top 5 past due invoices for that state - data set...

Hi all, I have a spreadsheet with multiple students (males and females) with some scores. I am wanting to create a 'top 5' sheet which shows top 5 males and top 5 females scores. I have found 2 problems with this. 1) Some scores need to be the lowest in the section (e.g. 100m sprint times)...

I am using Excel 2010. My son has a spreadsheet that has several hundreds of rows of titles of artist, songs, song length, rating, and so forth. I want to limit the number of rows to display for each artist, based on their rating. Let’s say, either 5 rows per artist, 10 rows per artist, or...

Hi. I have a table (PipelineTable) with these columns: P Amount I need to extract the top 5 amounts from the rows that meet a criteria: P is a fraction (between 0 and 1). For example, if this is the PipelineTable: <tbody> P Amount 0.5 25 0 50 0.75 45 1 12 0.5 20 0.75 25 0.25 8...

Hey guys. It's been a while! As I've spent the last few years in Access and SQL land, I've gotten a bit rusty in some areas of Excel, and this is bugging me - am trying to do something which should be straight-forward, but is turning into a head-scratcher! I have a risk matrix, which has a...

Does anyone know a way to identify the top 5 item from inside an array? I have an array that contains string values from a range. The range is one column wide and is over 1000 rows long. I am looking for a way to use vba to identify the top 5 strings used in the range. Any ideas would be...

I am trying to create a top 5 list of the most frequent values from a range. I know how to use the MODE function to get the most frequent number in a range, but I want to find the most frequent text...as well as get the next 4 most frequent. For example... My range would be a1:a16 and I need a...