fy17

  1. F

    VBA: Pull unique records from one column matching another column

    This code works find to extract unique records out of column R (Sheet FY17), but I need to also match column D (Sheet FY17) against the value in AG1 (Sheet Workcount). Any thoughts? Sub FilterUnique() Dim rng As Range, Dn As Range With Sheets("FY17") Set rng =...
  2. R

    Cohort Waterfall by account count

    I am trying to build out a waterfall that will count how many customers we have based on what time they became a customer. The plan is to count the account IDs if they are new business and remove them if they have been cancelled. The issue is an account can have numerous opportunities marked as...
  3. M

    Not sure if I can achieve this with PowerPivot any insights welcome

    Hello all. I'll explain what I'm trying to do, I'm unsure if I can achieve this with Power Pivot, I'm fairly new to PPvt & gotten to grip with the basics. So my source data looks like the below, which is many 000s of rows, formatted as a table & is in my data model. <tbody> Data...
  4. C

    Index Match Function

    Hi all, I need some help with a multiple criteria index match function. I need it to look for two criteria, and then give me my output. Below is what i'm working with. The X's are what i need to fill in <tbody> 1 JACKSON-HOUSTON </tbody> <tbody> Date My Price DAT Price My Ship Count...

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