Help with a formula please!
Closed
einfald
Posts
1
Registration date
Tuesday 3 December 2013
Status
Member
Last seen
4 December 2013
-
4 Dec 2013 à 00:06
einfald - 5 Dec 2013 à 02:23
einfald - 5 Dec 2013 à 02:23
Related:
- Help with a formula please!
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Formula bar in excel - Guide
- Credit summation formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
5 Dec 2013 à 00:39
5 Dec 2013 à 00:39
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?
5 Dec 2013 à 02:23