Using COUNTIF with INDEX and LEN function in formula.

J

julhs

Active Member
Joined
Dec 3, 2018
Messages
471
Office Version
  1. 2010
Platform
  1. Windows
Need some help with adjusting the formula so it can pick up specific word within the string but the string will be of variable lengths before and after that word.

Adjusted accordingly, formula below is what I’m using at the moment in S20:V28 to get the figures I want.
Excel Formula: 
{=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S20),INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S20))),"")}

Trouble is it means I need 4 columns; I want to reduce that to 2 so that S20:S28 will show ALL eBay purchase values and T20:T28 will show ALL Amazon

Accounts 2016 - 2019 Currant.xlsm
OPQRSTUVWXYZAAABACAD
1
2CASH BOOKApril 6th 2020 - April 5th 2021
3DEBITS
4DateInvoice #Payment Method ListPayment Details ListBank & CashGen Insur Office Postage/ Stationary
5
6Jul-15gs0370PayPaleBay Apples5.005.00
7Jul-20gs0375PayPalOffice eBay print paper10.0010.00
8Jul-20gs0380PayPaleBay Pears15.0015.00
9Jul-20gs0385Debit CardAmazon20.0020.00
10Jul-20gs0390Debit CardOffice Amazon - Note books25.0025.00
11Jul-22gs0415PayPalOffice eBay - Print cartridges30.0030.00
12Jul-29gs0433Debit CardAmazon35.0035.00
13Desired out come for S20:S28 & T20:T28
14
15
16
17 eBayOffice ebayAmazonOffice AmazonAll eBayAll Amazon
18Details Office Office
19eBay print paper10.00
20Amazon - Note books25.005.0010.0020.0025.005.0020.00
21eBay - Print cartridges30.0015.0030.0035.00 10.0025.00
22      15.0035.00
23      30.00
24      
25      
26      
27      
2865.00    
29
30
April 20 - 21 (2)
Cell Formulas
RangeFormula
R17R17=IF(COUNTIF($R$5:$R16,#REF!&"*")>=ROWS(R17:R17), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(#REF!))=#REF!,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R17:R17))),0)
R19R19=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R19), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R19))),0)
R20R20=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R20), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R20))),0)
S20S20=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S20), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S20))),"")
T20T20=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T20), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T20))),"")
U20:U28U20= IF(SUMPRODUCT(--($R$5:$R$16=U$17))>=ROWS(U$20:U20),INDEX($S$5:$S$16,SMALL(IF($R$5:$R$16=U$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(U$20:U20))),"")
V20V20=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V20), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V20))),"")
R21R21=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R21), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R21))),0)
S21S21=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S21), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S21))),"")
T21T21=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T21), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T21))),"")
V21V21=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V21), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V21))),"")
R22R22=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R22), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R22))),0)
S22S22=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S22), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S22))),"")
T22T22=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T22), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T22))),"")
V22V22=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V22), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V22))),"")
R23R23=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R23), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R23))),0)
S23S23=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S23), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S23))),"")
T23T23=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T23), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T23))),"")
V23V23=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V23), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V23))),"")
R24R24=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R24), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R24))),0)
S24S24=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S24), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S24))),"")
T24T24=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T24), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T24))),"")
V24V24=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V24), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V24))),"")
R25R25=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R25), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R25))),0)
S25S25=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S25), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S25))),"")
T25T25=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T25), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T25))),"")
V25V25=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V25), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V25))),"")
R26R26=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R26), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R26))),0)
S26S26=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S26), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S26))),"")
T26T26=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T26), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T26))),"")
V26V26=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V26), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V26))),"")
R27R27=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R27), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R27))),0)
S27S27=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S27), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S27))),"")
T27T27=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T27), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T27))),"")
V27V27=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V27), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V27))),"")
R28R28=SUM(R$19:R27)
S28S28=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S28), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S28))),"")
T28T28=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T28), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T28))),"")
V28V28=IF(COUNTIF($R$5:$R$16,V17&"*")>=ROWS(V$20:V28), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(V$17))=V$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(V$20:V28))),"")
Q19Q19=TRIM(REPLACE(IF($R19>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R19,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R19,R19)))),1,6,""))
Q20Q20=TRIM(REPLACE(IF($R20>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R20,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R20,R20)))),1,6,""))
Q21Q21=TRIM(REPLACE(IF($R21>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R21,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R21,R21)))),1,6,""))
Q22Q22=TRIM(REPLACE(IF($R22>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R22,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R22,R22)))),1,6,""))
Q23Q23=TRIM(REPLACE(IF($R23>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R23,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R23,R23)))),1,6,""))
Q24Q24=TRIM(REPLACE(IF($R24>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R24,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R24,R24)))),1,6,""))
Q25Q25=TRIM(REPLACE(IF($R25>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R25,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R25,R25)))),1,6,""))
Q26Q26=TRIM(REPLACE(IF($R26>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R26,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R26,R26)))),1,6,""))
Q27Q27=TRIM(REPLACE(IF($R27>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R27,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R27,R27)))),1,6,""))
Press CTRL+SHIFT+ENTER to enter array formulas.
Cells with Conditional Formatting
CellConditionCell FormatStop If True
Q19:Q27Expression=R19>0textYES
P19:P28Expression=R19>0textYES
Q28Expression=$R28>0textYES
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
How about
+Fluff 1.xlsm
OPQRST
1
2CASH BOOKApril 6th 2020 - April 5th 2021
3DEBITS
4DateInvoice #Payment Method ListPayment Details ListBank & Cash
5
644757gs0370PayPaleBay Apples5
744762gs0375PayPalOffice eBay print paper10
844762gs0380PayPaleBay Pears15
944762gs0385Debit CardAmazon20
1044762gs0390Debit CardOffice Amazon - Note books25
1144764gs0415PayPalOffice eBay - Print cartridges30
1244771gs0433Debit CardAmazon35
13
14
15
16
170eBayAmazon
18Details Office Office
19eBay print paper10
20Amazon - Note books25520
21eBay - Print cartridges301025
22 01535
23 030 
24 0  
25 0  
26 0  
27 0  
2865  
Master
Cell Formulas
RangeFormula
R17R17=IF(COUNTIF($R$5:$R16,#REF!&"*")>=ROWS(R17:R17), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(#REF!))=#REF!,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R17:R17))),0)
R19R19=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R19), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R19))),0)
R20R20=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R20), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R20))),0)
S20:T27S20=IFERROR(INDEX($S$6:$S$12,AGGREGATE(15,6,(ROW($S$6:$S$12)-ROW($S$6)+1)/(ISNUMBER(SEARCH(S$17,$R$6:$R$12))),ROWS(S$20:S20))),"")
R21R21=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R21), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R21))),0)
R22R22=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R22), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R22))),0)
R23R23=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R23), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R23))),0)
R24R24=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R24), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R24))),0)
R25R25=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R25), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R25))),0)
R26R26=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R26), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R26))),0)
R27R27=IF(COUNTIF($R$5:$R16,R18&"*")>=ROWS(R19:R27), INDEX($AC$5:$AC16,SMALL(IF(LEFT($R$5:$R16,LEN(R18))=R18,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(R19:R27))),0)
R28R28=SUM(R$19:R27)
S28S28=IF(COUNTIF($R$5:$R16,S17&"*")>=ROWS(S20:S28), INDEX($S$5:S16,SMALL(IF(LEFT($R$5:$R16,LEN(S17))=S17,ROW($R$5:$R16)-ROW($R$5)+1),ROWS(S20:S28))),"")
T28T28=IF(COUNTIF($R$5:$R$16,T17&"*")>=ROWS(T$20:T28), INDEX($S$5:S$16,SMALL(IF(LEFT($R$5:$R$16,LEN(T$17))=T$17,ROW($R$5:$R$16)-ROW($R$5)+1),ROWS(T$20:T28))),"")
Q19Q19=TRIM(REPLACE(IF($R19>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R19,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R19,R19)))),1,6,""))
Q20Q20=TRIM(REPLACE(IF($R20>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R20,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R20,R20)))),1,6,""))
Q21Q21=TRIM(REPLACE(IF($R21>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R21,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R21,R21)))),1,6,""))
Q22Q22=TRIM(REPLACE(IF($R22>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R22,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R22,R22)))),1,6,""))
Q23Q23=TRIM(REPLACE(IF($R23>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R23,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R23,R23)))),1,6,""))
Q24Q24=TRIM(REPLACE(IF($R24>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R24,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R24,R24)))),1,6,""))
Q25Q25=TRIM(REPLACE(IF($R25>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R25,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R25,R25)))),1,6,""))
Q26Q26=TRIM(REPLACE(IF($R26>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R26,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R26,R26)))),1,6,""))
Q27Q27=TRIM(REPLACE(IF($R27>0,INDEX(R$5:R16,SMALL(IF(AC$5:AC16=R27,ROW(R$5:R16)-ROW(R$5)+1),COUNTIF(R19:R27,R27)))),1,6,""))
 
Upvote 0
Solution
Hi Fluff,
Thanks again, it is doing what I want!
But need to ask about the "AGGREGATE(15,6," part, specifically what the 15,6 is referencing too.
Need to understand that part so I can adjust it to use in different situation
 
Upvote 0
The 15 is telling aggregate to act like the SMALL function & the 6 is telling it to ignore errors.
 
Upvote 0
Ok thanks for that.
Think that will help me when I come to apply in different situation in real time.
I'm a past master at trying to plagiaris a formula, but I do come unstuck and often need help with it.
This one is a case in point!!
 
Upvote 0
Glad to help & thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Formulas with Inititals with Last Name
Replies
3
Views
115
Fluff
Fluff
K
  • Question Question
conditional formatting question
Replies
2
Views
602
kerm007
K
E
  • Solved
Get a 2D spilled formula to fulfill a distribution table matching the ranges of both dimensions
Replies
3
Views
270
Fluff
Fluff
K
  • Solved
Index with Multiple Conditions
Replies
2
Views
109
kivikatz
K
C
  • Question Question
Allocation Across Months
Replies
3
Views
491
NickFru
N

Forum statistics

Threads
1,224,621
Messages
6,179,938
Members
452,949
Latest member
beartooth91

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