top 5

I need the sheet "Top 5" to list the top 5 records from the sheet named in cell C2. The returned top 5 records should be based on the "Amount" (column B) and include only the records that fall into the fiscal quarter mentioned in cell C3 on the sheet "Top 5". If there are duplicate "Amount"...

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...