shorten

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

I

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

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

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

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

Hello All, I am wondering if there are any ideas to simplify/shorten the following formula. It works fine, but it is fairly long...

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

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

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

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

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

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

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

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

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

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

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!

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

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