excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
i have a file with thousands of rows containing numbers in several cells,
i want to know (not delete) which one's/how many duplicates there are?
there also can be more then 2 duplicates
it will be very helpful if the formula can write down in the next column near each row how many
but will skip the other duplicates and write them down as - or x
(like in the example below)
i have a file with thousands of rows containing numbers in several cells,
i want to know (not delete) which one's/how many duplicates there are?
there also can be more then 2 duplicates
it will be very helpful if the formula can write down in the next column near each row how many
but will skip the other duplicates and write them down as - or x
(like in the example below)
| חוברת1 | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | duplicates | |||||||
| 2 | 1 | 1 | 1 | 1 | 2 | 0 | ||
| 3 | 1 | 1 | 1 | 2 | 3 | 3 | ||
| 4 | 1 | 1 | 1 | 3 | 4 | 0 | ||
| 5 | 1 | 1 | 1 | 4 | 5 | 0 | ||
| 6 | 1 | 1 | 1 | 5 | 6 | 0 | ||
| 7 | 1 | 1 | 1 | 6 | 2 | 0 | ||
| 8 | 1 | 1 | 1 | 7 | 7 | 2 | ||
| 9 | 1 | 1 | 1 | 8 | 5 | 0 | ||
| 10 | 1 | 1 | 2 | 1 | 6 | 0 | ||
| 11 | 1 | 1 | 2 | 2 | 1 | 0 | ||
| 12 | 1 | 1 | 1 | 7 | 7 | - | ||
| 13 | 1 | 1 | 1 | 2 | 3 | - | ||
| 14 | 5 | 4 | 3 | 2 | 1 | 0 | ||
| 15 | 1 | 1 | 1 | 2 | 3 | - | ||
12 | ||||||||
