+ Reply to Thread
Results 1 to 3 of 3

Change numbers if unique values found

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,005

    Change numbers if unique values found

    hello



    i have text in range d2:d500 (text only)

    and i want to add numbers to range a2:a500 but with conditon

    D2 = AHSAAAN..........A2 = 1
    D3 = AHSAAAN..........A3 = 2
    D4 = AHSAAAN..........A4 = 3
    D5 = AHSAAAN..........A5 = 4
    D6 = AAAKIB..........A6 = 1...............Change number if text found unique one
    D7 = AAAKIB..........A7 = 2
    D8 = BHURA..........A8 = 1
    D9 = DANISH..........A9 = 1
    D10 = HAROON..........A10 = 1
    D11 = HAROON..........A11 = 2
    D12 = HAROON..........A12 = 3
    D13 = ZAID..........A13 = 7


    change number sequence if found unique Entry

    thanx
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,120

    Re: Change numbers if unique values found

    Try this ...

    =COUNTIF($D$2:D2,D2)

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,005

    Re: Change numbers if unique values found

    perfect once again


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Assign sequential numbers to unique values in a list
    By penfold in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-30-2017, 02:11 PM
  2. [SOLVED] Change number if found unique value
    By HaroonSid in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-11-2017, 09:44 AM
  3. [SOLVED] Min of the numbers assigned for all the values found in a range
    By anshul1719 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-15-2016, 02:30 AM
  4. [SOLVED] Return Sequential Numbers Based on Unique Values
    By HangMan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-06-2015, 08:13 PM
  5. Replies: 7
    Last Post: 02-27-2014, 10:56 PM
  6. Replies: 8
    Last Post: 02-20-2014, 07:03 PM
  7. [SOLVED] Countif unique values (only cells with numbers)
    By Davzx in forum Excel General
    Replies: 7
    Last Post: 06-27-2012, 12:39 PM

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