More Excel help

Discussion in 'The Front Room' started by granny, Apr 7, 2004.

  1. granny

    granny Fledgling Freddie

    Quick question.

    We've got a large list of patient names in Excel and each patient has a unique patient identifier number (6-8 digits usually). What we want to do is quickly and easily find any duplicates in the list, ie. do any of these patients appear in the list twice.

    Anyone know an easy way to do this?
     
  2. granny

    granny Fledgling Freddie

    Aha, google has found the answer!

    Thanks anyway :p
     
  3. Jupitus

    Jupitus Old and short, no wonder I'm grumpy! Staff member Moderator FH Subscriber

    Quite an elegant solution too :)



    I'll still probably stick to some old cludgy way of doing that, myself :p
     
  4. granny

    granny Fledgling Freddie

    Unfortunately it's not quite elegant enough since we can't seem to make it apply to cells *before* the data is entered but to be honest I think that's us just paying the price for using a spreadsheet app to do the job of a database...
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.