@Peter Bartholomew

@djclements

@Sergei Baklan 

Hi Magicians!

Column B of Sheet 1 in the attached file contains the data exported from an accounting software. The Ledger Account Names are separated by Carriage Return (Alt+Enter) character. The last line is Narration, which is also separated using Carriage Return.

What I am trying to do is to create a single dynamic formula which derives a list of Unique Ledger Account Names used in the entire range. Narration line is to be ignored.

I am using Excel 365.

Regards

Kanwaljit

​@Peter Bartholomew@djclements@Sergei Baklan Hi Magicians!Column B of Sheet 1 in the attached file contains the data exported from an accounting software. The Ledger Account Names are separated by Carriage Return (Alt+Enter) character. The last line is Narration, which is also separated using Carriage Return. What I am trying to do is to create a single dynamic formula which derives a list of Unique Ledger Account Names used in the entire range. Narration line is to be ignored. I am using Excel 365. RegardsKanwaljit  Read More

​