Hi good people,
If I have numbers going down in column A, some are duplicates and some are 0's, I would like a formula that will give this exact same list in another column, but filter out the 0's, shifting everything up to give a list including duplicates. Please can someone help with this?..Thank you all kindly..