Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    538

    Not an ideal solution, but Copy/Paste...

    Not an ideal solution, but Copy/Paste Special/Paste Special/Comments will move the comment to another cell, but you're left to delete the original comment because Paste Special doesn't work with...
  2. I suggest you use Advanced Filter rather than...

    I suggest you use Advanced Filter rather than Autofilter.

    Insert a few rows above the data you want to filter and copy your column headers to the first row of this space. In the second row in...
  3. Replies
    6
    Views
    289

    Hi Steve, I saw that the slash was missing but...

    Hi Steve,

    I saw that the slash was missing but assumed it was a typo since all the others had it in... Only gonzalezw can know for sure. I should have mentioned this in my post but was rushed as I...
  4. Replies
    6
    Views
    289

    Nested IFs are one solution

    I don't know that you can do it with conditional formatting, but could do it with formulae using a few nested IFs as per the attached file.

    Hope this helps.
  5. The K.I.S.S. solution

    38816I've attached a really simple solution - adding in a Due Date column so that it shows when that task is due. I've also added a bit of conditional formatting to that columns so that if the task...
  6. Replies
    12
    Views
    747

    This should work for anything where column A and...

    This should work for anything where column A and column B both match (as per your sample code). Steve's option 3 will also work, or if you post a sample section of your spreadsheet I can examine why...
  7. Replies
    12
    Views
    747

    Apologies. I'd cut a bit too much from the...

    Apologies. I'd cut a bit too much from the original, and while it worked with that test sample, it doesn't work in all circumstances... This should work properly now:

    Sub RemoveDups()
    '
    Dim i As...
  8. Replies
    2
    Views
    229

    For large datasets, a database is better suited...

    For large datasets, a database is better suited to tasks like this than Excel - a SQL command could extract the unique addresses extremely quickly. If you have to use Excel, you could try getting...
  9. Replies
    12
    Views
    747

    Hi, I read your post to mean that if you have...

    Hi,

    I read your post to mean that if you have a list that if you have address a,b,b,b,c,d,d,e,f,f,f,g you would end up with a,c,e,g after all the duplicate ones had been removed. Here's some code...
  10. Replies
    2
    Views
    605

    When I've come across similar problems in the...

    When I've come across similar problems in the past, as well as jscher's suggestion, here are some other things that I've tried and have worked at various times (even though they don't necessarily...
Results 1 to 10 of 11