Excel, select an array of an entire column except a single dynamic cell

I am having a hard time finding the answer to this question. Essentially, I am using a function I am having a hard time finding the answer to t