Search:

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

Search: Search took 0.00 seconds.

  1. If you substitute this section to the following,...

    If you substitute this section to the following, it will check if there are any blanks and tell the user where the problem is:

    'COPY SOURCE DATA INTO ARRAY VARIABLE (DATA ROW)

    For i = 0 To...
  2. I have broken the problem down into bits in the...

    I have broken the problem down into bits in the attached file. Columns A & B are a set of ascending dates and some random numbers. Column C checks if the date is the first or last of the month and...
  3. Replies
    5
    Views
    640

    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...
  4. 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...
  5. Replies
    6
    Views
    323

    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...
  6. Replies
    6
    Views
    323

    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.
  7. 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...
  8. Replies
    12
    Views
    805

    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...
  9. Replies
    12
    Views
    805

    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...
  10. Replies
    2
    Views
    260

    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...
  11. Replies
    12
    Views
    805

    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...
  12. Replies
    2
    Views
    615

    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 12 of 13