Edit formula to remove range

RAJESH1960

RAJESH1960

Banned for repeated rules violations
Joined
Mar 26, 2020
Messages
2,313
Office Version
  1. 2019
Platform
  1. Windows
Hello everyone
I have multiple formulas in a worksheet which are with range and I want to edit them and avoid the range. This is one of the formulas. Some of them are array formulas.
Rich (BB code): 
=VLOOKUP(D2,CHOOSE({1,2},'2A'!C7:C10000,'2A'!A7:A10000),2,0)
I am trying to edit the formula by deleting the range 10,000 but I keep getting an error like this
Rich (BB code): 
=VLOOKUP(D2,CHOOSE({1,2},'2A'!$C7:$C,'2A'!$A7:$A),2,0)
.
If someone can show me how to edit this formula I can try to edit the rest of the formulas accordingly.
 
Sort by date Sort by votes
Post the code for the subroutine that you are working on. the entire workbook is rarely needed and many people do not want to take the time to check it out to see if it is safe to use.
 
Upvote 0

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Rich (BB code): 
Option Explicit

Sub Print2AEdited()
With Sheets("2A Extract")

'=VLOOKUP(D2,CHOOSE({1,2},'2A'!C7:C10000,'2A'!A7:A10000),2,0)
    Range("A2").FormulaArray = "=VLOOKUP(D2,CHOOSE({1,2},'2A'!C7:C10000,'2A'!A7:A10000),2,0)"

'=VLOOKUP(D2,IF(ISNUMBER(D2),--B2B!$C:$E,B2B!$C:$E),3,0)
    Range("B2").FormulaArray = "=VLOOKUP(D2,IF(ISNUMBER(D2),--B2B!$C:$E,B2B!$C:$E),3,0)"

'=VLOOKUP(D2,IF(ISNUMBER(D2),--B2B!$C:$E,B2B!$C:$E),3,0)
    Range("C2").FormulaArray = "=VLOOKUP(D2,IF(ISNUMBER(D2),--B2B!$C:$E,B2B!$C:$E),3,0)"

' =IFERROR(IFERROR(VALUE(SUBSTITUTE(INDEX('2A'!$C$7:$C$10000,AGGREGATE(15,6,ROW($A$1:$A$9999)/(RIGHT('2A'!$C$7:$C$10000,5)="Total"),ROWS($1:1))),"-Total","")),SUBSTITUTE(INDEX('2A'!$C$7:$C$5963,AGGREGATE(15,6,ROW($A$1:$A$5991)/(RIGHT('2A'!$C$7:$C$5963,5)="Total"),ROWS($1:1))),"-Total","")),"")
    Range("D2").Formula = "=IFERROR(IFERROR(VALUE(SUBSTITUTE(INDEX('2A'!$C$7:$C$10000,AGGREGATE(15,6,ROW($A$1:$A$9999)/(RIGHT('2A'!$C$7:$C$10000,5)=""Total""),ROWS($1:1))),""-Total"","""")),SUBSTITUTE(INDEX('2A'!$C$7:$C$5963,AGGREGATE(15,6,ROW($A$1:$A$5991)/(RIGHT('2A'!$C$7:$C$5963,5)=""Total""),ROWS($1:1))),""-Total"","""")),"""")"

' =IFERROR(IFERROR(VALUE(SUBSTITUTE(INDEX('2A'!$C$7:$C$10000,AGGREGATE(15,6,ROW($A$1:$A$9999)/(RIGHT('2A'!$C$7:$C$10000,5)="Total"),ROWS($1:1))),"-Total","")),SUBSTITUTE(INDEX('2A'!$C$7:$C$5963,AGGREGATE(15,6,ROW($A$1:$A$5991)/(RIGHT('2A'!$C$7:$C$5963,5)="Total"),ROWS($1:1))),"-Total","")),"")
    Range("E2").Formula = "=IFERROR(IFERROR(VALUE(SUBSTITUTE(INDEX('2A'!$C$7:$C$10000,AGGREGATE(15,6,ROW($A$1:$A$9999)/(RIGHT('2A'!$C$7:$C$10000,5)=""Total""),ROWS($1:1))),""-Total"","""")),SUBSTITUTE(INDEX('2A'!$C$7:$C$5963,AGGREGATE(15,6,ROW($A$1:$A$5991)/(RIGHT('2A'!$C$7:$C$5963,5)=""Total""),ROWS($1:1))),""-Total"","""")),"""")"

'=INDEX('2A'!$B$7:$B$5947,MATCH(A2&D2,'2A'!$A$7:$A$5947&'2A'!$C$7:$C$5947,0))
    Range("F2").FormulaArray = "=INDEX('2A'!$B$7:$B$5947,MATCH(A2&D2,'2A'!$A$7:$A$5947&'2A'!$C$7:$C$5947,0))"

' =INDEX('2A'!$F$7:$F$5947,MATCH(A2&D2,'2A'!$A$7:$A$5947&'2A'!$C$7:$C$5947,0)) ... Array Formula
    Range("G2").FormulaArray = "=INDEX('2A'!$F$7:$F$5947,MATCH(A2&D2,'2A'!$A$7:$A$5947&'2A'!$C$7:$C$5947,0))" '

' =SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=H$1)*('2A'!$J$7:$J$9947))
    Range("H2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=H$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=I$1)*('2A'!$J$7:$J$9947))
    Range("I2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=I$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=J$1)*('2A'!$J$7:$J$9947))
    Range("J2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=J$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=K$1)*('2A'!$J$7:$J$9947))
    Range("K2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=K$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=L$1)*('2A'!$J$7:$J$9947))
    Range("L2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=L$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=M$1)*('2A'!$J$7:$J$9947))
    Range("M2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$K$7:$K$9947=0)*('2A'!$I$7:$I$9947=M$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=N$1)*('2A'!$J$7:$J$9947))
   Range("N2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=N$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=O$1)*('2A'!$J$7:$J$9947))
   Range("O2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=O$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=P$1)*('2A'!$J$7:$J$9947))
   Range("P2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=P$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=Q$1)*('2A'!$J$7:$J$9947))
   Range("Q2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=Q$1)*('2A'!$J$7:$J$9947))"

'=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=R$1)*('2A'!$J$7:$J$9947))
   Range("R2").Formula = "=SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$L$7:$L$9947=0)*('2A'!$I$7:$I$9947=R$1)*('2A'!$J$7:$J$9947))"

' =IF(OFFSET($N$1,ROW()-1,MATCH((S$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=S$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("S2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((S$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=S$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((T$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=T$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("T2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((T$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=T$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((U$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=U$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("U2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((U$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=U$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((V$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=V$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("V2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((V$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=V$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((W$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=W$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("W2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((W$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=W$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((X$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=X$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("X2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((X$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=X$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((Y$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=Y$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("Y2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((Y$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=Y$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((Z$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=Z$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("Z2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((Z$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=Z$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((AA$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AA$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("AA2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((AA$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AA$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($N$1,ROW()-1,MATCH((AB$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AB$1*2)*('2A'!$L$7:$L$9947)),0)
    Range("AB2").Formula = "=IF(OFFSET($N$1,ROW()-1,MATCH((AB$1*2),$N$1:$R$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AB$1*2)*('2A'!$L$7:$L$9947)),0)"

'=IF(OFFSET($H$1,ROW()-1,MATCH(AC$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AC$1)*('2A'!$K$7:$K$9947)),0)
    Range("AC2").Formula = "=IF(OFFSET($H$1,ROW()-1,MATCH(AC$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AC$1)*('2A'!$K$7:$K$9947)),0)"

'=IF(OFFSET($H$1,ROW()-1,MATCH(AD$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AD$1)*('2A'!$K$7:$K$9947)),0)
    Range("AD2").Formula = "=IF(OFFSET($H$1,ROW()-1,MATCH(AD$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AD$1)*('2A'!$K$7:$K$9947)),0)"

'=IF(OFFSET($H$1,ROW()-1,MATCH(AE$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AE$1)*('2A'!$K$7:$K$9947)),0)
    Range("AE2").Formula = "=IF(OFFSET($H$1,ROW()-1,MATCH(AE$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AE$1)*('2A'!$K$7:$K$9947)),0)"

'=IF(OFFSET($H$1,ROW()-1,MATCH(AF$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AF$1)*('2A'!$K$7:$K$9947)),0)
    Range("AF2").Formula = "=IF(OFFSET($H$1,ROW()-1,MATCH(AF$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AF$1)*('2A'!$K$7:$K$9947)),0)"

'=IF(OFFSET($H$1,ROW()-1,MATCH(AG$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AG$1)*('2A'!$K$7:$K$9947)),0)
    Range("AG2").Formula = "=IF(OFFSET($H$1,ROW()-1,MATCH(AG$1,$H$1:$M$1,0)-1)=0,SUMPRODUCT(--('2A'!$A$7:$A$9947='2A Extract'!$A2)*('2A'!$C$7:$C$9947=$D2)*('2A'!$I$7:$I$9947=AG$1)*('2A'!$K$7:$K$9947)),0)"

'=G2-SUM(H2:AG2)
    Range("AH2").Formula = "=G2-SUM(H2:AG2)"

'=INDEX('2A'!$P$7:$P$5947,MATCH(A2&D2,'2A'!$A$7:$A$5947&'2A'!$C$7:$C$5947,0))
    Range("AI2").FormulaArray = "=INDEX('2A'!$P$7:$P$5947,MATCH(A2&D2,'2A'!$A$7:$A$5947&'2A'!$C$7:$C$5947,0))"
    

End With

End Sub
 
Upvote 0
Errors.png

I placed the call module right and the errors are as above.
Time elapsed = 5.50596579999547 seconds.
This is just 1/2 part of the project
 
Upvote 0
Do the original sheet formulas work without errors for those 3 columns?
 
Upvote 0
Yes,post a screen pic of those three columns working with the sheet formulas.
 
Upvote 0
I can't see the complete formulas for both of those examples. Can you post both of the formulas that are displayed on the sheet for both of those examples?
 
Upvote 0
5 minutes Please. I just ran the original code to re check and it will take 5 minutes to complete
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
=VLOOKUP(......CHOOSE({...}.....incorporating Sheet Name Reference
2
Replies
10
Views
285
RapchikM
R
M
  • Question
Running unique count of occurrence on table based on date
Replies
0
Views
158
Minx_Minxy
M
SaraWitch
  • Solved
Return values based on multiple cells
Replies
4
Views
233
etaf
etaf
R
  • Question
Multiple Criteria VLOOKUP Formula
2
Replies
15
Views
242
bertible
B
I
  • Question
I have formula in specific cell, i want to copy but dont want to be editable this cell
Replies
0
Views
196
Ibrarbutt
I

Forum statistics

Threads
1,214,911
Messages
6,122,199
Members
449,072
Latest member
DW Draft

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