Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
How do I get VB to ignore duplicate entries. I have a file that has 3 lists with product list number under each list. I don't want VB to print out the same number multiple times. If the the list is "0" I want to ignore it. If the list repeats, I want to only print it once.
List-1, List-2, List-3
3, 0, 0
3, 0, 0
3, 1, 0
3, 0, 0For example, above should be displayed as:
ProdList
3
1

Turn on the list sorted feature, then keep a variable for previously printed value, when a new value comes in, compare to previous value. If it's the same don't print, else print etc..

I'm sorry, I'm not sure what you are referring to. I'm new to VB and need a bit more specifics to help me along.
Thanks.

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |