top

I am trying to find where the top 3 values in a range are stored. That part is done, however, if one or more of the top 3 have the same value, I only get the same cell locations and not the top 3. Here is how my data looks like: <tbody> A B C D E F G H I J <tbody> 0.22 </tbody> <tbody>...

Hi all, Using Excel Office 365. How can I sort a Pivot Table on 2 Columns? I have a count of work tasks and an SLA from 0% - 100% I want to sort the Pivot so the Top 20 opportunities are at the top where a low SLA count with a high work task count should be near the top. If the SLA is high...

I have a spreadsheet that has a rather large logo at the top. The logo is of where I work and I want the screen to rows 5:10 to free at the top of the screen so they will always be visible but anything above row 5, I want to scroll up as you go down the page. How do I do this?

Is it possible to modify the cells located in the "rows to repeat at top" when printing each page Thanks. Jim

B2:B9 is +ve Integers C1 is Value Output Required in D2:D9 as TO FILL VALUES STARTING D2 & Considering range B2:B9 TOP DOWN Thanks in advance Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH...

I know how the title sounds LOL. I play in a mixed dart league. I have a page that has stats of the highest scorers but they are mixed. I would need a suggestion where in 1 column I have all the players in which I sort from highest scorers from the week and in my results page I can have 1...

How can I go about creating a subgroup listing of the top 2 The data Name a a b b b c c d d d d output to starting range("G15") Top 2 D = 4 B = 3 Even the simple stuff sometimes seams difficult

So I'm trying to create a query that will produce an average (totals) column based on the TOP 3 records associated with two other key field values. Basically an average of the three most recent events. I can easily create the query to do the OVERALL averages, but whenever I try to use the...

Hello Team! I am new to the forum though i use to regularly get help from the posts as a guest. I am hoping a question of mine would be solved:) I have a table with lot of data of opportunities in Pipeline from different departments in the organization, i want to get the Top 10 values based on...

hello looking for a formula to find what the average is for the top 20% of clients, middle 20% bottom 20% etc for example if column A lists a bunch of % and Column B had a list of $ values, what is the average for the top 20% in column A, middle etc <tbody> Column A Column B Change % $ Value...

I have 2 sheets, one with a list of employee names and numbers the other with a list of errors made (this includes duplicate names/numbers) what I am trying to do is on a 3rd spreadsheet highlight the top 3 employees for each error, as this may change daily depending on how many errors occur...

hello i have a range of data in column A, A2:A159, i am trying to find out the average for the top 10%, top 25% middle 50% and bottom 25%. is there a formula i can use for this, example below <tbody> Column A Column B % Growth Start Balance 32.78% $100,700 16.52% $122,245 </tbody>

How do I setup a rank, type formula, to exclude subtotals? I am trying to pull a top 10 list. if I do a subtotal on the original data, I lose most of my top 10 values.

Hi all, I am new to coding and programming and would appreciate any suggestions you can give me in creating my first real code. So here i want the solution of how to download the 52 week high and 52 week low of a particular company into excel using the vba code. That's really all I am...

HI All I created a userform and added buttons to open different sheets. they seem to work OK ,but the form is ALWAYS on top .' How do I get the form to the back and the selected sheet to be active? TYVM

Hello, I'm trying to find out how to display only the Nth result in a query. I have a query currently that shows all Categories of question types possible, assigns a random integer and limits the results to the top 5. On my form I want to display each of those results in a separate box. The...

Hi All, I have an unusual yet important question. My question is: I obtained the marks of about 150 students, in 4 different subjects. I have them in the list with 3 columns; first column is "Subject", 2nd is Student ID and 3rd is respective marks in the particular subject. Issue here is I...

Hi everyone, I have a large data set where on some sheets, a filter has been applied to the top row. However, on some sheets, no filter has been applied to the top row. I would like to have all top rows filtered. Can IF statement be used to check whether the top row has filters already...

Hello all, Here is the code for any active cell to get left connector. 'left direction l = (ActiveCell.Offset(0, -1).Left) r = (ActiveCell.Offset(0, 0).Left) t = (ActiveCell.top + ActiveCell.Offset(1, 0).top) / 2 Set con =...

I have an estimating spreadsheet that we use to estimate jobs. There are 80 sheets, all identical. The sheets can be quite long, and to prevent scrolling, I froze the top row, and added some hyperlinks (using the formula =hyperlink). The links I have are Top, Materials, Labor, Summary...