Posts by hightester

Hi all, hope you're doing well.I changed this to be posted here as I realised it may be some formula that can be integrated with the table

I'm working on some final touches for a sheet I'm creating and having some trouble with a table. I can't seem to find answers anywhere.

Basically I have a table (BE3:BK11) that is a rolling return of data entered in columns (M,P,S,V,Y,AB,AE). The data in the table will then feed into a chart with each column of the table having its own line. I understand that I can hit enter in the table and it will auto expand down and create a new table row.

However, all the data in the table will be automated with formulas so I don't want to be touching or looking at it. I want to have it so that as I enter new data, for example, I enter data into cell M12, then the table automatically creates a new row to accommodate the new data, and auto fill down the formula from the previous bottom of the table at BE11 to the new bottom at BE12

I'm not so much interested in the table at all, but rather it's a necessary (I believe) step to creating the chart that can update with the correct data as it's entered

On a side note: some cells that have a few precedents / dependencies lag for a few seconds when filled (such as column M), is there any way to make it more efficient and load faster?

Thanks in advance everyone

Hi all, hope you're doing well.

I'm working on some final touches for a sheet I'm creating and having some trouble with a table. I can't seem to find answers anywhere.

Basically I have a table (BE3:BK11) that is a rolling return of data entered in columns (M,P,S,V,Y,AB,AE). The data in the table will then feed into a chart with each column of the table having its own line. I understand that I can hit enter in the table and it will auto expand down and create a new table row.

However, all the data in the table will be automated with formulas so I don't want to be touching or looking at it. I want to have it so that as I enter new data, for example, I enter data into cell M12, then the table automatically creates a new row to accommodate the new data, and auto fill down the formula from the previous bottom of the table at BE11 to the new bottom at BE12

I'm not so much interested in the table at all, but rather it's a necessary (I believe) step to creating the chart that can update with the correct data as it's entered

On a side note: some cells that have a few precedents / dependencies lag for a few seconds when filled (such as column M), is there any way to make it more efficient and load faster?

Thanks in advance everyone

I can't thank you enough Carim, I'm in you debt. Thankyou

Hi Carim thankyou for your reply. That comes up as #VALUE when I try to input it. Here I have included the worksheet I'm working through filling out. all the numbers on the left of "sheet 4" are random and not important, just being used to help fill out the equations in the right side of "sheet 4".

At the moment I'm working on filling P18 with the topic mentioned above. Once I have that I can modify it slightly to then give me equations for O18-Z18 and O19-Z19.

In essence I'm trying to test how many consecutive positive results I get when "long" (as well as how many consecutive positive results i get on "short" - but as mentioned it should be pretty easy to extrapolate the equation once I have a working one) Exluding those in the "all" columns, which are a lot easier to do as they will not include the E:E criteria

Hi, I'm new to excel and been able to figure out most as I go but this one's stumping me..

I need to calculate max number of consecutive positive integers in H:H that also has "long" written in the corresponding E:E.

This is where I'm at currently, but I know it's not right as it's returning #VALUE, or #N/A when I turn it into an array with CTRL SHIFT ENTER

It needs to continue counting until it reaches an E:E that still says "long" but a negative or even integer in H:H, and skip over any rows where E:E isn't "long"

=MAX(FREQUENCY(IFS(E:E="long",H:H, H:H>0,H:H),IF(H:H<=0,H:H)))