filtered column

  1. M

    Apply Formula To Specific Column for Multiple Sheets in a Filtered Table

    Hi all, I have an issue with renaming cells in a filtered table and would be grateful for some help from the Excel community! Objective: 1. For specific sheets in the workbook, apply a filter in column B:B for a specific number of names Company (Parent) 2. Apply a formula to change the Parent...
  2. J

    VBA code to locate specific already filtered columns by name and paste into a new workbook

    Hi All, So to give some background, i have a large data set (60k plus rows and 90 plus columns) that i need to filter and create a new workbook using specific columns. The size of the file changes daily, and columns are taken out and added. So i had to keep updating the previous macro i had...
  3. R

    Averaging results from a filtered column?!

    So this should be the easiest thing in the world but it wasn't covered in the Excel training I did yet did come up in an interview as an exercise.. I have a spreadsheet containing a number of columns as a table. I need to filter one column (to select nationalities) and average the sum (of...
  4. millawitch

    Subtotal with sumif(s)

    Hi all, I have the following formula working but it looks a bit cumbersome - is there a way to streamline it? =SUM(SUMPRODUCT(SUBTOTAL(9,OFFSET(Timekeeping[Units / Hours],ROW(Timekeeping[Units / Hours])-MIN(ROW(Timekeeping[Units / Hours])),0,1))*(Timekeeping[Date] >...
  5. C

    Copy and Paste Filtered cells in VBA

    <colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col></colgroup><tbody> Description Type Topper Base Layer A A1 B B1 C D D1 TRUCK 7.5 FE 4" WIDE ORANGE 840(1008 ) FE JOEY 8" H1-NG2 H1 1 CPU 7.5 FE 4" WIDE ORANGE 840(1008 ) FE JOEY 8" P1-DG34 H1...
  6. V

    Offset down on a filtered list

    Hi, What I am trying to do is select a column and filtering for blanks. I want to offset down one - but when I use the below code it doesnt ignore the filtered rows. ActiveCell.Offset(1,0).SelectI need the code to ignore all filtered cells and select the first empty cell. Thanks in advance...
  7. D

    VBA Loop Visible Cells Column, Copy left 7 digits

    Hi, I'm pretty new to VBA and desperately need help! I have to loop through a column of data, select only the visible cells in that column, extract the left seven characters then paste them into an external workbook I've already created. This data will be pasted on sheet2 of the external...
  8. S

    Only process filtered items

    Hello again, How can you let vba process "only" the filtered data (on my filtered excel sheet). The code executes and it stil executes it on all the data. Here is an example of my code. In the sheet of this document are filtered columns. Even with filter-on, vb still processes the whole...
  9. W

    Count Unique values in a filtered Column

    I have people's names in Cells A9 to A42 and I want to count the number of unique people in the list so I can multiply the number of unique people by 40 and give me the total # of hours I have available in a week given a 40 hour work week. I came up with the following formula which works great...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top