| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count unique entries in excel
Hi,
Have checked other threads and cannot see a specific response to a query like this. Appreciate any assistance out there. I have put a sample of dataset - it is over 15K rows in total & has many other columns. Issue: I would like to add a column next to the machine name which enters a number assigned to only unique number of machine names that exist - i.e. 1 next to the first entry BTLP0010 and next one down would be 0 as is a duplicate. Is it possible to do this via formulaes as opposed to pivot tables and not as an overall total? Column 1: BTLP0010 BTLP0010 DSLP0057 DSLP0057 FRLP0090 FRLP0090 FRLP0101 FRLP0101 FRLP0103 FRLP0103 FRLP0104 FRLP0104 Thanks Skippy1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count unique entries | Excel Discussion (Misc queries) | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| count if unique entries | Excel Worksheet Functions | |||
| Count unique entries... | Excel Worksheet Functions | |||
| Count unique entries | Excel Discussion (Misc queries) | |||
Threaded Mode
