# simplify

1. ### Selective copying based on criteria

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...
2. ### Simplified IF statement

Good morning Demigods, Can the following IF statement be shortened at all...
3. ### how to simplify nested if

this is my formula for IF...
4. ### Simplify Repetitive Code

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...
5. ### Simplify If Formula

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...
6. ### Help simplifying formula (if possible)

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="",""...
7. ### must be easy, trick

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. :)
8. ### Simplify Formula

Hello All, I am wondering if there are any ideas to simplify/shorten the following formula. It works fine, but it is fairly long...
9. ### Help make this formula more elegant

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=...
10. ### Simplify VB Code

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...
11. ### Formula not working

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...
12. ### Vlookup range - Complex

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...
13. ### Pulling a cell with a formula but only changing certain parts

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...
14. ### Looking to count matching columns based on criteria in another column

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...
15. ### Simplify vba code - VACA

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.
16. ### Simplify formula

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))
17. ### Is it possible to simplify

Hello All, Is there a way to simple this nested IF statement...
18. ### Simplify with Autofill Code

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 =...
19. ### sumif / loop

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)+...
20. ### How Can I Simplify the attached Formula -

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

### This Week's Hot Topics ### 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