Hello all,
This is the function:
IFERROR(INDEX(Sheet2!$A$2:$G$200,SMALL(IF((Sheet2!$A$2:$A$200=$A$2)*(Sheet2!$B$2:$B$200=$B$2),ROW(Sheet2!$A$2:$A$200)-MIN(ROW(Sheet2!$A$2:$A$200))+1),ROWS($A$5:$A7)),),"")
If I want to add:
Sheet2!$C$2:$C$200=Left($C$2,3)='pqc' OR Sheet2!$C$2:$C$200=Left($C$2,3)='ttt' OR Sheet2!$C$2:$C$200=Left($c$2)='ggg'
Then grab the columns
if not, then do this:
if Sheet2!$C$2:$C$200=Left($C$2,3)='TED' OR Sheet2!$C$2:$C$200=Left($C$2,3)='Shd' OR Sheet2!$C$2:$C$200=Left($c$2)='bbb'
Can I bring the result and then do OR on it?
Please let me know.
Regards,
Adding OR for third array
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
Re: Adding OR for third array
I don't understand the question - that looks like one simple OR with 6 options, not two separate tests.
Regards,
Rory
Rory
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Adding OR for third array
I want to say if the first 2 letters is ab, cd, nm, kf then do this if not do other stuff. I wanted to add it to the function in the thread.
Regards,
Green
Regards,
Green
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Adding OR for third array
The way you ask your question makes it impossible to understand what you want. Slow down and try to explain as clearly as you can and in unambiguous detail, what you want the formula to do.
Best wishes,
Hans
Hans