This is probably just a simple function, but i don't know what it is. I have a column of information that is being pulled from an adjacent column where only 1 cell will have anything in it but 0. I need to pull whatever cell in the columns information to a single cell somewhere else. Is there a function for this? thanks in advance new here...