# Search:

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

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

by njones3
Replies
1
Views
76

### 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. ## Thread: sumif - to identify duplicate values and a value +/- 10%

by njones3
Replies
3
Views
170

### 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. ## Thread: Count If - to identify duplicate values and a value +/- 10%

by njones3
Replies
1
Views
115

### 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. ## Thread: sumif - to identify duplicate values and a value +/- 10%

by njones3
Replies
3
Views
170

### 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. ## Thread: sumif - to identify duplicate values and a value +/- 10%

by njones3
Replies
3
Views
170

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

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!

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. ## Thread: Grouping a pivot table by variable groups

by njones3
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