I have the following code:
Selection.End(xlDown).Select
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Selection.ListObject.ListRows.Add AlwaysInsert:=True...
Hello All,
I have a large spreadsheet which I am working off (20+K rows)
The following is a formula which I wrote, but when I fill down, it takes a long time to process, so just wondering if there is a way to simplify it.
Any help would be greatly appreciated.
=IF(A1="",""...
Hello Guys,
=IF(AND(CELL("format",A2)="D4",
CELL("format",B2)="D4",
CELL("format",C2)="D4",
CELL("format",D2)="D4"),
"is in DATE Format",)
above formula is to check if all values in A2 to D4 are in date.
my boss challenged me to simplify above formula.
please help me. :)
Hi
I've got this formula which works correctly but is a bit long winded and has a few nested IF statements;
=IF(G7="eombh",INDEX(E2:E22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),IF(G7="eom",INDEX(D2:D22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),(INDEX(C2:C22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)))))
G2=...
Dear Sir
Can you help to simplify below code since it is making excel sheet slow
Sub sbClearCellsOnly()
Range("B6:P6").ClearContents
Range("B10:P10").ClearContents
Range("B14:P14").ClearContents
Range("B18:P18").ClearContents
Range("B22:P22").ClearContents
Range("B26:P26").ClearContents...
Hi I am using below formula in a cell,
F4 =(IF(AND(B4="MONEY TRANSFER",E4="1"),SUMIFS($R$4:$R$8,$P$4:$P$8,"<="&D4,$Q$4:$Q$8,">="&D4),IF(AND(B4="MONEY TRANSFER",E4="11"),SUMIFS($R$4:$R$8,$P$4:$P$8,"<="&D4,$Q$4:$Q$8,">="&D4)+3.5,IF(AND(B4="MONEY...
Hello,
Normally if we have a table such as
<= 5 A
>5 B
>10 C
So if I have a number 6, it will give me B.
We all can use Vlookup for this range thing.
However, if I have an IF formula like below, I can not translate it into a Vlookup one:
=IF(A1>10, (A1-5)/200...
Hello,
So when you pull a cell
say
<tbody>
Result
Stat
Something
=B2*(C3/C4)
</tbody>
So in A 3 i want it to say B3*(C3/C4) but if i were to pull the A2 Cell A3 would end up being =B3*(C4/C5)
How would i go about doing this?
up until now ive been editing a few hundred manualy...
Hello I have tried to simplify my example as much as possible.
I have a Column C containing student names. In Column D is the answer that student chose on a test, and in Column E, I have the correct answers to these questions.
In A2 and A3 I have the students names
In B2 and B3 I would like to...
Hi everyone :),
I have a long macro code and I'm wondering if there is a way to simplify it since it has been created from the macro recorder tool.
Here is the macro code:
https://anotepad.com/note/read/6n32gn
I hope that my post is clear enough.
Thank you.
Hi,
Is there a way to simplify the below Formula?
=IF(INDEX('Data Sheet'!$A$1:$P$73,MATCH(A3,'Data Sheet'!$A$1:$A$73,0),12)=0,"N/A",INDEX('Data Sheet'!$A$1:$P$73,MATCH(A3,'Data Sheet'!$A$1:$A$73,0),12))
Hi, I'm writing some code which is quite repetitive because I have a data range from column A:AO
This is how I wrote my code:
Sub UpdateRefineData()
Worksheets("RefinedData").Select
Dim lrow As Long
lrow = Range("A" & Rows.Count).End(xlUp).Row
Range("A3:A" & lrow).FormulaArray =...
is there a way i can simplify this formula?.. because it will be too long if i have 50 cell to sumifs..
SUMIF(AdditivesCalc!$I:$I,$A3,AdditivesCalc!$K:$K)+
SUMIF(AdditivesCalc!$L:$L,$A3,AdditivesCalc!$N:$N)+
SUMIF(AdditivesCalc!$O:$O,$A3,AdditivesCalc!$Q:$Q)+...
Hello - How can i clean the below formula -
=SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name1"))+SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name2"))
Please help thanks
Hi guys,
Need help in simplifying the below macro.
This macro basically filters the data and copies the filtered data into a new sheet. Then below the filtered data it creates a table which is common in all the sheets created.
I need help where after the table is created i need to copy a...