Help with a formula please!
Closed
einfald
Posts
1
Registration date
Tuesday December 3, 2013
Status
Member
Last seen
December 4, 2013
-
Dec 4, 2013 at 12:06 AM
einfald - Dec 5, 2013 at 02:23 AM
einfald - Dec 5, 2013 at 02:23 AM
Related:
- Help with a formula please!
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 5, 2013 at 12:39 AM
Dec 5, 2013 at 12:39 AM
suppose date in col A and B from A1 are like this
date amount
9-Dec-13 1
10-Dec-13 2
11-Dec-13 3
10-Dec-13 4
11-Dec-13 5
1-Dec-13 6
10-Dec-13 7
in C2 (repeat C2)type this formula and copy down
=IF(AND(COUNTIF($A$2:OFFSET(A$1,COUNTA(A:A)-1,0,1,1),A2)>=1,COUNTIF(A2:$A$2,A2)=1),SUMPRODUCT(($A$2:OFFSET(A$1,COUNTA(A:A)-1,0,1,1)=A2)*($B$2:OFFSET(A$1,COUNTA(A:A)-1,1,1,1))),"x")
is this col. C you want?
date amount
9-Dec-13 1
10-Dec-13 2
11-Dec-13 3
10-Dec-13 4
11-Dec-13 5
1-Dec-13 6
10-Dec-13 7
in C2 (repeat C2)type this formula and copy down
=IF(AND(COUNTIF($A$2:OFFSET(A$1,COUNTA(A:A)-1,0,1,1),A2)>=1,COUNTIF(A2:$A$2,A2)=1),SUMPRODUCT(($A$2:OFFSET(A$1,COUNTA(A:A)-1,0,1,1)=A2)*($B$2:OFFSET(A$1,COUNTA(A:A)-1,1,1,1))),"x")
is this col. C you want?
Dec 5, 2013 at 02:23 AM