Monday, 21 January 2019

Removing Specific Duplicates from an Excel Array

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

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...