Excel Magic Trick 363: Return Cell Address of First Non-Blank

[ALWAYS10ful]

hi Mike! i can't find some videos you posted for example 360 part 1, and 2 and many others, i'm thinking i don't want to miss a lot of something good, help on findind those missing videos. thank you.

[ExcelIsFun]

Search for and watch this video title:

'excelisfun Search for Excel Videos, Playlists & Download Workbooks'

This video shows how to use the excelisfun channel, including finding any video you are looking for.

[wwwbuckslayercom]

Thanks anyway. Im sure I didn't explain it correctly. Still impressed with your channel. Keep it up.

: - )

[wwwbuckslayercom]

Quick Question.. I use regression analysis to determine if adjustments are warranted for comparable properties, Works great, however it would be nice if the excel would let me know the adjustments needed to flatten out the regression line (ie 0.00). I'm guessing it would be some type of standard deviation equation but I have know idea. do you think that this is possible? Thanks;

[ExcelIsFun]

I dont understand your question. Can you restate it? What are the x and y variables? What part of regression analysis are you doing (what calculations)? I dont know what you mean by adjustments needed to flatten out the regression line (ie 0.00)

[wwwbuckslayercom]

Sorry I did not elaborate. Limited to 500 Letters. Ex. Adjustment for size. X = Price; Y=Size (Sq Ft); The higher the R-squared value of a regression trend line the higher probability that price and size are related, therefore the r-squared value can help to determine if an adjustment for size is warranted. If an adjustment is warranted it would be nice to know what % adjustment would be necessary to show an r squared value of near 0 after the adjustment instead of trail and error. Thanks

[ExcelIsFun]

I do not know how to do that.

[wwwbuckslayercom]

I have been watching your videos for a while and I am very impressed. Thanks for your work. I am a real estate appraiser and statistical analysis is very important in my industry.

[ExcelIsFun]

I hope the videos are helpful.

[TheWaMilo]

Very useful.

The fact that this trick was done in 2003 and not very much knew about it just proves how much a great job u r doing here, to make it available for more and more people.

Best wishes.

[ExcelIsFun]

I am glad that it is useful for you. What particular use do you have for this trick?

This trick was actually in Mr Excel's "Gurus Gone Wild" book, and I went back to the original post and posted some new thoughts and corresponded with the post's originator, Aladin, and came up with Excel Magic Trick 363, 364, 365 variations and then posted the videos at YouTube.

It is very interesting stuff!

[TheWaMilo]

Well, I don't have a specific need for it, but I really like the concept behind it and how it can be tweaked to provide solutions for many problems.

This is very ironic, I have the Guru's book and I've read it (or that what I thought!). It is strange how sometimes (or many times) we completely forget what we read!

I now checked it back in the book but your formula is actually easier to follow and excludes the ="", which is a great addition.

[ExcelIsFun]

Me, too. If I don't use it and practice, practice, practice, I forget it!!