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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top