I have a provider that I have to pay everymonth. Sometimes, twice a month. I need to know when I payed in a specific date.
I want to get this Information:
Can someone help me? Is there any formula in excel to do this? Thanks
A | B | |
1 | XYZ | |
2 | fev/23 | |
3 | fev/23 | 27/02/2023 16:02 |
4 | fev/23 | |
5 | jan/23 | 31/01/2023 16:00 |
6 | jan/23 | |
7 | jan/23 | 01/01/2023 15:00 |
8 | jan/23 | |
9 | jan/23 | |
10 | dez/22 | |
11 | dez/22 | 02/12/2022 14:00 |
12 | dez/22 |
I want to get this Information:
A | B | |
1 | fev/23 | 27/02/2023 16:02 |
2 | jan/23 | 31/01/2023 16:00 |
3 | jan/23 | 01/01/2023 15:00 |
4 | dez/22 | 02/12/2022 14:00 |
Can someone help me? Is there any formula in excel to do this? Thanks