Search:

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

Search: Search took 0.00 seconds.

  1. 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. 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. 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. 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. How many names have a duplicate in a date range

    Hi guys,

    Can someone please help with a formula?

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