shorten

  1. M

    Shorten Formula

    Please can you help me shorten this formula The desired result is the TOTAL SUM of the values from spreadsheet 'Month (1)" columns (C8:C400)+(F8:F400)+(I8:I400)+(L8:L400)+(08:O400) IF(C8="","",SUMIFS('Month (1)'!C$8:C$400,'Month (1)'!B$8:B$400,C8)) +IF(C8="","",SUMIFS('Month...
  2. M

    Shorten Formula =IF(D8=5,L8,0)+IF(D9=5,L9,0) repeat unto row 209 +IF(D209=5,L209,0)

    I
  3. P

    How to shorten if or formula ?

    Dear Sir and Madam, Need your suggestion on how to shorten this formula ? The data range is from B11 to B21, at the moment I had to manually add in one by one...
  4. M

    UserForm multiple TextBox values need to shorten formula

    Hello, what is the way to shorten this formula: Private Sub CommandButton1_Click() Dim ws As Worksheet Set ws = Worksheets("Settings") Unload Menu With Menu_Names .TextBox1.Value = ws.Range("V2").Value .TextBox5.Value = ws.Range("V3").Value .TextBox9.Value =...
  5. H

    Shorten VBA Code / Better way to write it

    Hi All, Is there a way to shorten the below code... Sub Macro4()' ' Macro4 Macro ' ' Range("B3").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Range("B11").Select ActiveSheet.Paste...
  6. DataBlake

    Shorten nest iferror(vlookup(

    So i have a nested formula that i would like to shorten or to convert to VBA General info: - I have a sheet containing part numbers in column A: sheet name "Unknown" - I have 3 sheets containing information i need each with different part numbers. sheet names: 1,2,3 One of the 3 sheets...
  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. T

    Formula too long for VBA code - ways to shorten it or make it work in VBA?

    Hi, I've got a VBA code that pulls together some phone numbers, and then concatenates them to 1 cell + removes duplicates. It is super ridiculous and long, but I couldn't find any other way to do it. Basically the way it works, is that it will discard values if length < 3 (some will have a 0...
  9. M

    This formula uses more levels of nesting than you can use in the current file format

    Hello folks, I am trying to use the below formula but it's too large, apparently. Can anyone tell me what I need to do to shorten it? Thank you so much...
  10. C

    Help to edit VBA code for Dropdown list for multiple selection?

    Here's my code: If Target.Address = "$F$13" Or Target.Address = "$F$14" Then. Now my problem is I have to make it up to "$F$1000" and it's very frustrating to enter it one by one. Is there away to make the code shorten? Thanks
  11. John Caines

    shorten formula if possible

    Hello All; I have a formula for a cell that will show the number of entries in the mentioned cells. Formula is...
  12. D

    How to shorten this VBA code

    I have more boxes to come and need to know how I can shorten this to one code include all textboxes instead of a new sub for every text box that is added. below is the 177th time I had to write it Private Sub Textbox177_DblClick(ByVal Cancel As MSForms.ReturnBoolean) If...
  13. P

    Shorten formula - summing dates

    How can I shorten the formula: =SUM(DAY(EOMONTH(A156,0)),DAY(EOMONTH(A157,0)),DAY(EOMONTH(A158,0)),DAY(EOMONTH(A159,0)),DAY(EOMONTH(A160,0)),DAY(EOMONTH(A161,0))) I tried doing sumproduct, but I must be doing something wrong Thanks
  14. P

    Automatically Shorten Long Formula?

    Is there an app or website to automatically search a formula and condense it if possible? I have a formula that when pasted into Google docs, takes up 14 pages. The formula runs about 75 times on my spreadsheet, and even though it functions as it should, changing a reference value makes for a...
  15. M

    Shortening a massive IF statement

    Hello Friends, im actually a Wintel Server Admin / DBA who just got thrown a excel spreadsheet to fix, im not the strongest with formalue, i need to shorten the following code because its huge. thanks in advance if someone can do it <3 =IF(ISBLANK([@[Assigned To]]),"Select...
  16. T

    help to shorten formula

    =d4-e4+d5-e5+d6-e6+d7-e7+d8-e8+d9-e9+d10-e10+d11-e11+d12
  17. R

    Equation simplification

    Hi everybody, I asked my intern to solver a problem about trigonometry. However, the equation he developped work, but are incredibly long and complicated for nothing. I was wondering if there's was a way to shorten - simplify a excel equation. Here's is the equation .... ...
  18. S

    Shortening If-Then equations

    Hi, I have excel 2016. I wonder if there's a shorter way to do If-Then, to not repeat an emvedded equation twice, in one cell. If (big-long-thing=-10000, then "", big-long-thing) Want to avoid double length equations in excel, if I can. Thanks!
  19. andrewb90

    Need to shorten my code

    Hello all, I am slowly getting better at VBA, what I need to improve on more is making things shorter instead of just copying the same things over and over again. I was hoping to post my very long code and see if anybody could assist me in shortening it so that I can write more (perhaps...
  20. K

    How can I shorten this VLookup formula?

    =IFERROR(VLOOKUP(A2,DAILYBBPT!A:B,2,0),IFERROR(VLOOKUP(A2,DAILYRSKIPPT!A:B,2,0),IFERROR(VLOOKUP(A2,DAILYWEBPT!A:B,2,0),"NA"),IFERROR(VLOOKUP(A2,WEEKLYRSKIPPT!A:B,2,0),"NA"),IFERROR(VLOOKUP(A2,WEEKLYWEBPT!A:B,2,0),"NA"),IFERROR(VLOOKUP(A2,BBDAILY!A:B,2,0),"NA"),IFERROR(VLOOKUP(A2,DAILYWIOF!A:B,2,0...

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
Back
Top