top

  1. I

    Looking for Assistance with Formula (Top 30 Values Closest to ZERO) Please :)

    <tbody> 1 <tbody> -0.14 </tbody> top 30 values in column B1-B32 that is closest to 0 2 <tbody> -0.04 </tbody> I want to project it as a formula in C1-C30 3 <tbody> -0.02 </tbody> 4 <tbody> 0.09 </tbody> 5 <tbody> 0.23 </tbody> 6 <tbody> -0.12 </tbody> 7 <tbody>...
  2. WaqasTariq

    'Match' a range, skip a predefined cell

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

    Sort Pivot Table On Two Columns

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

    Can you freeze from a certain cell when that cell gets to the top of the page

    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?
  5. F

    row to repeat at top

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

    Fill values top down

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

    To Separate the men from the women

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

    Subgroup and list top 2

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

    Trying to average last 3 records only (top 3)

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

    MatchIndex for Multiple Criteria and with Duplicate Values

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

    Formula help to find Top 20%

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

    Show top 3 for multiple criteria based on information on two sheets

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

    top 20% formula

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

    Rank - exclude subtotals

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

    How to download 52 week high and 52 week low

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

    Using button in a userform

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

    Show 2nd, 3rd, etc. Result in a Query only

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

    Want to find sum of Top 70% students' marks

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

    If statement and filters.

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

    top vertical connector for active cell instead of left horizontal connector

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top