Add another criteria to Excel Nested FILTER (Spillable) Functions

T

TheHack22

Board Regular
Joined
Feb 3, 2021
Messages
121
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hi Excel Gurus,

I have posted question here before, regarding this project, I did receive a lot of help. I'm about to wrap it up but just can't figure how to do this part. I needed to tweak these Spillable nested Filter Function (In Yellow) to include another criterion, which I can explain by the below:
IF Column [Type] = "Clients B" & If [Firm] = "Acme Corporation", include these in the filter.
I would like to add this argument to cells C3:G3 formulas. Please see XL2BB sheet attached.

Also, my IF(AND) Function is not working in Column [Criteria2] (a simple function - This is driving me crazy, can't figure why it's not working).

Can someone please help me with these?


Clients Analysis 11.22.2022.xlsx
ABCDEFG
1PositionSeq#CompaniesCountLowHighAverage
2Partners
31)Acme Corporation15$14,625$49,500$32,895
42)Cupcake LLC5$13,050$51,750$32,400
53)Éclair Inc7$22,500$43,875$32,786
64)Grant & Eisenhoffer P.A.4$20,250$45,000$36,000
75)Globex Corporation4$10,125$12,375$11,419
86)Home Furnishing7$10,800$56,250$40,082
97)Hooli13$16,875$46,125$26,671
108)Initech15$12,375$54,000$33,435
Summary B
Cell Formulas
RangeFormula
B3:B10B3=SEQUENCE(COUNTA(C3#))
C3:C10C3=UNIQUE(FILTER(Plaintiff_AllData[Firm],(Plaintiff_AllData[Position]="Partner")*((Plaintiff_AllData[Type]="Clients")+(Plaintiff_AllData[Type]="Clients A"))))
D3:D10D3=BYROW(C3#,LAMBDA(Co,COUNT(FILTER(Plaintiff_AllData[Rate],(Plaintiff_AllData[Firm]=Co)*(Plaintiff_AllData[Position]="Partner")*(ISNUMBER(MATCH(Plaintiff_AllData[Type],{"Clients","Clients A"},0)))))))
E3:E10E3=BYROW(C3#,LAMBDA(Co,AGGREGATE(15,6,Plaintiff_AllData[Rate]/((Plaintiff_AllData[Firm]=Co)*(Plaintiff_AllData[Position]="Partner")*(ISNUMBER(MATCH(Plaintiff_AllData[Type],{"Clients","Clients A"},0)))),1)))
F3:F10F3=BYROW(C3#,LAMBDA(Co,AGGREGATE(14,6,Plaintiff_AllData[Rate]/((Plaintiff_AllData[Firm]=Co)*(Plaintiff_AllData[Position]="Partner")*(ISNUMBER(MATCH(Plaintiff_AllData[Type],{"Clients","Clients A"},0)))),1)))
G3:G10G3=BYROW(C3#,LAMBDA(Co,AVERAGE(FILTER(Plaintiff_AllData[Rate],(Plaintiff_AllData[Firm]=Co)*(Plaintiff_AllData[Position]="Partner")*(ISNUMBER(MATCH(Plaintiff_AllData[Type],{"Clients","Clients A"},0))),NA()))))
Dynamic array formulas.
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C4:C12Cell ValueduplicatestextNO




Clients Analysis 11.22.2022.xlsx
ABCDEFGH
1RateGraded PositionPositionTypeFirmYearCriteria Criteria2
2$18,000Junior AssociatePartnerClients AAcme Corporation2022 
3$19,125Midlevel AssociatePartnerClients AAcme Corporation2022 
4$16,875ParalegalParalegalClientsAcme Corporation2022 
5$14,625ParalegalParalegalClientsAcme Corporation2022 
6$15,750ParalegalPartnerClients AAcme Corporation2022 
7$14,625ParalegalPartnerClients AAcme Corporation2022 
8$13,500ParalegalParalegalClientsAcme Corporation2022 
9$18,000ParalegalParalegalClientsAcme Corporation2022 
10$42,750Senior PartnerPartnerClientsAcme Corporation2022 
11$43,650Senior PartnerPartnerClientsAcme Corporation2022 
12$49,500Senior PartnerPartnerClients AAcme Corporation2022 
13$45,000Senior PartnerPartnerClients AAcme Corporation2022 
14$42,750Senior PartnerPartnerClients AAcme Corporation2022 
15$43,650Senior PartnerPartnerClients AAcme Corporation2022 
16$38,250Senior PartnerPartnerClientsAcme Corporation2022 
17$40,500Senior PartnerPartnerClientsAcme Corporation2022 
18$42,750Senior PartnerPartnerClientsAcme Corporation2022 
19$18,000Staff AttorneyStaff AttorneyClientsAcme Corporation2022 
20$19,125Staff AttorneyStaff AttorneyClientsAcme Corporation2022 
21$18,000Staff AttorneyStaff AttorneyClientsAcme Corporation2022 
22$18,000Staff AttorneyStaff AttorneyClientsAcme Corporation2022 
23$19,125Staff AttorneyPartnerClients AAcme Corporation2022 
24$18,000Staff AttorneyPartnerClients AAcme Corporation2022 
25$13,050ParalegalPartnerClients ACupcake LLC2022 
26$15,075ParalegalPartnerClients ACupcake LLC2022 
27$13,950ParalegalParalegalClientsCupcake LLC2022 
28$14,625ParalegalParalegalClientsCupcake LLC2022 
29$34,875Senior PartnerPartnerClientsCupcake LLC2022 
30$47,250Senior PartnerPartnerClientsCupcake LLC2022 
31$51,750Senior PartnerPartnerClientsCupcake LLC2022 
32$19,125Midlevel AssociateAssociateClientsÉclair Inc2022 
33$28,125Senior AssociatePartnerClients AÉclair Inc2022 
34$22,500Senior AssociatePartnerClients AÉclair Inc2022 
35$27,000Senior AssociatePartnerClients AÉclair Inc2022 
36$13,275ParalegalParalegalClientsÉclair Inc2022 
37$13,275ParalegalParalegalClientsÉclair Inc2022 
38$13,950ParalegalParalegalClientsÉclair Inc2022 
39$31,500Midlevel PartnerPartnerClientsÉclair Inc2022 
40$43,875Senior PartnerPartnerClientsÉclair Inc2022 
41$38,250Senior PartnerPartnerClientsÉclair Inc2022 
42$38,250Senior PartnerPartnerClientsÉclair Inc2022 
43$16,425Junior AssociateAssociateClientsGrant & Eisenhoffer P.A.2022 
44$16,425Junior AssociateAssociateClientsGrant & Eisenhoffer P.A.2022 
45$33,750Senior AssociatePartnerClients AGrant & Eisenhoffer P.A.2022 
46$20,250Senior AssociatePartnerClients AGrant & Eisenhoffer P.A.2022 
47$9,450ParalegalParalegalClientsGrant & Eisenhoffer P.A.2022 
48$9,900ParalegalParalegalClientsGrant & Eisenhoffer P.A.2022 
49$45,000Senior PartnerPartnerClientsGrant & Eisenhoffer P.A.2022 
50$45,000Senior PartnerPartnerClientsGrant & Eisenhoffer P.A.2022 
51$24,750Senior AssociateAssociateClientsGlobex Corporation2022 
52$13,725ParalegalParalegalClientsGlobex Corporation2022 
53$12,375ParalegalParalegalClientsGlobex Corporation2022 
54$11,475ParalegalPartnerClients AGlobex Corporation2022 
55$10,125ParalegalPartnerClients AGlobex Corporation2022 
56$12,375ParalegalPartnerClients AGlobex Corporation2022 
57$11,700ParalegalPartnerClients AGlobex Corporation2022 
58$10,800ParalegalPartnerClients AHome Furnishing2022 
59$10,125ParalegalParalegalClientsHome Furnishing2022 
60$13,725ParalegalParalegalClientsHome Furnishing2022 
61$41,400Senior PartnerPartnerClientsHome Furnishing2022 
62$47,250Senior PartnerPartnerClientsHome Furnishing2022 
63$56,250Senior PartnerPartnerClientsHome Furnishing2022 
64$43,875Senior PartnerPartnerClients BHome Furnishing2022 
65$43,875Senior PartnerPartnerClients BHome Furnishing2022 
66$56,250Senior PartnerPartnerClients BHome Furnishing2022 
67$58,500Senior PartnerPartnerClients BHome Furnishing2022 
68$39,375Senior PartnerPartnerClientsHome Furnishing2022 
69$41,625Senior PartnerPartnerClientsHome Furnishing2022 
70$43,875Senior PartnerPartnerClientsHome Furnishing2022 
71$18,225Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
72$17,775Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
73$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
74$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
75$15,750Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
76$20,250Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
77$15,750Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
78$15,750Staff AttorneyStaff AttorneyClients BAcme Corporation2022Include 
79$16,875Staff AttorneyStaff AttorneyClients BAcme Corporation2022Include 
80$18,225Staff AttorneyStaff AttorneyClients BAcme Corporation2022Include 
81$18,225Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
82$18,000Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
83$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
84$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
85$14,175Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
86$15,750Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
87$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
88$20,250Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
89$20,250Junior AssociateAssociateClientsHooli2022 
90$20,250Junior AssociateAssociateClientsHooli2022 
91$20,250Junior AssociateAssociateClientsHooli2022 
92$20,250Junior AssociatePartnerClients AHooli2022 
93$16,875Junior AssociatePartnerClients AHooli2022 
94$20,250Junior AssociatePartnerClients AHooli2022 
95$20,250Junior AssociatePartnerClients AHooli2022 
96$20,250Junior AssociatePartnerClients AHooli2022 
97$18,000Midlevel AssociatePartnerClients AHooli2022 
98$20,250Midlevel AssociatePartnerClients AHooli2022 
99$18,675Midlevel AssociatePartnerClients AHooli2022 
100$23,175Midlevel AssociateAssociateClientsHooli2022 
101$14,400ParalegalParalegalClientsHooli2022 
102$35,100Junior PartnerPartnerClientsHooli2022 
103$41,400Senior PartnerPartnerClients BHooli2022 
104$45,000Senior PartnerPartnerClients BHooli2022 
105$45,000Senior PartnerPartnerClients BHooli2022 
106$32,625Senior PartnerPartnerClientsHooli2022 
107$46,125Senior PartnerPartnerClientsHooli2022 
108$41,400Senior PartnerPartnerClientsHooli2022 
109$36,675Senior PartnerPartnerClientsHooli2022 
110$20,700Staff AttorneyStaff AttorneyClientsHooli2022 
111$25,875Junior AssociateAssociateClientsInitech2022 
112$18,000Junior AssociateAssociateClientsInitech2022 
113$16,875Junior AssociateAssociateClientsInitech2022 
114$37,800Of CounselOf CounselClientsInitech2022 
115$24,300Of CounselPartnerClients AInitech2022 
116$49,050Of CounselPartnerClients AInitech2022 
117$12,375ParalegalPartnerClients AInitech2022 
118$13,050ParalegalPartnerClients AInitech2022 
119$12,375ParalegalPartnerClients AInitech2022 
120$34,650Junior PartnerPartnerClients AInitech2022 
121$34,200Junior PartnerPartnerClients AInitech2022 
122$30,375Junior PartnerPartnerClients AInitech2022 
123$34,200Junior PartnerPartnerClientsInitech2022 
124$35,100Midlevel PartnerPartnerClientsInitech2022 
125$37,800Senior PartnerPartnerClientsInitech2022 
126$36,900Senior PartnerPartnerClientsInitech2022 
127$43,650Senior PartnerPartnerClients BInitech2022 
128$54,000Senior PartnerPartnerClientsInitech2022 
129$43,650Senior PartnerPartnerClientsInitech2022 
130$49,500Senior PartnerPartnerClientsInitech2022 
131$60,750Senior PartnerPartnerClients BAcme Corporation2022Include 
132$41,400Senior PartnerPartnerClients BAcme Corporation2022Include 
Plaintiff All RawData-Combined
Cell Formulas
RangeFormula
H2:H132H2=IF(AND([@Firm]="Home Furnishing",[Type]="Clients B"),"Include","")


Imran
 
Last edited:

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Sort by date Sort by votes
TheHack22 said:
Hi Excel Gurus,

I have posted question here before, regarding this project, I did receive a lot of help. I'm about to wrap it up but just can't figure how to do this part. I needed to tweak these Spillable nested Filter Function (In Yellow) to include another criterion, which I can explain by the below:
IF Column [Type] = "Clients B" & If [Firm] = "Acme Corporation", include these in the filter.
I would like to add this argument to cells C3:G3 formulas. Please see XL2BB sheet attached.

Also, my IF(AND) Function is not working in Column [Criteria2] (a simple function - This is driving me crazy, can't figure why it's not working).

Can someone please help me with these?


Clients Analysis 11.22.2022.xlsx
ABCDEFG
1PositionSeq#CompaniesCountLowHighAverage
2Partners
31)Acme Corporation15$14,625$49,500$32,895
42)Cupcake LLC5$13,050$51,750$32,400
53)Éclair Inc7$22,500$43,875$32,786
64)Grant & Eisenhoffer P.A.4$20,250$45,000$36,000
75)Globex Corporation4$10,125$12,375$11,419
86)Home Furnishing7$10,800$56,250$40,082
97)Hooli13$16,875$46,125$26,671
108)Initech15$12,375$54,000$33,435
Summary B
Cell Formulas
RangeFormula
B3:B10B3=SEQUENCE(COUNTA(C3#))
C3:C10C3=UNIQUE(FILTER(Plaintiff_AllData[Firm],(Plaintiff_AllData[Position]="Partner")*((Plaintiff_AllData[Type]="Clients")+(Plaintiff_AllData[Type]="Clients A"))))
D3:D10D3=BYROW(C3#,LAMBDA(Co,COUNT(FILTER(Plaintiff_AllData[Rate],(Plaintiff_AllData[Firm]=Co)*(Plaintiff_AllData[Position]="Partner")*(ISNUMBER(MATCH(Plaintiff_AllData[Type],{"Clients","Clients A"},0)))))))
E3:E10E3=BYROW(C3#,LAMBDA(Co,AGGREGATE(15,6,Plaintiff_AllData[Rate]/((Plaintiff_AllData[Firm]=Co)*(Plaintiff_AllData[Position]="Partner")*(ISNUMBER(MATCH(Plaintiff_AllData[Type],{"Clients","Clients A"},0)))),1)))
F3:F10F3=BYROW(C3#,LAMBDA(Co,AGGREGATE(14,6,Plaintiff_AllData[Rate]/((Plaintiff_AllData[Firm]=Co)*(Plaintiff_AllData[Position]="Partner")*(ISNUMBER(MATCH(Plaintiff_AllData[Type],{"Clients","Clients A"},0)))),1)))
G3:G10G3=BYROW(C3#,LAMBDA(Co,AVERAGE(FILTER(Plaintiff_AllData[Rate],(Plaintiff_AllData[Firm]=Co)*(Plaintiff_AllData[Position]="Partner")*(ISNUMBER(MATCH(Plaintiff_AllData[Type],{"Clients","Clients A"},0))),NA()))))
Dynamic array formulas.
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C4:C12Cell ValueduplicatestextNO




Clients Analysis 11.22.2022.xlsx
ABCDEFGH
1RateGraded PositionPositionTypeFirmYearCriteria Criteria2
2$18,000Junior AssociatePartnerClients AAcme Corporation2022 
3$19,125Midlevel AssociatePartnerClients AAcme Corporation2022 
4$16,875ParalegalParalegalClientsAcme Corporation2022 
5$14,625ParalegalParalegalClientsAcme Corporation2022 
6$15,750ParalegalPartnerClients AAcme Corporation2022 
7$14,625ParalegalPartnerClients AAcme Corporation2022 
8$13,500ParalegalParalegalClientsAcme Corporation2022 
9$18,000ParalegalParalegalClientsAcme Corporation2022 
10$42,750Senior PartnerPartnerClientsAcme Corporation2022 
11$43,650Senior PartnerPartnerClientsAcme Corporation2022 
12$49,500Senior PartnerPartnerClients AAcme Corporation2022 
13$45,000Senior PartnerPartnerClients AAcme Corporation2022 
14$42,750Senior PartnerPartnerClients AAcme Corporation2022 
15$43,650Senior PartnerPartnerClients AAcme Corporation2022 
16$38,250Senior PartnerPartnerClientsAcme Corporation2022 
17$40,500Senior PartnerPartnerClientsAcme Corporation2022 
18$42,750Senior PartnerPartnerClientsAcme Corporation2022 
19$18,000Staff AttorneyStaff AttorneyClientsAcme Corporation2022 
20$19,125Staff AttorneyStaff AttorneyClientsAcme Corporation2022 
21$18,000Staff AttorneyStaff AttorneyClientsAcme Corporation2022 
22$18,000Staff AttorneyStaff AttorneyClientsAcme Corporation2022 
23$19,125Staff AttorneyPartnerClients AAcme Corporation2022 
24$18,000Staff AttorneyPartnerClients AAcme Corporation2022 
25$13,050ParalegalPartnerClients ACupcake LLC2022 
26$15,075ParalegalPartnerClients ACupcake LLC2022 
27$13,950ParalegalParalegalClientsCupcake LLC2022 
28$14,625ParalegalParalegalClientsCupcake LLC2022 
29$34,875Senior PartnerPartnerClientsCupcake LLC2022 
30$47,250Senior PartnerPartnerClientsCupcake LLC2022 
31$51,750Senior PartnerPartnerClientsCupcake LLC2022 
32$19,125Midlevel AssociateAssociateClientsÉclair Inc2022 
33$28,125Senior AssociatePartnerClients AÉclair Inc2022 
34$22,500Senior AssociatePartnerClients AÉclair Inc2022 
35$27,000Senior AssociatePartnerClients AÉclair Inc2022 
36$13,275ParalegalParalegalClientsÉclair Inc2022 
37$13,275ParalegalParalegalClientsÉclair Inc2022 
38$13,950ParalegalParalegalClientsÉclair Inc2022 
39$31,500Midlevel PartnerPartnerClientsÉclair Inc2022 
40$43,875Senior PartnerPartnerClientsÉclair Inc2022 
41$38,250Senior PartnerPartnerClientsÉclair Inc2022 
42$38,250Senior PartnerPartnerClientsÉclair Inc2022 
43$16,425Junior AssociateAssociateClientsGrant & Eisenhoffer P.A.2022 
44$16,425Junior AssociateAssociateClientsGrant & Eisenhoffer P.A.2022 
45$33,750Senior AssociatePartnerClients AGrant & Eisenhoffer P.A.2022 
46$20,250Senior AssociatePartnerClients AGrant & Eisenhoffer P.A.2022 
47$9,450ParalegalParalegalClientsGrant & Eisenhoffer P.A.2022 
48$9,900ParalegalParalegalClientsGrant & Eisenhoffer P.A.2022 
49$45,000Senior PartnerPartnerClientsGrant & Eisenhoffer P.A.2022 
50$45,000Senior PartnerPartnerClientsGrant & Eisenhoffer P.A.2022 
51$24,750Senior AssociateAssociateClientsGlobex Corporation2022 
52$13,725ParalegalParalegalClientsGlobex Corporation2022 
53$12,375ParalegalParalegalClientsGlobex Corporation2022 
54$11,475ParalegalPartnerClients AGlobex Corporation2022 
55$10,125ParalegalPartnerClients AGlobex Corporation2022 
56$12,375ParalegalPartnerClients AGlobex Corporation2022 
57$11,700ParalegalPartnerClients AGlobex Corporation2022 
58$10,800ParalegalPartnerClients AHome Furnishing2022 
59$10,125ParalegalParalegalClientsHome Furnishing2022 
60$13,725ParalegalParalegalClientsHome Furnishing2022 
61$41,400Senior PartnerPartnerClientsHome Furnishing2022 
62$47,250Senior PartnerPartnerClientsHome Furnishing2022 
63$56,250Senior PartnerPartnerClientsHome Furnishing2022 
64$43,875Senior PartnerPartnerClients BHome Furnishing2022 
65$43,875Senior PartnerPartnerClients BHome Furnishing2022 
66$56,250Senior PartnerPartnerClients BHome Furnishing2022 
67$58,500Senior PartnerPartnerClients BHome Furnishing2022 
68$39,375Senior PartnerPartnerClientsHome Furnishing2022 
69$41,625Senior PartnerPartnerClientsHome Furnishing2022 
70$43,875Senior PartnerPartnerClientsHome Furnishing2022 
71$18,225Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
72$17,775Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
73$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
74$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
75$15,750Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
76$20,250Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
77$15,750Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
78$15,750Staff AttorneyStaff AttorneyClients BAcme Corporation2022Include 
79$16,875Staff AttorneyStaff AttorneyClients BAcme Corporation2022Include 
80$18,225Staff AttorneyStaff AttorneyClients BAcme Corporation2022Include 
81$18,225Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
82$18,000Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
83$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
84$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
85$14,175Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
86$15,750Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
87$19,125Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
88$20,250Staff AttorneyStaff AttorneyClientsHome Furnishing2022 
89$20,250Junior AssociateAssociateClientsHooli2022 
90$20,250Junior AssociateAssociateClientsHooli2022 
91$20,250Junior AssociateAssociateClientsHooli2022 
92$20,250Junior AssociatePartnerClients AHooli2022 
93$16,875Junior AssociatePartnerClients AHooli2022 
94$20,250Junior AssociatePartnerClients AHooli2022 
95$20,250Junior AssociatePartnerClients AHooli2022 
96$20,250Junior AssociatePartnerClients AHooli2022 
97$18,000Midlevel AssociatePartnerClients AHooli2022 
98$20,250Midlevel AssociatePartnerClients AHooli2022 
99$18,675Midlevel AssociatePartnerClients AHooli2022 
100$23,175Midlevel AssociateAssociateClientsHooli2022 
101$14,400ParalegalParalegalClientsHooli2022 
102$35,100Junior PartnerPartnerClientsHooli2022 
103$41,400Senior PartnerPartnerClients BHooli2022 
104$45,000Senior PartnerPartnerClients BHooli2022 
105$45,000Senior PartnerPartnerClients BHooli2022 
106$32,625Senior PartnerPartnerClientsHooli2022 
107$46,125Senior PartnerPartnerClientsHooli2022 
108$41,400Senior PartnerPartnerClientsHooli2022 
109$36,675Senior PartnerPartnerClientsHooli2022 
110$20,700Staff AttorneyStaff AttorneyClientsHooli2022 
111$25,875Junior AssociateAssociateClientsInitech2022 
112$18,000Junior AssociateAssociateClientsInitech2022 
113$16,875Junior AssociateAssociateClientsInitech2022 
114$37,800Of CounselOf CounselClientsInitech2022 
115$24,300Of CounselPartnerClients AInitech2022 
116$49,050Of CounselPartnerClients AInitech2022 
117$12,375ParalegalPartnerClients AInitech2022 
118$13,050ParalegalPartnerClients AInitech2022 
119$12,375ParalegalPartnerClients AInitech2022 
120$34,650Junior PartnerPartnerClients AInitech2022 
121$34,200Junior PartnerPartnerClients AInitech2022 
122$30,375Junior PartnerPartnerClients AInitech2022 
123$34,200Junior PartnerPartnerClientsInitech2022 
124$35,100Midlevel PartnerPartnerClientsInitech2022 
125$37,800Senior PartnerPartnerClientsInitech2022 
126$36,900Senior PartnerPartnerClientsInitech2022 
127$43,650Senior PartnerPartnerClients BInitech2022 
128$54,000Senior PartnerPartnerClientsInitech2022 
129$43,650Senior PartnerPartnerClientsInitech2022 
130$49,500Senior PartnerPartnerClientsInitech2022 
131$60,750Senior PartnerPartnerClients BAcme Corporation2022Include 
132$41,400Senior PartnerPartnerClients BAcme Corporation2022Include 
Plaintiff All RawData-Combined
Cell Formulas
RangeFormula
H2:H132H2=IF(AND([@Firm]="Home Furnishing",[Type]="Clients B"),"Include","")


Imran
Click to expand...
Your formula
Excel Formula: 
=IF(AND([@Firm]="Home Furnishing",[Type]="Clients B"),"Include","")
"[Type]" should be "[@Type]". Didn't really look at the first part.
 
Upvote 0
jdellasala said:
Your formula
Excel Formula: 
=IF(AND([@Firm]="Home Furnishing",[Type]="Clients B"),"Include","")
"[Type]" should be "[@Type]". Didn't really look at the first part.
Click to expand...
Hi jdellasala

Thanks very much. That solved the issue with the IF(AND).
I was wondering if you're able to help with the other.
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
How to make Spillable: COUNTIFS,MINIFS, MAXIFS,PERCENTILE(IF.. Functions?
Replies
7
Views
2K
Fluff
Fluff
T
  • Solved
MS Excel COUNTIFS, MAXIFS, MINIFS, AVERAGEIFS with OR condition
Replies
5
Views
792
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,816
Messages
6,181,138
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top