+ Reply to Thread
Results 1 to 4 of 4

How to assign Unique numerical numbers for a column by comparing other column values

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to assign Unique numerical numbers for a column by comparing other column values

    Hi ,

    Hope you r doing well.can any one help out me in the following issue,(soon response will be highly appreciated)


    I need to get a unique numeric values to a column1 based upon checking the conditions (whether the column is unique are not) on other 3 columns.
    If any one the values or text from 3 columns are different compared to its upper column the a new numeric value(next) should be assigned to the first column.

    Example:

    columnA ColumnB ColumnC ColumnD

    1 set bet tet
    1 set bet tet
    2 set yet tet
    3 not at done

    I have used the follwing formula but its only comparing 1 column and my req is it should compare other 2 columns as well and then assign a numeric value

    Iam assigning a value 1 to the 1st record of column A(A1) and then from the second record (A2) iam using this formula

    =IF(COUNTIF($B$2:B2,B2)=1,MAX($A$1:A1)+1,MAX($A$1:A1)) [Iam getting correct results but only comparing columnB and i need comparision of Column c,D as well)
    Last edited by FAHEEM AHMED; 10-15-2012 at 08:56 AM. Reason: clearity

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: How to assign Unique numerical numbers for a column by comparing other column values

    try this in D2

    Please Login or Register  to view this content.
    (however it should be noted that you could get errors if your words could link EG car pet could also read carpet)

    i would do this to ensure no error

    Please Login or Register  to view this content.
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  3. #3
    Registered User
    Join Date
    03-21-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to assign Unique numerical numbers for a column by comparing other column values

    Hi Thanks for the reply but iam not getting any thing from the formula....Actually i need numerical values to be incremented in columnA by comparing the rows of ColumnB,ColumnC,ColumnD by its preceding rows respectively. Then is the rows are matching i.e., colB value of previos row =colB value of current row and same condition for and ColumnC then there should not be any increment in colA value(the value should be same) . ELSE if there is mismatch in any of the condition then the value should be incremented in columnA

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: How to assign Unique numerical numbers for a column by comparing other column values

    depends how your data will be organised. but this seems ok to me

    (i also did a results page to combine it)

    its a bit rough but you should get the idea through it

    unique.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1