Excell Question, please help!? |
| Excell Question, please help!? Posted: 22 May 2013 06:05 AM PDT I have a bunch of number sorted smallest to largest in the A column. Some are unique, but some are duplicates. I need a forumal in the B collumn that will put a 1 next to each number in A that is unique and next to the first time a number appears as a duplicate. Then, all the other duplicate numbers can have values other than 1, so I can filter out anything that's not 1. Essentially, here is what I need: A Column / B Column 123 / 1 123 / 2 1234 / 1 12345 / 1 12345 / 2 12345 / 3 123456 / 1 1234567 / 1 |
| You are subscribed to email updates from Find Answers: HEALTH CARE, DIET & FITNESS To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
0 comments:
Post a Comment