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

Array Formula for returning cell address for first non-blank cell that uses the functions: ADDRESS, MIN, IF, COLUMN, ROW and the not comparative operator and the symbol for blank (double quotes). Formula from Aladin from Mr Excel Message Board.

Category:

Science & Technology

Tags:

• Excel
• Return
• Cell
• Address
• of
• First
• Non-Blank
• ADDRESS
• MIN
• IF
• COLUMN
• ROW
• functions
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[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]

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]

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

: - )

[ExcelIsFun]

I hope the videos are helpful.