simplify

Hi, New to vba and using it to make macros. I built a macro based off one I found online. It's designed to delete rows if they have certain criteria, but each criteria is in separate auto filter section. Is there a way to list all of the criteria(TV show names) in one "section" ? Sub...

Hi guys! I have kind of a complex question. It all starts with a very large spreadsheet (let's call it 'raw data'). It has many columns of information (A:GD). Much of this data is pretty useless to me, to be honest. But there are a few pieces of information that I want to extract (if the row...

Good morning Demigods, Can the following IF statement be shortened at all...

this is my formula for IF...

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...

Hi I have this formula that i have managed to get to return the results i need, but it is a it long-winded. Is there a way this could be simplified...

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. :)

Hello All, I am wondering if there are any ideas to simplify/shorten the following formula. It works fine, but it is fairly long...

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))

Hello All, Is there a way to simple this nested IF statement...

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)+...