I am trying to find and list the every unique number in column C, I want to list them in column A of another sheet. each number will appear atleast twice on the parent sheet. on sheet two column b I want to find every instance of the each listed number and get and average of all the corresponding data in columns E,G,I from parent sheet. my big issue is some of those cells have words and not numbers and excel is counting those as 0 toward the average. I want it to ignore cells that that words, or are blank.
Bookmarks