Hi Jason,
Thanks for that. When I input the Array formula and drag it down from A2-A15 I get a #Num! error from C6 down??
Also
I have a few lists on the same page that I want to tidy individually so again it would be
A121 Fundraiser (Heading)
A122 Race Night B2 €300
A123 Golf Classic B3 €200
A124 Blank
A125 Blank
A126 Blank
A127 Race Night B7 €200 (duplicate)
In Coumn C & D I wanted to tidy them all up to read
C122 Race Night D2 €500
C123 Golf Classic D3 €200
I tried to adapt your formula
With the changes I made highlighted in red but it did not work
Bookmarks