Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Jeterdawg
-
How do I eliminate duplicate entries in an Excel list ?
I found a temporary solution for this issue using an Excel macro and sorting. I inserted a column in front of all the data, and basically wrote a conditional that says if the row following this one is the same, mark it as "x" and go on down the list. Then I sorted and deleted all rows with an...- Jeterdawg
- Post #2
- Forum: Microsoft: Office
-
How do I eliminate duplicate entries in an Excel list ?
I have a listing of data in Excel, and I want to eliminate duplicate entries within the first couple of columns so that I can format it differently in order to run some macros. The data looks as so: User ID User Name Function Menu xxx xxx, xxx xx 2 xxx xxx, xxx xx...- Jeterdawg
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Vlookup duplicates
I have a similar issue with VLOOKUP...I want VLOOKUP to return a value based on TWO fields. Here's the scenario: I have a user listing, and there are Application IDs and User IDs. I want VLOOKUP to be able to return Y or N based on if some individual has access to some application. Using just...- Jeterdawg
- Post #8
- Forum: Microsoft: Office
