|For Row 1, try this. It will only work once you have values in at least A1:H1 since it needs 8 values, as you requested. (0 would be considered a value, but a blank cell would not.)|
Change all of the 1's if you need it to work for other Rows.
You may need to play with the arguments for the ADDRESS function to get it work for your specific situation, but the concept should be valid for any range.
If you need help modifying the formula, come on back with specific ranges and where you want the formula to be placed and we'll see what we can do.
Note: Look up the ROW() and COLUMN() functions in Excel Help. That might give you some ideas as to how to replace the ADDRESS arguments with those functions to make it even more flexible.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.