szita2000
Board Regular
- Joined
- Apr 25, 2012
- Messages
- 101
- Office Version
- 365
- Platform
- Windows
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Date | Name | Product | Concan | Count |
2 | 01/01/2018 | Daffy Duck | Apple | Daffy DuckApple | 0 |
3 | 03/01/2018 | Bugs Bunny | Pear | ||
4 | 03/01/2018 | Bugs Bunny | Orange | ||
5 | 07/01/2018 | Bugs Bunny | Orange | ||
6 | 12/01/2018 | Pepe Le Pew | Kiwi | ||
7 | 05/01/2018 | Daffy Duck | Apple |
<tbody>
</tbody>
Sheet1
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>
Hi Guys. I can't figure this one out. In the data set above I have to highlight duplicates that are occur within 5 days of each other. (This is to filter out of someone processed the same purchasing twice by accident) I tried to concatenate the name and product in to a helper column on D:D - That would make each purchase unique, I can't work out how to collect and compare the date after the combinations. I tried to go with count ifs but the criterias of >= than date +5 days doesn't seems to be working. In the data set above Line 2,7 and 4,5 should be highlighted/put in to a separate list somehow Any ideas most welcome |
<tbody>
</tbody>