Need Help in Date

[Santosh080]

hello friends,

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

 

[etaf]

you could use a pivot table ,if happy to have in new columns - if you want the same columns changed and updated - then VBA will be needed - not my area
are you still using version 2016 ?
then see below
if you have 365 version you can use the UNIQUE() function

Book1
	A	B	C	D	E
1	Date	Credit
2	7/31/19	2000		7/31/19	6000
3	7/31/19	2000		11/1/19	2000
4	7/31/19	2000		11/30/19	2000
5	11/1/19	2000		1/1/20	4000
6	11/30/19	2000		2/29/20	2000
7	1/1/20	2000		3/26/20	2000
8	1/1/20	2000		4/30/20	2000
9	2/29/20	2000		5/30/20	2000
10	3/26/20	2000		6/30/20	2000
11	4/30/20	2000		7/31/20	2000
12	5/30/20	2000		8/31/20	4000
13	6/30/20	2000
14	7/31/20	2000
15	8/31/20	2000
16	8/31/20	2000
Sheet1

Cell Formulas
Range	Formula
E2:E12	E2	=SUMIF($A$2:$A$16,D2,$B$2:$B$16)
D2	D2	=IFERROR(INDEX($A$2:$A$16, MATCH(0, COUNTIF($D1:D$1, $A$2:$A$16), 0)),"")
D3:D14	D3	=IFERROR(INDEX($A$2:$A$16, MATCH(0, COUNTIF($D$1:D2, $A$2:$A$16), 0)),"")

 

[Peter_SSs]

As mentioned by @etaf, a Pivot Table would be a good way to do it. Pivot Table is found on the Insert ribbon tab and the result could be like this.

22 08 21.xlsm
	A	B	C	D	E
1	Date	Credit		Sum of Credit
2	31-07-2019	2000		Date	Total
3	31-07-2019	2000		31-07-2019	6000
4	31-07-2019	2000		01-11-2019	2000
5	01-11-2019	2000		30-11-2019	2000
6	30-11-2019	2000		01-01-2020	4000
7	01-01-2020	2000		29-02-2020	2000
8	01-01-2020	2000		26-03-2020	2000
9	29-02-2020	2000		30-04-2020	2000
10	26-03-2020	2000		30-05-2020	2000
11	30-04-2020	2000		30-06-2020	2000
12	30-05-2020	2000		31-07-2020	2000
13	30-06-2020	2000		31-08-2020	4000
14	31-07-2020	2000		Grand Total	30000
15	31-08-2020	2000
16	31-08-2020	2000
17
Combine dates