| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mark the first Unique Record in a list with VBA
Hello :),
New challange in the world of Excel. If somebody can help me out. Thx! I've got a list with column A, B, C. In Column.D want to have an "1" when the combined fields "A&B&C" are the first unique in the list. If in another row the same combination "A&B&C" occur then report in that row in Column.D a "0". I know that there are some countifs/array formulas for it, but when having many rows it makes it very slow. A VBA is faster in this cases. regards, Johan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique record | Excel Programming | |||
| How to find earliest record based on unique identifier from a list ofdata | Excel Discussion (Misc queries) | |||
| Record at Mark | Excel Programming | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| Mark last record of a particular name | Excel Discussion (Misc queries) | |||
Threaded Mode
