Santosh080
Board Regular
- Joined
- Jul 15, 2016
- Messages
- 77
- Office Version
- 2021
- Platform
- Windows
hello friends,
I have sheet having this type of data,
Here you can see there is multiple credit on same date. Now i want to combine that multiple credit amount to one by date. Like below. How can i do this.?
I have sheet having this type of data,
R.TOTAL DUE OF A-C 103275110000022 FOR 13(2) NOTICE.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Date | Credit | ||
2 | 31-07-2019 | 2000 | ||
3 | 31-07-2019 | 2000 | ||
4 | 31-07-2019 | 2000 | ||
5 | 01-11-2019 | 2000 | ||
6 | 30-11-2019 | 2000 | ||
7 | 01-01-2020 | 2000 | ||
8 | 01-01-2020 | 2000 | ||
9 | 29-02-2020 | 2000 | ||
10 | 26-03-2020 | 2000 | ||
11 | 30-04-2020 | 2000 | ||
12 | 30-05-2020 | 2000 | ||
13 | 30-06-2020 | 2000 | ||
14 | 31-07-2020 | 2000 | ||
15 | 31-08-2020 | 2000 | ||
16 | 31-08-2020 | 2000 | ||
Sheet4 |
Here you can see there is multiple credit on same date. Now i want to combine that multiple credit amount to one by date. Like below. How can i do this.?
R.TOTAL DUE OF A-C 103275110000022 FOR 13(2) NOTICE.xlsx | |||||
---|---|---|---|---|---|
G | I | ||||
1 | Date | Credit | |||
4 | 31-07-2019 | 6000 | |||
6 | 30-11-2019 | 4000 | |||
8 | 01-01-2020 | 4000 | |||
9 | 29-02-2020 | 2000 | |||
10 | 26-03-2020 | 2000 | |||
11 | 30-04-2020 | 2000 | |||
12 | 30-05-2020 | 2000 | |||
13 | 30-06-2020 | 2000 | |||
14 | 31-07-2020 | 2000 | |||
16 | 31-08-2020 | 4000 | |||
Sheet4 |