1. D

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

    Simplified IF statement

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

    how to simplify nested if

    this is my formula for IF...
  4. D

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

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

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

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

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

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

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

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

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

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

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

    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: I hope that my post is clear enough. Thank you.
  16. D

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

    Is it possible to simplify

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

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

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

    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

Some videos you may like

This Week's Hot Topics