Formula to find non blank cell

[Simmons709]

I have a sheet to which i will be adding columns of data. This means there are presently blank columns before my calculations. I know how to identify the first non blank cell to the left of the formulas. I need to also identify the first non blank cell to it's left.

Eg.

Columns A through H would be as below

12.57 ; 15.00 ; blank ; blank ; blank ; blank ; formula ; formula

I will be filling in values in the blank cells over time. As I do they need to be incorporated in the formulas in the last two columns.

Right now A & B are used in the formulas. In coming entries,this will change to C & B, then D & C and so on...

Any thoughts would be greatly appreciated.

Thanks

[FlameRetired]

Try a dynamic range. For example if your columns to be filled in are A:H and your formula starts in I1 this

Please Login or Register  to view this content.

then fill down for the next rows.

Looks like this:

Row\Col	A	B	C	D	E	F	G	H	I
1	12.57	15.00	4.00						31.57
2	127.45								127.45
3	137.85	11.02	44.17	33.67					226.71
4
5
6

[Simmons709]

Thanks....

I tried it and it gives me a total of the row, just as you have demonstrated.

Unfortunately, that's not exactly what I'm looking for though....


I enter a complete column of numbers each time I execute the spreadsheet

To Identify the first blank cell in a row I use

=INDEX(A9:H9,MATCH(TRUE,INDEX((A9:H9<>0),0),0))

In your row 1 column I, I would get 4.00

I have a formula in column J which needs to use the values found in both columns C and the one immediately before it, B

Next month I will enter a full column of data in D. The calculations in column J will then run with values found in columns C & D

I hope this is clear.... Sounds good in my head when I read it, this doesn't mean it translates well onto a computer screen....lol.

[sourabhg98]

Check attached
Sorry if this is not what you need...

[Simmons709]

Thanks for the help....

I'm gonna give it a run to see if it works for me...

I'll be back....

[Simmons709]

Happy Dance......Happy Dance......

Thank you to FlameRetired for taking time to help and sourabhg98 for the answer!!!!

Plugged in the formula and it IS exactly what I need.....

[FlameRetired]

Glad you found your solution. Thanks for the feedback.