top

  1. T

    FollowHyperlink doesn't actually follow =Hyperlink formula

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

    Seperate WS sort highest to lowest

    I have a report that has over 1500 data points. On a separate ws, I want to pull in the top 10 values that are highest to least. how can I do this? Thanks
  3. B

    Vba sort code

    if i had a sheet called 'Results By Customer' and column AK was called % Change. i wanted to build a macro then when you pressed the form it would filter that column by the top 10 customers by that criteria, i would also do another one for the bottom ten ty
  4. H

    (Large Data Set) Filtering out Top 10 Highest/Lowest data points by each day?

    - I have historical data for every NASDAQ stock for two years (~50k rows worth). - I have calculated an 'After-Hours' percentage gain for each of these NASDAQ stocks for the past two years (Column E). - I need to filter out, by each date, only the top 10 performing After-Hours Gainers. Data...
  5. T

    how do i resetthe vba scroll bar to the top position?

    Hi everyone, I'd like a macro that resets the vba scroll bar to the top, I mean the actual bar in the scroll bar, I can do it manually within the properties under value but can't get the vba to set it. can this be done? Thanks Tony
  6. A

    Complicated formula giving "#value" and "You've entered too many arguments for this function"

    Hello, I am trying to figure out why Excel is giving me errors about the new formulas that I am creating. I have an original formula that works and gives me updates: =IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code...
  7. A

    Complicated formula giving

    Hello, I am trying to figure out why Excel is giving me errors about the new formulas that I am creating. I have an original formula that works and gives me updates: =IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code...
  8. C

    Anybody any good with Array formulas?

    Hi I am trying to create a dashboard that gives me the top 5 (and bottom 5) on a number of key metrics. I have put an example table below, but I trying to create a result that will list in order 1-5. Please assume Category is column A, Product is Column B, etc...
  9. N

    how to count streak in range ascending

    i have a column with numbers 0-10. i want to display in a desginated cell. the current streak. as in currently how many cells in a row are greater than 0. from the top. how do i do this?
  10. S

    Create graph based on specific Top N counts

    New to Power BI and trying to figure a way to generate graphs based on specific Top N (other than top 1) count conditions without adjusting filters. The idea would be to have it auto update based on new data each month without having to manually select filters. Example using meal choices out...
  11. J

    Counting the top "x" ammount of cells

    Hi, I have a spread sheet that has the "date" and "volume" in the same row for a market going from newest to oldest. I want to somehow build a driver that i can change the look back but say i want to see listed the top "10" or "20" or "25" highest volume days, how can I do this? As you can...
  12. P

    force PDF save to be at top of page ???

    I'm using the following code to save any worksheet (named with a 5-digit code) as a PDF in a given location .. Dim wPath As String, r1 As String, r2 As String, r3 As String wPath = "G:\Maths Dept\STUDENT RESULTS\2019\PDF Profile Copies\" For Each ws In ThisWorkbook.Worksheets...
  13. S

    TOP 100 by month, need help.

    Hi, I've created a PowerPivot DAX measure to list my TOP 100 Brands. I would like to find a way to see for the month of May 2019 vs 2018 vs 2017. The measure below shows me each year total compared side by side. I would like to have a slicer control the month. TOP 100 BRANDS:=VAR RankingContext...
  14. S

    Condition query

    If I have a filter in a pivot showing top 5 products - is there a way to see what other top 5 products were sold when those top 5 were sold also?
  15. G

    how to substitute a column reference for an If statement

    Hi sht = Me.ComboBox15.ValueIf Sheets(sht).Cells(i, "A").Value = (sht) Or _ Sheets(sht).Cells(i, "A").Value = productCode Then Me.TextBox13 = Format(Sheets(sht).Cells(i, "C").Value, "0.00") I have the above Syntax that looks up a value on a worksheet, it works fine, but I would like to...
  16. LRATOZ

    Create floating shape that stays visible on top of page when scrolling

    Hi, I have a button on top of each sheet and when clicked takes the user back to the TOC. 'Create & Position Shape Set Shape = Worksheet.Shapes.AddShape(msoShapeRoundedRectangle, 550, 0, 40, 20) I've added following code so that the shape stays in the exact same position when the user...
  17. K

    checkbox to check automatically IF any of other checkboxes are checked

    So here is a brief snippet of my userform i have to use as an example: the top right-hand box (where it says "miscellaneous incidents") has a transparent label over top of the box so it cannot be manually checked... (i put a single frame around it only so that it can be seen for my example...
  18. J

    Using Top Values to export a range of records

    I have a very large table of 3 million records that I need to export out of ACCDB in chunks of 500k records at a time. They are sorted in a particular order so their Primary IDs are not sequential. I can easily export out the first 500k by setting the Top Values property to 500,000. Is there...
  19. MFish

    Comboboxes on top of images within a userform

    Are you able to place comboboxes over an image? I have an image resembling a trailer and I want comboboxes to be on top of it looking like the selection within the combobox is a certain pallet in that location of the trailer. Possible? I've tried dragging the comboboxes onto the picture and...
  20. D

    vba get the # of rows used after filtering data from a certain point

    hi, after filtering...i want to count the number of rows used from after the headers...the headers fill in the top 6 rows and the data is row 7 and below (from columns A to N)....essentially i just want vba to tell me how many rows are used today after doing some sort of filtering and excluding...

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