I have a workbook that has a list of account numbers and their attributes. Assume these are the only two columns on the sheet:
A B
12345 Equity
12345 Cash
12345 Cash
55555 Fixed Income
55555 Cash
How might I remove the duplicate values that have Cash in column B, and keeping the other asset types (Equity for 12345 and Fixed Income for 55555)?
No comments:
Post a Comment