I have cell values AND empty cells in column A that could be anywhere within column A (column range from A1 to around A1000 - but maximum range can change) but the cell placements and the column range changes often, and so I would just need a formula or vba code for the: "Average of the first 5 populated cells in column A". I had a look as AverageIF, CountA, OFFSET, but just cannot work out how it would be possible. If someone could help I would really appreciate it. Regards,
This question generated 16 answers. To proceed to the answers, click here.
This thread is current as of August 17, 2014.