Excel question. I have data in column F that corresponds to the data I need from Column N. If there is a 1 in column F I know how to select all cells with a 1 in column F. After that I am lost because I need to select all cells in column N that are in the same row as the one that have a 1 in column F. Once you can help me find out how to select just those cells in column N that correspond to a 1 in column F, I need to take an average and find std for the cells that I need selected in column N. Any help?

Also the data sheet is 10,000 or so rows long so how can I highlight all the cells in a column without ctrl clicking and scrolling?

Thanks