+ Reply to Thread
Results 1 to 12 of 12

Sports athletic meet bib no input

  1. 02-14-2019, 02:44 PM #1
    actveme
    actveme is offline
    Registered User
    Join Date
    10-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Sports athletic meet bib no input

    Hi,

    can anyone expert help me for detecting duplicate name and the same school, then put bib no same the duplicate

    exm:-
    Event Gender Age Group Name School Name Position BIB NO
    100 mt Run Boys 14 years Aman Ahammed Chalk Islampur SCM High School(H.S.) 1st 101
    200 mt Run Boys 14 years Aman Ahammed Chalk Islampur SCM High School(H.S.) 1st 101

    HERE THE EXCEL FILE AND INPUT BIB NO


    MORE THAN 500 STUDENTS AND GIVE THEM BIB NO OR CHEST NO..

    PLEASE HELP ME



    THANK YOU
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-14-2019, 03:49 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Sports athletic meet bib no input

    I basically used the macro recorder,
    copied column D to Column P, removed duplicates,
    assigned each a number to each name, used vlookup in column G to get the bib numbers.
    Please Login or Register  to view this content.

    Open attached for the working macro, just click the button.
    Attached Files Attached Files
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 02-14-2019, 09:08 PM #3
    actveme
    actveme is offline
    Registered User
    Join Date
    10-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Sports athletic meet bib no input

    thank you very much. And its work.


    Sir,


    please another problem that same sheet and one criterion is block-wise mention, and bib no separate,

    one player do not play more than 3 events.


    Again thanks
    Attached Files Attached Files
    Last edited by davesexcel; 02-15-2019 at 08:48 AM. Reason: quoting previous posts are not required
    Reply With QuoteRegister To Reply
  4. 02-14-2019, 10:28 PM #4
    actveme
    actveme is offline
    Registered User
    Join Date
    10-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Sports athletic meet bib no input

    please see this and solve
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 02-15-2019, 08:38 AM #5
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Sports athletic meet bib no input

    Sorry, I don't really understand the question.
    Reply With QuoteRegister To Reply
  6. 02-15-2019, 09:59 AM #6
    actveme
    actveme is offline
    Registered User
    Join Date
    10-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Sports athletic meet bib no input

    sir please cheque and solve
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 02-15-2019, 11:30 AM #7
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Sports athletic meet bib no input

    You need to spend a bit more time explaining what you want.

    Where is the before and after example in your attached workbook.
    Reply With QuoteRegister To Reply
  8. 02-15-2019, 01:04 PM #8
    actveme
    actveme is offline
    Registered User
    Join Date
    10-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Sports athletic meet bib no input

    Quote Originally Posted by davesexcel View Post
    You need to spend a bit more time explaining what you want.

    Where is the before and after example in your attached workbook.
    please see this attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 02-15-2019, 01:25 PM #9
    wyowhite
    wyowhite is offline
    Forum Contributor
    Join Date
    03-29-2013
    Location
    lakewood, usa
    MS-Off Ver
    exce2013
    Posts
    112

    Re: Sports athletic meet bib no input

    Here is a solution that uses formula only (no VBA)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 02-15-2019, 01:59 PM #10
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Sports athletic meet bib no input

    There is not a name Rani in the worksheet.

    Sorry, I don't know what you are looking for.
    -

    Rasni.png
    Reply With QuoteRegister To Reply
  11. 02-15-2019, 09:42 PM #11
    actveme
    actveme is offline
    Registered User
    Join Date
    10-11-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Sports athletic meet bib no input

    please see and solution
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 02-17-2019, 10:35 AM #12
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Sports athletic meet bib no input

    Please see this forum's rules on cross-posting. As you are new, I will provide a link for you this time.

    https://www.mrexcel.com/forum/excel-...der-event.html
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF function - To get value if criteria meet on col H (fall back on col F if not meet)
    By Bubbles_A in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-13-2018, 11:52 AM
  2. HELP in Getting The Top 3 Most Sports
    By Windell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2014, 08:47 AM
  3. How to delete columns that meet one criteria AND does NOT meet the other?
    By lch93lily in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-06-2014, 09:53 AM
  4. Macro to search row and column for intersect and then input a data to where they meet
    By aloconnor in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-10-2014, 04:21 PM
  5. Tracking athletic records
    By SirTifiable in forum Excel General
    Replies: 17
    Last Post: 02-07-2013, 06:09 PM
  6. help in sports excel
    By j33p in forum Excel General
    Replies: 2
    Last Post: 02-07-2010, 06:14 PM
  7. Sports day changes
    By mrhogan in forum Excel General
    Replies: 0
    Last Post: 07-08-2009, 03:20 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1