-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
#uniquerecords
-
E
Counting Unique Values
Hello everyone, I have a large data set, almost 100k lines, with payroll related data. In addition to employee information, each row has hours worked in a specific pay period, the starting and ending dates of the pay period, and the date the check was issued. In some instances an employee will...- errollflynn
- Thread
- #sort #sorting #uniquerecords
- Replies: 4
- Forum: Excel Questions
-
K
Index/Match/Vlookup - No Duplicates
I am trying to create a smart #. So far I have tried using the concatenate function alongside v-lookup. As well as a variation of index/match nested within if statements. I either get an error (tried iferror), n/a (tried ifna) or #ref , which means the range is probably wrong. Attached is a...- kaemerso
- Thread
- #match #uniquerecords #vlookup #index selected
- Replies: 7
- Forum: Excel Questions
-
S
Allocate 1 or 0 to each unique record(string) in column
Hi I have been trying for quite some time to find the first unique record in a column and either allocate a "1" if it is or "0" if it is not. I could do this quite easily in excel using a countif but am struggling with powerpivot. I have tried the follwing formula but it allocates a "1" for...- Sonova
- Thread
- #powerpivot #uniquerecords
- Replies: 9
- Forum: Power Tools
