Hi
I have a sample list below with Code and Description. I want to create the following:
Duplicate Codes (those in red)
- : A Chart Table Showing only those Codes that are duplicates
- A Text Box, showing a count of those codes that are duplicates. (answer should be 5)
Codes with No Description (those in blue)
- : A Chart Table Showing only those Codes that have no description
- A Text Box, showing a count of those codes that are duplicates. (answer should be 6)
Kind regards
Nayan
| Code | Description |
| 900 | Cars |
| 900 | Bikes |
| 2200 | CLOSE CENTRE |
| 2200 | CLOSED VENUE |
| 4200 | MIAN |
| 4200 | WEST |
| 5100 | DETAILS |
| 5100 | TRANSACTIONS |
| 7400 | DURBAN |
| 7400 | CAPE TOWN |
| 1112 | 0000ABF |
| 2870 | 0000ACA |
| 3980 | 0000ADJ |
| 7650 | 0000CHN |
| 7850 | 0000FRQ |
| 9320 | 0000RSE |
| 7940 | 0000TXA |
| 7680 | |
| 7830 | |
| 6750 | |
| 2430 | |
| 9860 | |
| 6720 | |
