Recent content by BruceW

HI Jeff Heres my attempt - without looking at the above =MID(A3,MATCH(1,((CODE(MID(A3,ROW(INDIRECT("2:"&LEN(A3))),1)))>64)*(CODE(MID(A3,ROW(INDIRECT("1:"&LEN(A3)-1)),1))<58),0)+1,LEN(A3)) 131 char I see it has already been dealt with but stoked I came anywhere close to your original...

Hui Well my suggestion didnt work - with 46000 lines of data excel just hung.

Hui Thanks for the reply. The data is from an external database that gets refreshed hourly. So above wont work. I dont necessarily want to correct the name just need to find the most common occurence. I am using Excel 2003. The countifa and countif dont seem to work as they need criteria. I...

Hi all I have a table as follows Project No Name Task A-100 MV Vanessa Task 1 A-200 MV Vanessa Task 2 A-300 MV Vanesa Task 3 B-100 MV Anneley Task 1 B-200 MV Annerley Task 2 B-300 MV Anneley Task 3 B-400 MV Anneley Task 4 B-500 MV Anneley Task 5 As can be seen sometime...

Hi All I'm Bruce, an Accountant, from Durban ,South Africa. Found this site about a month ago and have learnt so much already. Excel school in very informative as well.