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
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.