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