Search:

Type: Posts; User: njones3; Keyword(s):

Search: Search took 0.00 seconds.

  1. Formula to locate an entry with a date up to 15 days in the future

    Hi,

    I am trying to work out a formula which will allow me locate a related entry with a future date (up to +15 days).

    I have 2 separate lists, one of customers and their contract end dates and...
  2. Re: sumif - to identify duplicate values and a value +/- 10%

    Back to the drawing board, on reflection:

    I am trying to use a Count If formula to identify where a customer name (column A) is a duplicate and the value in column B is within 10% of the same...
  3. Count If - to identify duplicate values and a value +/- 10%

    Hi,

    I am trying to use a Count If formula to identify where a customer name (column A) is a duplicate and the value in column B is within 10% of the same value (column b) in the duplicate line.
    ...
  4. Re: sumif - to identify duplicate values and a value +/- 10%

    Thanks Special-K99, appreciate that was a very vague post. Plenty to think about!
  5. sumif - to identify duplicate values and a value +/- 10%

    Hi,

    i am trying to use a sumif formula to identify where a customer name (column A) is a duplicate and the value in column AY is + or - 10% of the value in the duplicate line.

    Is this possible...
  6. Thread: Formula Help

    by njones3
    Replies
    3
    Views
    85

    Re: Formula Help

    Thank you very much, that has worked perfectly.

    Think I was trying to over complicate it!
  7. Thread: Formula Help

    by njones3
    Replies
    3
    Views
    85

    Formula Help

    Hi,

    I have the below formula for a calculated column in a table but it doesn't seem to be working correctly, is there an obvious error?

    =IF(AND(BG2="Sales Manager",OR([@[Vol NB +...
  8. Thread: Do while loop

    by njones3
    Replies
    1
    Views
    219

    Do while loop

    I am hoping someone can help, I am trying to add a 'do while' type loop into some existing code. The current code makes manual changes to my data dump but it can only do one row at a time. Sometimes...
  9. Replies
    1
    Views
    178

    Grouping a pivot table by variable groups

    Hi,

    I am trying to come up with VBA code for a pivot table where by the row groupings change depending on the numbers in specific cells.

    For more context, I have a 70,000 row list of...
Results 1 to 9 of 9