# Search:

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

1. ## Thread: How many names have a duplicate in a date range

by Prinny
Replies
9
Views
308

### Re: How many names have a duplicate in a date range

Fantastic! I added this and it works perfectly.
I would never have worked this out on my own, I really can't thank you enough for all your help.
2. ## Thread: How many names have a duplicate in a date range

by Prinny
Replies
9
Views
308

### Re: How many names have a duplicate in a date range

Sorry to ask again but I could use some more help with this. I've added the formula to my main data but I think I did something wrong as It's not giving the correct result.

The main data is on a...
3. ## Thread: How many names have a duplicate in a date range

by Prinny
Replies
9
Views
308

### Re: How many names have a duplicate in a date range

Dante, thank you so much. Your array formula is exactly what I needed!

This is way more advanced than my skill level, very impressive. :)

I will need to do a lot of reading before it makes...
4. ## Thread: How many names have a duplicate in a date range

by Prinny
Replies
9
Views
308

### Re: How many names have a duplicate in a date range

Thank you for your help, I'm sure this would work but I can't add the helper column to the data. Really appreciate you taking the time.
5. ## Thread: How many names have a duplicate in a date range

by Prinny
Replies
9
Views
308

### How many names have a duplicate in a date range

Hi guys,

I have a list of names in column A, and some dates in column B. I need to work out how many names appear more than once between certain dates....
6. ## Thread: Formula to check if data is a bulk delivery

by Prinny
Replies
3
Views
223

### Re: Formula to check if data is a bulk delivery

Hi Eric,

Thank you so much for posting this brilliant solution. It works perfectly, exactly what I needed.

I was trying lots of complicated "if a2 is the same as a3 but not the same as a1"...
7. ## Thread: Formula to check if data is a bulk delivery

by Prinny
Replies
3
Views
223

### Formula to check if data is a bulk delivery

Hi all, hoping you can help as I'm a bit lost with this.
My data has several columns of information regarding deliveries, the dates they were made and if all the items ordered by the customer were...
8. ## Thread: Macro for Resizing a table after COUNTA

by Prinny
Replies
2
Views
324

### Re: Macro for Resizing a table after COUNTA

Still having trouble with this so would be great if anyone can help.
9. ## Thread: Macro for Resizing a table after COUNTA

by Prinny
Replies
2
Views
324

### Macro for Resizing a table after COUNTA

Hi all,

This is probably an easy solution but this is my first attempt at writing a macro.

I have a simple spreadsheet with a table in it (Table1). the table runs from Column A to Column K
...
Results 1 to 9 of 9