• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get the Date for 30% amount received

Vikas_Salvi

New Member
UnitRcpt DateSum of Amt-PSSum of PercentagePercentage
C-1001
23-Dec-23​
4,76,1905%
5%​
C-1001
22-Jan-24​
4,47,6204%
9%​
C-1001
19-Feb-24​
9,52,3809%
18%​
C-1001
20-Feb-24​
9,09,6059%
26%​
C-1001
23-Feb-24​
6,50,0006%
33%​
C-1001
15-Mar-24​
2,48,3062%
35%​
C-1003
23-Dec-23​
95,2381%
1%​
C-1003
08-Jan-24​
1,02,0961%
3%​
C-1003
12-Feb-24​
18,53,92827%
30%​
C-1004
27-Feb-24​
95,2381%
1%​
C-1004
01-Mar-24​
-0%
1%​
C-1004
07-Mar-24​
9,5240%
2%​
C-1004
08-Mar-24​
1,71,4283%
4%​
C-1004
25-Mar-24​
15,74,25123%
28%​
C-1004
29-Mar-24​
5,00,2947%
35%​
 
Maybe, just maybe:

1712136872977.png

Code:
=INDEX($B$2:$B$16,XMATCH(0.3,IF($A$2:$A$16=A2,$E$2:$E$16),1))
 
Back
Top