Hopefully this hasn't been asked already but what I'm trying to do is create a vertical text list based on the values in another list but skipping cells where the value =0. Example:
I'm a bit of a novice so I'm not very good with VBA but what I'd like to do is find a function that would basically take the information in column A and omit the zeros and return information like column B is showing. I've tried several functions like VLOOKUP and FILTER and I couldn't make any of them do exactly what I want. Any help would be greatly appreciated.
I'm a bit of a novice so I'm not very good with VBA but what I'd like to do is find a function that would basically take the information in column A and omit the zeros and return information like column B is showing. I've tried several functions like VLOOKUP and FILTER and I couldn't make any of them do exactly what I want. Any help would be greatly appreciated.