i have 5 columns of numbers listed in excell
would like to create a macro that gets the count of numbers in the first column
the remaining columns, i would like to calculate the average of each column
tried to record a macro to do this many times and it didnt work. One of the problems it wouldnt work was because the number of column entries will vary from spreadsheet to spreadsheet. The macro I created kept the column count the same.
If this doesnt explain the problem well enough, i can send a file