How to filter column with same unique match name and to obtain their average values

P

pankajgrover

Board Regular
Joined
Oct 27, 2022
Messages
157
Office Version
  1. 2021
Platform
  1. Windows
Here is my some stocks in excel. i want to filter my column "particular" to know average of shares by total / qty (sum of qty column) with matching same stocks. so i want 2 things, first avg of shares for each same name stocks and sum total number of same name stocks. Filter Result should come in last blank Column onwards.. how will do that . here is excel sheet. Thanks
ParticularQtyBuy/SellPricetotal
NSE SAIL 29 Aug 202425BUY135.73392.5
NSE GUJGASLTD 29 Aug 20245BUY643.53217.5
NSE TITAN 29 Aug 202411BUY3347.736824.7
NSE BHEL 29 Aug 202450BUY28714350
NSE BANKNIFTY 28 Aug 20241BUY49899.949899.9
NSE HEROMOTOCO 29 Aug 20241BUY5187.75187.7
NSE SAIL 29 Aug 202425BUY135.843396
NSE BHEL 29 Aug 202425SELL287.87195
NSE HDFCBANK 29 Aug 202411BUY1610.6517717.15
NSE M&M 29 Aug 20244BUY2651.610606.4
NSE M&M 29 Aug 20241SELL2650.752650.75
NSE PFC 29 Aug 20245BUY475.52377.5
NSE GUJGASLTD 29 Aug 202425BUY649.316232.5
NSE PFC 29 Aug 20241BUY476.85476.85
NSE SBIN 29 Aug 202425BUY800.320007.5
NSE BAJFINANCE 29 Aug 20245BUY6536.3532681.75
NSE SBIN 29 Aug 202450BUY80140050
 
Sort by date Sort by votes
Try like this:
2024-08-12 Test some stuff.xlsm
NOPQRSTU
2ParticularQtyBuy/SellPricetotalOps CountQty SumAvg Price
3NSE SAIL 29 Aug 202425BUY135.703 392.50250135.77
4NSE GUJGASLTD 29 Aug 20245BUY643.503 217.50230648.3333333
5NSE TITAN 29 Aug 202411BUY3 347.7036 824.701113347.7
6NSE BHEL 29 Aug 202450BUY287.0014 350.00150287
7NSE BANKNIFTY 28 Aug 20241BUY49 899.9049 899.901149899.9
8NSE HEROMOTOCO 29 Aug 20241BUY5 187.705 187.70115187.7
9NSE SAIL 29 Aug 202425BUY135.843 396.00250135.77
10NSE BHEL 29 Aug 202425SELL287.807 195.00125287.8
11NSE HDFCBANK 29 Aug 202411BUY1 610.6517 717.151111610.65
12NSE M&M 29 Aug 20244BUY2 651.6010 606.40142651.6
13NSE M&M 29 Aug 20241SELL2 650.752 650.75112650.75
14NSE PFC 29 Aug 20245BUY475.502 377.5026475.725
15NSE GUJGASLTD 29 Aug 202425BUY649.3016 232.50230648.3333333
16NSE PFC 29 Aug 20241BUY476.85476.8526475.725
17NSE SBIN 29 Aug 202425BUY800.3020 007.50275800.7666667
18NSE BAJFINANCE 29 Aug 20245BUY6 536.3532 681.75156536.35
19NSE SBIN 29 Aug 202450BUY801.0040 050.00275800.7666667
Sheet1
Cell Formulas
RangeFormula
S3:S19S3=SUM(SUBTOTAL(3,OFFSET($P$3:$P$19,ROW($P$3:$P$19)-MIN(ROW($P$3:$P$19)),,1))*($N$3:$N$19=N3)*($P$3:$P$19=P3))
T3:T19T3=SUM(SUBTOTAL(9,OFFSET($O$3:$O$19,ROW($O$3:$O$19)-MIN(ROW($O$3:$O$19)),,1))*($N$3:$N$19=N3)*($P$3:$P$19=P3))
U3:U19U3=SUM(SUBTOTAL(9,OFFSET($R$3:$R$19,ROW($R$3:$R$19)-MIN(ROW($R$3:$R$19)),,1))*($N$3:$N$19=N3)*($P$3:$P$19=P3))/T3
 
Upvote 0

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Just the bought stocks? Or how do you want to average them (if all)?
 
Last edited:
Upvote 0
Ok here my attempt.

Formula in column H, just the bought ones.
Formula in column K, is subtracting the sold stocks (quantity and total price). So for example for this stock:

NSE BHEL 29 Aug 202450BUY28714350
NSE BHEL 29 Aug 202425SELL287.87195


You would have a net amount of 25 (50-25) and a net of total of 7155 (14350 - 7195). Would that be correct?

Book1.xlsx
ABCDEFGHIJKL
1ParticularQtyBuy/SellPricetotalParticularAvg priceParticularAvg price
2NSE BAJFINANCE 29 Aug 20245BUY6536.3532681.75NSE BAJFINANCE 29 Aug 20246536.35NSE BAJFINANCE 29 Aug 20246536.35
3NSE BANKNIFTY 28 Aug 20241BUY49899.949899.9NSE BANKNIFTY 28 Aug 202449899.9NSE BANKNIFTY 28 Aug 202449899.9
4NSE BHEL 29 Aug 202450BUY28714350NSE BHEL 29 Aug 2024287NSE BHEL 29 Aug 2024286.2
5NSE BHEL 29 Aug 202425SELL287.87195NSE GUJGASLTD 29 Aug 2024648.33333NSE GUJGASLTD 29 Aug 2024648.3333
6NSE GUJGASLTD 29 Aug 20245BUY643.53217.5NSE HDFCBANK 29 Aug 20241610.65NSE HDFCBANK 29 Aug 20241610.65
7NSE GUJGASLTD 29 Aug 202425BUY649.316232.5NSE HEROMOTOCO 29 Aug 20245187.7NSE HEROMOTOCO 29 Aug 20245187.7
8NSE HDFCBANK 29 Aug 202411BUY1610.6517717.15NSE M&M 29 Aug 20242651.6NSE M&M 29 Aug 20242651.883
9NSE HEROMOTOCO 29 Aug 20241BUY5187.75187.7NSE PFC 29 Aug 2024475.725NSE PFC 29 Aug 2024475.725
10NSE M&M 29 Aug 20244BUY2651.610606.4NSE SAIL 29 Aug 2024135.77NSE SAIL 29 Aug 2024135.77
11NSE M&M 29 Aug 20241SELL2650.752650.75NSE SBIN 29 Aug 2024800.76667NSE SBIN 29 Aug 2024800.7667
12NSE PFC 29 Aug 20245BUY475.52377.5NSE TITAN 29 Aug 20243347.7NSE TITAN 29 Aug 20243347.7
13NSE PFC 29 Aug 20241BUY476.85476.85
14NSE SAIL 29 Aug 202425BUY135.73392.5
15NSE SAIL 29 Aug 202425BUY135.843396
16NSE SBIN 29 Aug 202425BUY800.320007.5
17NSE SBIN 29 Aug 202450BUY80140050
18NSE TITAN 29 Aug 202411BUY3347.736824.7
Sheet3
Cell Formulas
RangeFormula
H2:I12H2=LET( p, $A$2:$A$1000, q, $B$2:$B$1000, bs, $C$2:$C$1000, t, $E$2:$E$1000, up, SORT(UNIQUE(FILTER(p, p<>""))), HSTACK(up, BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="BUY")*(p=x)))/SUM(FILTER(q, (bs="BUY")*(p=x)))))) )
K2:L12K2=LET( p, $A$2:$A$1000, q, $B$2:$B$1000, bs, $C$2:$C$1000, t, $E$2:$E$1000, up, SORT(UNIQUE(FILTER(p, p<>""))), HSTACK(up, BYROW(up, LAMBDA(x, SUM(FILTER(t, p=x)*IF(FILTER(bs, p=x)="BUY", 1, -1))/SUM(FILTER(q, p=x)*IF(FILTER(bs, p=x)="BUY", 1, -1))))) )
Dynamic array formulas.
 
Upvote 0
felixstraube said:
Ok here my attempt.

Formula in column H, just the bought ones.
Formula in column K, is subtracting the sold stocks (quantity and total price). So for example for this stock:

NSE BHEL 29 Aug 202450BUY28714350
NSE BHEL 29 Aug 202425SELL287.87195


You would have a net amount of 25 (50-25) and a net of total of 7155 (14350 - 7195). Would that be correct?

Book1.xlsx
ABCDEFGHIJKL
1ParticularQtyBuy/SellPricetotalParticularAvg priceParticularAvg price
2NSE BAJFINANCE 29 Aug 20245BUY6536.3532681.75NSE BAJFINANCE 29 Aug 20246536.35NSE BAJFINANCE 29 Aug 20246536.35
3NSE BANKNIFTY 28 Aug 20241BUY49899.949899.9NSE BANKNIFTY 28 Aug 202449899.9NSE BANKNIFTY 28 Aug 202449899.9
4NSE BHEL 29 Aug 202450BUY28714350NSE BHEL 29 Aug 2024287NSE BHEL 29 Aug 2024286.2
5NSE BHEL 29 Aug 202425SELL287.87195NSE GUJGASLTD 29 Aug 2024648.33333NSE GUJGASLTD 29 Aug 2024648.3333
6NSE GUJGASLTD 29 Aug 20245BUY643.53217.5NSE HDFCBANK 29 Aug 20241610.65NSE HDFCBANK 29 Aug 20241610.65
7NSE GUJGASLTD 29 Aug 202425BUY649.316232.5NSE HEROMOTOCO 29 Aug 20245187.7NSE HEROMOTOCO 29 Aug 20245187.7
8NSE HDFCBANK 29 Aug 202411BUY1610.6517717.15NSE M&M 29 Aug 20242651.6NSE M&M 29 Aug 20242651.883
9NSE HEROMOTOCO 29 Aug 20241BUY5187.75187.7NSE PFC 29 Aug 2024475.725NSE PFC 29 Aug 2024475.725
10NSE M&M 29 Aug 20244BUY2651.610606.4NSE SAIL 29 Aug 2024135.77NSE SAIL 29 Aug 2024135.77
11NSE M&M 29 Aug 20241SELL2650.752650.75NSE SBIN 29 Aug 2024800.76667NSE SBIN 29 Aug 2024800.7667
12NSE PFC 29 Aug 20245BUY475.52377.5NSE TITAN 29 Aug 20243347.7NSE TITAN 29 Aug 20243347.7
13NSE PFC 29 Aug 20241BUY476.85476.85
14NSE SAIL 29 Aug 202425BUY135.73392.5
15NSE SAIL 29 Aug 202425BUY135.843396
16NSE SBIN 29 Aug 202425BUY800.320007.5
17NSE SBIN 29 Aug 202450BUY80140050
18NSE TITAN 29 Aug 202411BUY3347.736824.7
Sheet3
Cell Formulas
RangeFormula
H2:I12H2=LET( p, $A$2:$A$1000, q, $B$2:$B$1000, bs, $C$2:$C$1000, t, $E$2:$E$1000, up, SORT(UNIQUE(FILTER(p, p<>""))), HSTACK(up, BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="BUY")*(p=x)))/SUM(FILTER(q, (bs="BUY")*(p=x)))))) )
K2:L12K2=LET( p, $A$2:$A$1000, q, $B$2:$B$1000, bs, $C$2:$C$1000, t, $E$2:$E$1000, up, SORT(UNIQUE(FILTER(p, p<>""))), HSTACK(up, BYROW(up, LAMBDA(x, SUM(FILTER(t, p=x)*IF(FILTER(bs, p=x)="BUY", 1, -1))/SUM(FILTER(q, p=x)*IF(FILTER(bs, p=x)="BUY", 1, -1))))) )
Dynamic array formulas.
Click to expand...
Hi thanks for reply, Actually i forgot to mention 1 more column before A1. that is date column and i mostly use filter date. so can i check the date of average shares.. from your advice i like your idea , that if results go another sheet2 for both buy and sell colmns.. like
Formula in sheet 2, any col. , just the bought ones average price
and Formula in sheet2 any col. , just the sells ones average price..
I do not have requirement adding and subtracting the sold stocks ...
Also if possible in sheet 1, i need two cells which i type and filter data accordingly
like 1st cell name stocks as i type stock name it filters.. and 2nd cell if i type date like 12/08 it filters .. it will be easy for me not click every time go dropdown and filter and clear..
and one of my system has office proplus 2021.. if it will be compatible with formulas that will be good...
For example i created new sheet below:
Thanks

Shares Search Filter APPLE.xlsx
ABCDEF
1Filter options:
2Stocks
3Date
4
5DateParticularQtyBuy/SellPriceTotals
606/08/2024 MICROSOFT25BUY135.73392.5
706/08/2024 SAMSUNG5BUY643.53217.5
806/08/2024 NETFLIX11BUY3347.736824.7
906/08/2024 APPLE50BUY28714350
1006/08/2024 MICROSOFT5SELL49899.9249499.5
1106/08/2024 APPLE25BUY287.87195
1206/08/2024 MICROSOFT11BUY1610.6517717.15
1306/08/2024 SAMSUNG4BUY2651.610606.4
1405/08/2024 APPLE1SELL475.5475.5
1505/08/2024 MICROSOFT25BUY649.316232.5
1605/08/2024 SAMSUNG1BUY476.85476.85
1704/08/2024 NETFLIX25BUY800.320007.5
1804/08/2024 APPLE1SELL475.5475.5
Sheet1
 
Last edited:
Upvote 0
Would this work?

Book1.xlsx
ABCDEFGHIJK
1
2StocksMicro
3Date06/08/2024
4
5DateParticularQtyBuy/SellPriceTotalsStockBuy AvgSell Avg
606/08/2024 MICROSOFT25BUY135.73392.5 MICROSOFT586.3791749899.9
706/08/2024 SAMSUNG5BUY643.53217.5
806/08/2024 NETFLIX11BUY3347.736824.7
906/08/2024 APPLE50BUY28714350
1006/08/2024 MICROSOFT5SELL49899.9249499.5
1106/08/2024 APPLE25BUY287.87195
1206/08/2024 MICROSOFT11BUY1610.6517717.15
1306/08/2024 SAMSUNG4BUY2651.610606.4
1405/08/2024 APPLE1SELL475.5475.5
1505/08/2024 MICROSOFT25BUY649.316232.5
1605/08/2024 SAMSUNG1BUY476.85476.85
1704/08/2024 NETFLIX25BUY800.320007.5
1804/08/2024 APPLE1SELL475.5475.5
19
Stocks
Cell Formulas
RangeFormula
H6:J6H6=LET(a, $A$6:$F$1000, f, FILTER(a, (CHOOSECOLS(a, 1)=$D$3)*(ISNUMBER(SEARCH($D$2, CHOOSECOLS(a, 2))))), p, CHOOSECOLS(f, 2), q, CHOOSECOLS(f, 3), bs, CHOOSECOLS(f, 4), t, CHOOSECOLS(f, 6), up, SORT(UNIQUE(FILTER(p, p<>""))), buy, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="BUY")*(p=x)))/SUM(FILTER(q, (bs="BUY")*(p=x))))), ""), sell, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="SELL")*(p=x)))/SUM(FILTER(q, (bs="SELL")*(p=x))))), ""), HSTACK(up, buy, sell) )
Dynamic array formulas.
 
Upvote 0
I think the average price of "NSE BHEL 29 Aug 2024" is "286.2".
(14350-7195)/(50-25)=286.2

And the average price of NSE M&M 29 Aug 2024 is "2651.88".
(10606.4-2650.75)/(4-1)=2651.88
 
Upvote 0
felixstraube said:
Would this work?

Book1.xlsx
ABCDEFGHIJK
1
2StocksMicro
3Date06/08/2024
4
5DateParticularQtyBuy/SellPriceTotalsStockBuy AvgSell Avg
606/08/2024 MICROSOFT25BUY135.73392.5 MICROSOFT586.3791749899.9
706/08/2024 SAMSUNG5BUY643.53217.5
806/08/2024 NETFLIX11BUY3347.736824.7
906/08/2024 APPLE50BUY28714350
1006/08/2024 MICROSOFT5SELL49899.9249499.5
1106/08/2024 APPLE25BUY287.87195
1206/08/2024 MICROSOFT11BUY1610.6517717.15
1306/08/2024 SAMSUNG4BUY2651.610606.4
1405/08/2024 APPLE1SELL475.5475.5
1505/08/2024 MICROSOFT25BUY649.316232.5
1605/08/2024 SAMSUNG1BUY476.85476.85
1704/08/2024 NETFLIX25BUY800.320007.5
1804/08/2024 APPLE1SELL475.5475.5
19
Stocks
Cell Formulas
RangeFormula
H6:J6H6=LET(a, $A$6:$F$1000, f, FILTER(a, (CHOOSECOLS(a, 1)=$D$3)*(ISNUMBER(SEARCH($D$2, CHOOSECOLS(a, 2))))), p, CHOOSECOLS(f, 2), q, CHOOSECOLS(f, 3), bs, CHOOSECOLS(f, 4), t, CHOOSECOLS(f, 6), up, SORT(UNIQUE(FILTER(p, p<>""))), buy, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="BUY")*(p=x)))/SUM(FILTER(q, (bs="BUY")*(p=x))))), ""), sell, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="SELL")*(p=x)))/SUM(FILTER(q, (bs="SELL")*(p=x))))), ""), HSTACK(up, buy, sell) )
Dynamic array formulas.
Click to expand...
Hi thanks for your efforts, we are very close to our goal.. 1 issue found if i put no date .. data not comes in results window.. if i put blank date in D3 , then result all data average according to D2, if i put suppose 06/08/2024 then only this date average.. by the way Microsoft buy average not correct as i calculate.. also pls show results stock - buy qty - buy avg & sell qty - sell avg. thanks..
 
Upvote 0
How about this?:

Book1.xlsx
ABCDEFGHIJKL
1
2Stocksm
3Date
4
5DateParticularQtyBuy/SellPriceTotalsStockBuy QtyBuy AvgSell QtySell Avg
606/08/2024 MICROSOFT25BUY135.73392.5 MICROSOFT61612.1664549899.9
706/08/2024 SAMSUNG5BUY643.53217.5 SAMSUNG101430.075
806/08/2024 NETFLIX11BUY3347.736824.7
906/08/2024 APPLE50BUY28714350
1006/08/2024 MICROSOFT5SELL49899.9249499.5
1106/08/2024 APPLE25BUY287.87195
1206/08/2024 MICROSOFT11BUY1610.6517717.15
1306/08/2024 SAMSUNG4BUY2651.610606.4
1405/08/2024 APPLE1SELL475.5475.5
1505/08/2024 MICROSOFT25BUY649.316232.5
1605/08/2024 SAMSUNG1BUY476.85476.85
1704/08/2024 NETFLIX25BUY800.320007.5
1804/08/2024 APPLE1SELL475.5475.5
Stocks
Cell Formulas
RangeFormula
H6:L7H6=LET(a, $A$6:$F$1000, date, $D$3, f, IF(date<>"", FILTER(a, (CHOOSECOLS(a, 1)=date)*(ISNUMBER(SEARCH($D$2, CHOOSECOLS(a, 2))))), FILTER(a, (ISNUMBER(SEARCH($D$2, CHOOSECOLS(a, 2)))))), p, CHOOSECOLS(f, 2), q, CHOOSECOLS(f, 3), bs, CHOOSECOLS(f, 4), t, CHOOSECOLS(f, 6), up, SORT(UNIQUE(FILTER(p, p<>""))), buy, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="BUY")*(p=x)))/SUM(FILTER(q, (bs="BUY")*(p=x))))), ""), buy_q, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(q, (bs="BUY")*(p=x))))), ""), sell, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="SELL")*(p=x)))/SUM(FILTER(q, (bs="SELL")*(p=x))))), ""), sell_q, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(q, (bs="SELL")*(p=x))))), ""), HSTACK(up, buy_q, buy, sell_q,sell) )
Dynamic array formulas.


Why is the result for microsoft not correct? what would be the correct value? how are you calculating it?
 
Upvote 0
felixstraube said:
How about this?:

Book1.xlsx
ABCDEFGHIJKL
1
2Stocksm
3Date
4
5DateParticularQtyBuy/SellPriceTotalsStockBuy QtyBuy AvgSell QtySell Avg
606/08/2024 MICROSOFT25BUY135.73392.5 MICROSOFT61612.1664549899.9
706/08/2024 SAMSUNG5BUY643.53217.5 SAMSUNG101430.075
806/08/2024 NETFLIX11BUY3347.736824.7
906/08/2024 APPLE50BUY28714350
1006/08/2024 MICROSOFT5SELL49899.9249499.5
1106/08/2024 APPLE25BUY287.87195
1206/08/2024 MICROSOFT11BUY1610.6517717.15
1306/08/2024 SAMSUNG4BUY2651.610606.4
1405/08/2024 APPLE1SELL475.5475.5
1505/08/2024 MICROSOFT25BUY649.316232.5
1605/08/2024 SAMSUNG1BUY476.85476.85
1704/08/2024 NETFLIX25BUY800.320007.5
1804/08/2024 APPLE1SELL475.5475.5
Stocks
Cell Formulas
RangeFormula
H6:L7H6=LET(a, $A$6:$F$1000, date, $D$3, f, IF(date<>"", FILTER(a, (CHOOSECOLS(a, 1)=date)*(ISNUMBER(SEARCH($D$2, CHOOSECOLS(a, 2))))), FILTER(a, (ISNUMBER(SEARCH($D$2, CHOOSECOLS(a, 2)))))), p, CHOOSECOLS(f, 2), q, CHOOSECOLS(f, 3), bs, CHOOSECOLS(f, 4), t, CHOOSECOLS(f, 6), up, SORT(UNIQUE(FILTER(p, p<>""))), buy, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="BUY")*(p=x)))/SUM(FILTER(q, (bs="BUY")*(p=x))))), ""), buy_q, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(q, (bs="BUY")*(p=x))))), ""), sell, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(t, (bs="SELL")*(p=x)))/SUM(FILTER(q, (bs="SELL")*(p=x))))), ""), sell_q, IFERROR(BYROW(up, LAMBDA(x, SUM(FILTER(q, (bs="SELL")*(p=x))))), ""), HSTACK(up, buy_q, buy, sell_q,sell) )
Dynamic array formulas.


Why is the result for microsoft not correct? what would be the correct value? how are you calculating it?
Click to expand...

Wow sir, now its perfect working thanks (y) :love:.. sorry it was my mistake , your previous calculation was also right , i take wrong qty.. One last thing sir, as i put stocks and date in box , can below data displayed accordingly.. it will be easy for me to look when i have more data, here below example :


Shares Search Filter APPLE.xlsx
ABCDEF
1
2StocksMicro
3Date06/08/2024
4
5DateParticularQtyBuy/SellPriceTotals
606/08/2024 MICROSOFT25BUY135.73392.5
1006/08/2024 MICROSOFT5SELL49899.9249499.5
1206/08/2024 MICROSOFT11BUY1610.6517717.15
1505/08/2024 MICROSOFT25BUY649.316232.5
Sheet3
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
Not able to correct filter data date wise, Kindly correct my formula...
Replies
1
Views
141
Anthony47
A
P
  • Question
How to obtain average values on columns filter
Replies
3
Views
179
StephenCrump
S
E
  • Solved
Count unique values with 2 conditions
2
Replies
12
Views
947
Fluff
Fluff
U
  • Solved
Index formula with matching - Can it look at rows and columns?
Replies
2
Views
333
usnapoleon
U
V
  • Solved
sum table based on rows and multiple years columns
Replies
2
Views
493
vampsthevampyre
V

Forum statistics

Threads
1,221,310
Messages
6,159,176
Members
451,543
Latest member
cesymcox

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