Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: why does my boss want this done?!!

  1. #11
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 07:24, Asala42 wrote:
    Hiya,

    I see a lot of coding for this question but if you have the data sorted already, why not use a quick formula?

    In an inserted blank column (starting with say A2): =if(B2=B1,"",B2)

    Then copy/paste it over as values, then delete or hide the original column.

    Adam

    This is almost the same as what the Memicol/Amds macro does, and Amds suggested doing it manually if it's just a one-off.

    Note : Asala42's suggested method will convert any formulas in the original column (if it is deleted) to values only - the Memicol/Amds method will retain any formulas.

    To use the Memicol/Amds macro, you need to give it a name :-

    Sub Whatever()
    'Put the code here
    End Sub

    [ This Message was edited by: ldry on 2002-04-30 07:40 ]

  2. #12
    New Member
    Join Date
    Apr 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ADAM... YOU'RE A GENIUS!
    Funny that its easy to overlook the simplest solutions.
    Thanks alot

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •