3 payment some payments not made or paid in full

CrashOD

Board Regular
Joined
Feb 5, 2019
Messages
118
Office Version
  1. 2021
  2. 2016
Platform
  1. Windows
C5, C13 ect School Date
Im trying to have it check workbook for 2022
1. check workbook if cell C has "" then "Unpaid"
2. checks to see if D6 - D8 if F5<d6:d8 then pulls info from L in workbook for 2022 school (sometime people dont pay all three so some cells will not have a number why i was try sumif)
3. if f5>d6:d8 due to some payments being made but not all three then ="Short"
4. if all others fail because it was paid but not by partial payments but in full it looks at 2022 book and pulls info from C

i hope you can understand this if not please ask.

were pulls info into
(Not Done) Real Esate Taxes.xlsx
ABCDEFGHIJ
1ParcelProperty LocationProperty TypeProperty DescriptionCurrent MailingAptCITY, STATE, ZIP
2015-02-007-100-A920 E SUNBURY ST RESIDENTIALLOT 28.5 X 115.10920 E SUNBURY ST SHAMOKIN PA 17872
3NAMEDATEBILL #DISCOUNTFACEPENALTYASSESSMENTNOTESpecial
42022 C&LBAGLIEN SUZANNE LEONAUNPAID01500024$741.24$756.38$832.03$8,500 
52022 SCHOOLBAGLIEN SUZANNE LEONA01/00/190001500022$217.87$222.32$244.55$8,500 
62022 SCHOOLPayment 18/3/2022#1$74.12FACE
72022 SCHOOLPayment 2 (Penalty 9/15)09/06/2022$74.10FACE
82022 SCHOOLPayment 3 (Penalty 11/1)10/03/2022$74.10FACE
9Total DuePaid In Full  
10015-02-007-100-A011-01-003-054010-01-002-223017-01-009-218
11NAMEDATEBILL #DISCOUNTFACEPENALTYASSESSMENTNOTESpecial
122021 C&LBAGLIEN SUZANNE LEONA6/30/202101500025$741.24$756.38$832.03$8,500 
132021 SCHOOLBAGLIEN SUZANNE LEONA#VALUE!1500026$225.13$229.72$252.69$8,500 
142021 SCHOOLPayment 1   
152021 SCHOOLPayment 2 (Penalty 9/15)   
162021 SCHOOLPayment 3 (Penalty 11/1)   
17Total  
Real Estate History
Cell Formulas
RangeFormula
B2B2=INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$R$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),3)
C2C2=INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$Q$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),2)
D2D2=INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$S$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),4)
E2E2=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$Z$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),6)
F2F2=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AA$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),7)
G2G2=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AB$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),8)
B4B4=INDEX('[RLE_County Local 2022.xls]Real Estate'!$A$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
C4C4=IF(INDEX('[RLE_County Local 2022.xls]Real Estate'!$C$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)="","UNPAID",INDEX('[RLE_County Local 2022.xls]Real Estate'!$C$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1))
D4D4=INDEX('[RLE_County Local 2022.xls]Real Estate'!$B$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
E4E4=INDEX('[RLE_County Local 2022.xls]Real Estate'!$H$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
F4F4=INDEX('[RLE_County Local 2022.xls]Real Estate'!$I$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
G4G4=INDEX('[RLE_County Local 2022.xls]Real Estate'!$J$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
H4H4=INDEX('[RLE_County Local 2022.xls]Real Estate'!$N$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
I4I4=IF(INDEX('[RLE_County Local 2022.xls]Real Estate'!$G$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)="","",INDEX('[RLE_County Local 2022.xls]Real Estate'!$G$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1))
J4J4=IF(INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$T$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)="","",INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$T$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),5))
B5B5=INDEX('[Rle_School 2022.xls]Real Estate'!$A$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)
C5C5=IF(INDEX('[Rle_School 2022.xls]Real Estate'!C$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","UNPAID",IF(F5<=SUMIF(C6:C8,"<>",D6:D8),INDEX('[Rle_School 2022.xls]Real Estate'!L$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1),IF(D9="",INDEX('[Rle_School 2022.xls]Real Estate'!C$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1),"SHORT")))
D5D5=INDEX('[Rle_School 2022.xls]Real Estate'!$B$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)
E5E5=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AE$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),11)
F5F5=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AF$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),12)
G5G5=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AG$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),13)
H5H5=INDEX('[Rle_School 2022.xls]Real Estate'!$T$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)
I5I5=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$G$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$G$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1))
C6C6=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$H$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$H$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1))
D6D6=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$I$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$I$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1))
E6,E14E6=IF(C6="","",IF(C6>0,"FACE"))
C7C7=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$J$2:$AN$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AN$2:$AN$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$J2:$AN$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AN$2:$AN$7003,0),1))
D7D7=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$K$2:$AN$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AN$2:$AN$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$K$2:$AN$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AN$2:$AN$7003,0),1))
E15,E7:E8E7=IF(D6="","",IF(C5="UNPAID","",IF(D7="","",IF(D6>=D7,"FACE",IF(D6<D7,"PENALTY")))))
C8C8=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$L$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$L$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1))
D8D8=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$M$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1)="","",IF(INDEX('[Rle_School 2022.xls]Real Estate'!$M$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1)>0,INDEX('[Rle_School 2022.xls]Real Estate'!$M$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1),""))
D9D9=IF(D6="","",IF(SUMIF(C6:C8,"<>",D6:D8)>=F5,"Paid In Full",IF(F5>SUMIF(C6:C8,"<>",D6:D8),SUMIF(C6:C8,"<>",D6:D8)-F5,"help")))
E9,E17E9=IF($D9>=0,"","SHORT in Face")
F9F9=IF(D6="","",IF(F5<=SUM(D6,D7,D8),"",IF(SUM(F5,-N(D6),-N(D7),-N(D8))<0.03,"Paid In Full",IF(F5>SUM(D6,D8,D8),SUM(F5,-N(D32),-N(D6),-N(D7)),"help"))))
D12D12=INDEX('C&L 2021'!$B$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
E12E12=INDEX('C&L 2021'!$H$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
F12F12=INDEX('C&L 2021'!$I$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
G12G12=INDEX('C&L 2021'!$J$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
H12H12=INDEX('C&L 2021'!$K$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
I12I12=IF(INDEX('C&L 2021'!$G$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)="","",INDEX('C&L 2021'!$G$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1))
J12J12=IF(INDEX('C&L 2021'!$L$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)="","",INDEX('C&L 2021'!$L$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),5))
B12B12=INDEX('C&L 2021'!$A$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
B13B13=INDEX('SK 2021'!$A$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)
D13D13=INDEX('SK 2021'!$B$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)
E13E13=INDEX('SK 2021'!$U$2:$Y$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),5)
F13F13=INDEX('SK 2021'!$U$2:$Z$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),6)
G13G13=INDEX('SK 2021'!$U$2:$AA$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),7)
H13H13=INDEX('SK 2021'!$T$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)
I13I13=IF(INDEX('SK 2021'!$G$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$G$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
D14D14=IF(INDEX('SK 2021'!$I$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$I$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
D15D15=IF(INDEX('SK 2021'!$K$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$K$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
D16D16=IF(INDEX('SK 2021'!$L$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$L$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
E16E16=IF(D15="","",IF(C14="UNPAID","",IF(D16="","",IF(D14>=D16,"FACE",IF(D14<D16,"PENALTY")))))
D17D17=IF(SUMIF(C14:C16,"<>",D14:D16)=0,"",IF(SUMIF(C14:C16,"<>",D14:D16)>=F13,"Paid In Full",IF(F13>SUMIF(C14:C16,"<>",D14:D16),SUMIF(C14:C16,"<>",D14:D16)-F13,"help")))
C12C12=IF(INDEX('C&L 2021'!$C$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)="","UNPAID",INDEX('C&L 2021'!$C$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1))
C13C13=IF(INDEX('SK 2021'!$C$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","UNPAID",IF(F13<=SUMIF(C14:C16,"<>",D14:D16),INDEX('SK 2021'!$L$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1),IF(D17="",INDEX('SK 2021'!$C$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1,"SHORT"))))
C14C14=IF(INDEX('SK 2021'!$H$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$H$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
C15C15=IF(INDEX('SK 2021'!$J$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$J$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
C16C16=IF(INDEX('SK 2021'!$L$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$K$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
Cells with Conditional Formatting
CellConditionCell FormatStop If True
D17Cell Value<0textNO
D9Cell Value<0textNO


2021 School
(Not Done) Real Esate Taxes.xlsx
ABCDEFGHIJKLMNOPQRSTU
3315BAGLIEN SUZANNE LEONA150002612/03/2021P250225.13229.72252.69156501512-48500015-02-007-100-A
SK 2021
Cells with Conditional Formatting
CellConditionCell FormatStop If True
U4017:U4192,U2479:U2518,U575:U827,U3:U573,U1092:U1124,U830:U1090,U1126:U1294,U1380:U1428,U1431:U1532,U1704:U1736,U1535:U1629,U1738:U1832,U1834:U2302,U2306:U2315,U2328:U2357,U2359:U2371,U2379:U2387,U2389:U2405,U2407:U2414,U2416:U2441,U2461:U2476,U2321:U2326Cell ValueduplicatestextNO


2022 School 3 payments

Payment 1
Rle_School 2022.xls
ABCDEFGHIJKLMNOPTUVWZAAABAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDSDTDUDVDWDXDYDZEAEBECEDEEEFEGEHEIEJEKELEMENEOEPEQERESETEUEVEWEXEYEZFAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZGAGBGCGDGEGFGGGHGIGJGKGLGMGNGOGPGQGRGSGTGUGVGWGXGYGZHAHBHCHDHEHFHGHHHIHJHKHLHMHNHOHPHQHRHSHTHUHVHWHXHYHZIAIBICIDIEIFIGIHIIIJIKILIMINIOIPIQIRISITIUIV
927BAGLIEN SUZANNE LEONA015000228/3/2022F221#1 - PARTIAL PAY8/3/2022#174.12$217.87$222.32$244.558500015-02-007-100-ARemoved Personal Info LOT 28.5 X 115.10 Removed Personal Info Removed Personal Info 8500YES
Real Estate
Cell Formulas
RangeFormula
AI927AI927=IF(AH927, "YES", "NO")


Payment 2
Rle_School 2022.xls
ABCDEFGHIJKLMNOPTUVWZAAABAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDSDTDUDVDWDXDYDZEAEBECEDEEEFEGEHEIEJEKELEMENEOEPEQERESETEUEVEWEXEYEZFAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZGAGBGCGDGEGFGGGHGIGJGKGLGMGNGOGPGQGRGSGTGUGVGWGXGYGZHAHBHCHDHEHFHGHHHIHJHKHLHMHNHOHPHQHRHSHTHUHVHWHXHYHZIAIBICIDIEIFIGIHIIIJIKILIMINIOIPIQIRISITIUIV
2349BAGLIEN SUZANNE LEONA015000229/6/2022F2238/3/2022#174.1209/06/2274.1$217.87$74.10$244.558500015-02-007-100-ARemoved Personal Info LOT 28.5 X 115.10 Removed Personal Info Removed Personal Info 8500YES015-02-007-100-A
Real Estate
Cell Formulas
RangeFormula
O2349O2349=K2349
AI2349AI2349=IF(AH2349, "YES", "NO")


Payment 3
Rle_School 2022.xls
ABCDEFGHIJKLMNOPTUVWZAAABAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDSDTDUDVDWDXDYDZEAEBECEDEEEFEGEHEIEJEKELEMENEOEPEQERESETEUEVEWEXEYEZFAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZGAGBGCGDGEGFGGGHGIGJGKGLGMGNGOGPGQGRGSGTGUGVGWGXGYGZHAHBHCHDHEHFHGHHHIHJHKHLHMHNHOHPHQHRHSHTHUHVHWHXHYHZIAIBICIDIEIFIGIHIIIJIKILIMINIOIPIQIRISITIUIV
2482BAGLIEN SUZANNE LEONA0150002210/3/2022F224#2THERE WAS OVER PAYMENT ON BILL OF $7.41 APPLIED TO COUNTY & LOCAL PARTIAL PAY8/3/2022#174.1209/06/2274.110/03/2274.1$217.87$74.10$244.558500015-02-007-100-ARemoved Personal Info LOT 28.5 X 115.10 Removed Personal Info Removed Personal Info 8500YES015-02-007-100-A
Real Estate
Cell Formulas
RangeFormula
O2482O2482=K2482
AI2482AI2482=IF(AH2482, "YES", "NO")
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
=IF(INDEX('[Rle_School 2022.xls]Real Estate'!C$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","UNPAID",IF(D9="Paid In Full",C8, if(D9="",INDEX('[Rle_School 2022.xls]Real Estate'!C$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1), "Short")))

doing it this way may of fixed my problem/ do you see were a problem may happen?
 
Upvote 0

Forum statistics

Threads
1,224,225
Messages
6,177,272
Members
452,765
Latest member
Erka Gizli

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