gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 673
- Office Version
- 2019
- Platform
- Windows
Hello,
Want to add allowing duplicate entries and original entries to G:G using the existing formula.
thank you
Want to add allowing duplicate entries and original entries to G:G using the existing formula.
thank you
The Whole Enchilada.xlsm | |||||||
---|---|---|---|---|---|---|---|
F | G | H | I | J | |||
27 | 6/14/24 | SOXL | $30.30 | $59.01 | $114.84 | ||
28 | 6/18/24 | QQQU | $33.40 | $34.05 | $2.28 | ||
29 | 6/18/24 | AIBU | $27.20 | $28.05 | $3.66 | ||
30 | 6/21/24 | WEBL | $14.28 | $16.54 | $19.89 | ||
31 | |||||||
32 | |||||||
33 | |||||||
34 | |||||||
Capital Gains Tax |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F30:F34 | F30 | =IF(G30="","",TODAY()) |
G30:G34 | G30 | =IFERROR(LOOKUP(2, 1/((COUNTIF(G$26:$G29,'Roth IRA'!$A$9:$A$15)=0)*('Roth IRA'!$A$9:$A$15<>"")*('Roth IRA'!$T$9:$T$15="sold")),'Roth IRA'!$A$9:$A$15),"") |
H30:H34 | H30 | =IF(G30<>"",AVERAGEIF('Roth IRA'!$A$9:$A$15,G30,'Roth IRA'!$E$9:$E$15),"") |
I30:I34 | I30 | =IF(G30<>"",AVERAGEIF('Roth IRA'!$A$9:$A$15,G30,'Roth IRA'!$F$9:$F$15),"") |
J30:J34 | J30 | =IF(G30="","",IF(VLOOKUP(G30,'Roth IRA'!$A$9:$K$15,11,0)<0,VLOOKUP(G30,'Roth IRA'!$A$9:$K$15,11,0),VLOOKUP(G30,'Roth IRA'!$A$9:$R$15,18,0))) |
Press CTRL+SHIFT+ENTER to enter array formulas. |