i have a simple table where column A contains group #s and column B contains
values.
i need to find the average of multiple groups within the table and ignore
rows where the value column is blank. the # of members within each group may
change and i would prefer not to have to sort by group # if that's possible.
thanks in advance for your time.