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

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