top

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

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

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

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

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

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

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

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

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?

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

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

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

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

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?

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

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

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

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

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

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