zzzz

  1. P

    Autofill AAAA-AAAB etc

    Hi one and all. I'm new to Excel, so fairly inept with formula etc. I had done a search of questions asked, and found a question that nearly but not quite hit the point. The question posed by 'cmendes on May 18th 2011. What I'm trying to do is to populate cell A1 with AAAA, then autofill...
  2. T

    Count of Value between Hours

    I hope someone can help me out with a pivot table problem that I've yet tofigure out. I have a table setup that counts the number of instances that a trailerdelivers on an hourly basis. E.g., we have 7 deliveries at 08:00 AM. Most ofour deliveries are given an hour to complete the unloading...
  3. N

    Help to get Cell value with multiple conditions

    Hi all I need help to take value of Cell that: with j = 2 to lastrow if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R101" then copy value in Cell(i;C) to Hj if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R102" then copy value in Cell(i;C) to Ij if Cell(J;G).value =...
  4. S

    Unique Records Duplicating

    Hi All I'm an OK user of Access (not VBA) and seeking some assistance. I have a query that is working out the distance between postcodes in the UK. I have for example, 16 unique postcodes in one column of data, and another 16 unique postcodes in another column. I was expecting to get 16...

Some videos you may like

This Week's Hot Topics

Top