Using COUNTIF with INDEX and LEN function in formula.

J

julhs

Active Member
Joined
Dec 3, 2018
Messages
407
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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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

K
  • Question
conditional formatting question
Replies
2
Views
157
kerm007
K
E
  • Solved
Get a 2D spilled formula to fulfill a distribution table matching the ranges of both dimensions
Replies
3
Views
62
Fluff
Fluff
gtd526
  • Solved
find last cell address in Range
Replies
3
Views
240
Peter_SSs
Peter_SSs
gtd526
  • Question
vba Sorting Columns w/ 2 Criteria's
Replies
1
Views
137
gtd526
gtd526
gtd526
  • Solved
vba selecting entire range from offset
Replies
5
Views
168
Tetra201
Tetra201

Forum statistics

Threads
1,215,036
Messages
6,122,794
Members
449,095
Latest member
m_smith_solihull

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