gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
Looking to add <>"FNGG" OR <>"TECL" in the following formula: I already have the <>TECL.
INDEX('2x3x'!$A$9:$A$30,MATCH(TRUE,INDEX('2x3x'!$A$9:$A$30<>"TECL",0),0))
Thank you
Looking to add <>"FNGG" OR <>"TECL" in the following formula: I already have the <>TECL.
INDEX('2x3x'!$A$9:$A$30,MATCH(TRUE,INDEX('2x3x'!$A$9:$A$30<>"TECL",0),0))
Thank you
The Whole Enchilada.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
8 | Symbol | Sector | Type | Shares | Cost | ||
9 | FNGG | FANGs Bull 2x | Long | 1 | $ 31.00 | ||
10 | TECL | Tech 3x | Long | 1 | $ 22.77 | ||
11 | DXQLX | Mthly NASD-100 1.75x | Long | 1 | $ 33.15 | ||
12 | UBOT | AI & Automation 2x | Long | 1 | $ 12.30 | ||
13 | SPXL | S&P 500 3X | Long | 1 | $ 63.03 | ||
2x3x |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B9:B13 | B9 | =IF(COUNTIF(Sectors!$A$2:$AAT$47,$A9)=1,INDEX(Sectors!$A$2:$AAT$2,MAX((Sectors!$A$2:$AAT$47=$A9)*(COLUMN(Sectors!$A$2:$AAT$2)))),"") |
Press CTRL+SHIFT+ENTER to enter array formulas. |