Putting columns back in alpha order
Hi
Judging by the replies you have had, and the common response you have
given to each one, if the columns are not hidden, are you saying that
all columns are visible, but there is only data in A to G and then again
from AU to say BD
=AVERAGE(A1:BD1) will return the correct result, because Average ignores
cells which have blank values
Equally
=AVERAGE(1:1)
will give you the correct average of all cells that contain numeric data
in row 1.
--
Regards
Roger Govier
"CLytle" wrote in message
...
I have a file where the columns go from A to G then skips to AU so I
can't
average the row. Can I "rename" the columns so there is no break from
G to
AU?
|