Excel Guru Help

[BLK306]

Ok so I'm working on an Excel project and I need a little help. I'm looking to see if there is a formula that will look through a growing list and find the last modified row and take that data and stick it in to another row.

If you look in the picture I would like Row 3 to be the row that shows the most current data. The most current data will be that last modified row from rows 5-87. I have found ways to make some of the individual columns give me the last modified information. However, I'm having trouble on a few of them since they contain cells with no data. For example if you look at row 9 it does not have data in every column. The formulas that I have found will then reference the first modified cell above the empty cell. In the case of row 9 if there is a blank cell in the row, I want it left blank in row 3 as well. Hope that all makes sense. If not let me know and I will try to clarify. Any help is greatly appreciated. Thanks.

[HECDOGGIE]

So, is there a Lookup table to pull the latest and greatest info ? Where is ROW 3 Pulling information from ?

** Im not a GURU , however, I use Excel everyday all day! Thats 99.99% of my work.

[Big A]

My first thought would be to assign a value to the blang cells, such as "1" or "0," whichever works in the formula to get the desire result.

[clevelandkid]

Sounds like the LAST function.

http://www.techrepublic.com/blog/mic...-excel-column/

[BLK306]

Sounds like the LAST function.

http://www.techrepublic.com/blog/mic...-excel-column/

I'm currently using a formula very similar to this one now. I may have even got it from the same sight. It works for the most part. Only it wants to read the next cell up from a blank cell. I could assign a value and conditionally format it to color it out so you can't see it but I was hoping to find another work around. That may be what I end up doing though. Thanks for the help everyone.