filter and if array

  1. G

    Removing duplicates rows

    Data Tier Category Name Tier 1 Tom Tier 1 Tom Tier 1 Harry Tier 1 Rafa Tier 1 Daniel Tier 2 Tom Tier 2 Harry Tier 2 Harry Tier 2 CAN ATALAY Tier 2 HANN-WEN SHEU Tier 3 Oktar Tier 3 Miria Tier 3 Harry Tier 3 CAN ATALAY Tier 3 Tom Tier 3 Rafa Tier 3 Oktar...
  2. Z

    Using a formula that populate specific list based on list of conditions

    Hi, I have below sample table and what I need is to populate demographics based on the count of each factor. I put the expected results based on the result of factor count of AAA, which is in this example are 4 that is based on the formula that count AAA based on selected filters from drop...
  3. H

    Formula to Group Duplicate Cells/Data into Single Cell (Not VBA)

    Hey Guys Just after some heap been rcking my brain for days! My Table/Range has been pupulated this way; <tbody> <tbody> Window Support Channel 1/1800, 1/1200, 3/600, Window Support Channel 4/1800, 2/1200, 4/900, Window Support Channel 1/1800, 1/1200, 3/600, </tbody>...
    • HeyItsDizzy
    • Thread
    • duplicate cells filter and copy filter and if array filter array data columns group cells
    • Replies: 10
    • Forum: Excel Questions
  4. M

    Filter for text that does not match in two different columns

    Hi all, I have a Sub that currently works to automatically filter 3 different words in two columns in my workbook. What I am after is for an change up of this macro: so that it will filter when column 1 = "SentProgress" does not match column 2 = "ReceivedProgress". An example of this would when...
    • Milos
    • Thread
    • false filter filter advance filter advance criteria filter and if array
    • Replies: 5
    • Forum: Excel Questions
  5. S

    Hide and Show Rows on Sheet based on similar Array and Filter

    Greetings, Gurus: As you may know from my prior questions (and answers), I look and try for days before posting here, but I'm stumped. I'm working on an increasingly complex workbook, heavy on automation and VBA. On one sheet, I have created two "sections". The first section runs from Row 5...
  6. L

    Array formula - Weighted Average Price of filtered data above .01 cent

    I am having trouble modifying a formula I built out to calculate what the weighted average price of a filtered set of data is. After a lot of trial and error, I was able to successfully create an array formula that could do the above. However, I now want to add if parameters to the formula that...
    • lshub
    • Thread
    • filter and if array filter array if array
    • Replies: 11
    • Forum: Excel Questions

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