1. M

    Simplified IF statement

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

    how to simplify nested if

    this is my formula for IF...
  3. 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...
  4. 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...
  5. 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="",""...
  6. 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. :)
  7. 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...
  8. 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=...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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.
  15. 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))
  16. G

    Is it possible to simplify

    Hello All, Is there a way to simple this nested IF statement...
  17. 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 =...
  18. 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)+...
  19. 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
  20. D

    Need help in simplifying my macro

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

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...