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,
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,