danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Invoice Number | Date of Payment | |||
2 | 1 | 1-Jul | |||
3 | 1 | 1-Jul | |||
4 | 1 | 4-Jul | |||
5 | 1 | 4-Jul | |||
6 | |||||
7 | |||||
8 | Invoice Number | Date of Payment | |||
9 | 1 | 1/07/19 | 1/07/19 | 4/07/19 | 4/07/19 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Array Formulas
<thead> </thead><tbody> </tbody> Note: Do not try and enter the {} manually yourself |
<tbody>
</tbody>
Hello,
Invoice 1 was paid on two different dates.
How do I show only the unique dates instead of the way I'm currently doing (in B9)
FYI
Data is extracted data and always will show duplicate dates as shown above.
Thank you