I have a spreadsheet with dates in column A and strips of data for that date in the row off to the right. There are varying empty cells between the dates and the data so I need a function that finds the first cell in the strip of data, goes 6 cells past that cell, and averages the 6 cells of data and outputs that average into a separate cell. Can anyone help me solve this?
Hi -
Can you upload a sample spreadsheet with data representative of your problem so we can come up with some solutions?
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks