Search results

Have a look at the second part of this post https://trumpexcel.com/split-multiple-lines/

Z2: =IF(COUNTIF($A$2:$A2,A2)>1,"",COUNTIFS($A$2:$A$14,A2)) copy Z2 down

Hi Referring to Post #14 just above These lines Set rngY = ws.Range("B2:B15" & lr) Set rngX = ws.Range("C2:G15" & lr) Should be Set rngY = ws.Range("B2:B" & lr) Set rngX = ws.Range("C2:G" & lr) and RegOutput = Application.WorksheetFunction.LinEst(rngY...

G'Day All I have found another setting and tweaked that, so not sure if have to log out/in to enable it If it doesn't show up, I dont have God mode access to go further into the setup So maybe a Question for Chandoo

@all I have added a custom field to User Preferences have a look and tell me what I set mine to?

BigJohn This is something I've wanted for ever, and for some reason your post inspired me to tackle it. What I did using step by step below works a treat as shown here ! The Excel file is attached! What did I do I used QGis a GIS Package I setup a new project using a GDA94 Spheroid I...

Excel should easily handle that for 5 orbs The calcs for all that isn't complex

In the original post the data was discrete and it was quite permissible for events to overlap In the original post the locations of the shapes represented times and movements You could loop through the shapes and adjust them, but you'll need some logic to define how far? Then you loose the...

Thankyou VLetm Cross Posting is generally considered poor form, as people don't follow up and close of solutions on all forums. This can cause people to both waste time, and miss great solutions I am sure the OP will not do that here ?

D2: =IF(LEN(C2)=0,"",IF(LEN(C2)=11,"+",IF(LEFT(C2,1)=0,"","0")))&C2 copy down made column D wider

I think your formula in column F is incorrect F2 should be : =SUMPRODUCT(($D$2:D2)*($A$2:A2=A2))/E2 then copy it down G2: can then become: =SUMPRODUCT(($D$2:D2)*($A$2:A2=A2))/E2 copy it down Please check those manually

In A2: =ROUND(Your Number or Formula here, LEN(A1-INT(A1))-1)

Startdate and days are named formula They will need to be defined on the other pc also Table 4 must have the same name Also the usercontrols have custom names, so check those exist

It is really not clear what result you want? Can you expand the description If you just want to do a lookup, on sheet: Form II, type the following anywhere =INDEX(AFC[Component Details],MATCH(G6&L6,AFC[Concatenate],0))

It works ok for me? Make sure you open the file and allow editing It took a few seconds the first time , then was quite fast

Bosco With heart felt resolve, Everyone here at the Chandoo.org Forums wish you the best in your challenges ahead. Tackle them as you will an Excel problem, one formula at a time

All decimals by default are rational As P45cal pointed out, sinmply coun t the number of digits in a decimal and put a 1 in from of that many zero's as the denominator and remove the decimal eg: .5, 1 number after the decimal = 1 zero, add a 1 and remove "." = 0.5 -> 5/10 .15, 2 number after...

I don't believe that you can do that in a Function You can do it within a Sub Have a read of https://support.microsoft.com/en-us/topic/description-of-limitations-of-custom-functions-in-excel-f2f0ce5d-8ea5-6ce7-fddc-79d36192b7a1

Do a google search on VBA Code Formatter There are a number of Excel addin's that can help you do that Here is an online version https://www.automateexcel.com/vba-code-indenter/

Can you please attach a file for us to use

Select the first chart and Copy Select the second chart Now goto the Home tab, and Select Paste, Paste Special Select Format from the new menu Enjoy

Lisa The two row numbers i have highlighted =XLOOKUP([Order '#],'PS-MARKETPLACE JOURNALS'!$V$2:$V$13595, 'PS-MARKETPLACE JOURNALS'!$A$2:$A$13859) should be the same value

Bawaalbro Is it possible for you to attach a sample file with data and worksheets as per your application?

B2: =IFERROR(INDEX($A$2:$A$1000, MATCH(0, INDEX(COUNTIF($B$1:B1, $A$2:$A$1000), 0, 0), 0)), "") copy down

Pasadu Please next time, attach a sample file, It takes time to make a file to test, which we can use on other problems Assuming your data is in A1: in B2: =IFERROR(INDEX($A$2:$A$10, MATCH(0, INDEX(COUNTIF($B$1:B1, $A$2:$A$10), 0, 0), 0)), "") Copy down