Search results

Sub Multiply_Constants() ' Declare Current as a worksheet object variable. Dim WS As Worksheet On Error Resume Next ' Loop through all of the worksheets in the active workbook. For Each WS In Worksheets Dim cc As Range, c As Range Set c =...

RL084 I did a response a few years ago where a guy wanted a conditional colored donut chart Have a look at my response here: https://chandoo.org/forum/threads/hourly-goals-chart.30621/#post-182590 Welcome back @Jon Peltier MVP , It is strange as our first interactions with each other here at...

Consider each item in a row as an "And" ie: All criteria in a Row must be true to match Consider each row as an "Or" ie: Each row allows you to say Crietria in Row 2 or Criteria in Row 3 etc

What is the criteria by which a row is picked?

have a look at this new post by Paul Kelly just yesterday

You should be able to do that using the new Filter() function You'll need Excel 2021 or 365 or via VBA

Your Data - Series 1 only If you look at H4 to H7 and then the corresponding periods 12 months later you will see there is a strong negative trend So going forward 12 months, i'd be expecting a large negative as well I suspect that you don't have enough data or change the period away from 12...

see the attached

That code works quite ok Check that the VBA Sheet is Called Sheet2 as per the yellow below The worksheet in Excel in my example is called Data Check that there is data from A1 down, as it won't look past gaps in the data Also check that Column A isn't full of Spaces Can you post your file?

Luis maybe a screen shot ?

Hi Peter That is an awesome solution No, The FF Post never happened, I have been snowed under with work commitments and you probably notice that I even rarely post here any more. The new Dyanmic stuff is really really interesting. There are many advances that simple things, like Sort, Unique...

Guna Your explanation isn't clear you know your data, pretend we don't Can you be more precise about your requirements

=sum(offset(C100,-"number_of_installments",0) )

C10: =SUM(B9:B10)*$C$6 Copy down

Javs Please attach a sample file

I used a macro and a table of inputs, but it gets the results you want See attached file

I'd suggest copying your file and try anything and everything on the copy Can you share the file here?

Can you tell us more about the problem What is the file type and size? How much RAM does your computer have? What Version of Excel are you using? What causes the error to pop-up? There are techniques you can use to fix this Remove all the styling in the workbook Remove images from the work...

try the following password 1b1b5b5b7b5b5

Gooseman Firstly, Please read the site instructions They tell you to start your own thread Weibull functions are above my paygrade 1. Don't assume that some expensive software is correct 2. Check it with something like Mathmatica, R etc 3. Ask somebody outside the forums as you aren't using a...

E8: =INDEX($H$8:$H$11,MATCH(D8,$G$8:$G$11,0)) Copy down

A quick google search would have shown you this: https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/comment-page-2/

using EX2 as an example in C11 =IF(MOD(COLUMN()-2-MATCH(TRUE,$C9:$AZ9,0),12)=0,MAX($A11:B11)+1,B11) copy across

Vitro Can you please attached a sample file with some data before and after transformation demonstrating what you require.

P45Cal You forgot to add [/Rant] at the end Your summation is unfortunately very true. I got over this a long time ago, when I realised that I get more out of this solving problems in different ways, to help both me as well as the other readers than the OP is probably getting from it...