TechSpot

Excel, help please!!!!!!

By DiRamazzotti
Sep 28, 2004
  1. How do I eliminate duplicate values in cells?
    I have a column with the following values:
    20
    20
    30
    30
    50
    60
    60
    60
    90
    90
    100

    How do i eliminate the values that repeat in such a way that the table looks like this:
    20

    30

    50
    60

    90

    100
    Namely, how do i make excel only recognize the first value that repeats, and replaces the other duplicate values with a blank cell.
    Please help me, and also, what exactly does the "lookup" function do?
     
  2. bones

    bones TS Rookie

    have you looked in the help file that you can access from the main program screen .
     
  3. The Best Alias

    The Best Alias TS Rookie Posts: 113

    You're gonna have a problem doing that all in 1 column. You need at least 2 columns, example column A is data entry and column B is data reported.
    Try playing around with the =if command.
     
  4. The Best Alias

    The Best Alias TS Rookie Posts: 113

    OK, I found a free minute and fingered out an actual working solution. First the definition of lookup:

    Lookup returns a value either from a one-row or one-column range or from an array. The LOOKUP function has two syntax forms: vector and array. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range. The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array. This was copied w/o permission directly from the help file.

    --A -- B ------------Resulting answer
    1
    2 20 =if(A2>A1,A2,"") 20
    3 20 =if(A3>A2,A3,"") blank cell
    4 30 =if(A4>A3,A4,"") 30
    5 3= =if(A5>A4,A5,"") blank cell

    etc etc etc

    I'm not really sure what you were trying to do (a month and a 1/2 ago) but this does return the results you were looking for, as long as the numbers are in a consecutive sequence.
     
  5. dp19

    dp19 TS Rookie

    one thing I learned about this you can create a formula in the next row. =if(a2=a1,"yes","") What this will do if the row doubles it will say yes to the doubled word, number, or phrase. Then you will have to manually delete what you have.
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...