store1

  1. P

    index match average

    Hi I have a few criteria: store postcode average <tbody> Store Postcode Age store1 1234 20 store1 1234 53 store1 1236 18 store2 4556 21 store2<strike></strike> 4557 25 store2<strike></strike> 4558 30 store3 6771 41 store3<strike></strike> 6772 25 store3<strike></strike>...
  2. E

    Does If + vlookup work in this case

    Hello, I need to complete the table but I'm not sure how to write the formula in this case. Could you please advise. Chart A: original data <tbody> Project Product Store 1973 A Store1 1973 B Store2 1973 A Store1 1973 C Store3 1973 A Store1 2233 A Store1...
  3. S

    Flag Column if Matches 1 record

    Hello, I have a table of Visit information for various customers. I need to identify what we consider as our customer, which means that if the customer visited our store (Store1) In the Table below I need to get the column OurCustomer <tbody> Customer ID Store Visit Date Store1 OurCustomer...
  4. M

    VBA loop to duplicate rows based number of days per month

    Hi guys I need your help guys to write VBA code to duplicate rows based on number of days per months I have monthly order number but it is not comparable to daily actuals, what I need is to populate the table into daily file based on number days per month. e.g. I need 31 rows for first data...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top