Hi. I would want to keep the record that has a value greater than $0.00. However, there will be some occurrences where all the entries for same ID and Date are $0.00 in which case I just need to keep one of them. I've omitted several other columns of informational data that I will be keeping but I don't need to include in the decision about which row to keep and which row(s) to condense.
... View more