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 the name is spelt incorrectly ie A-300 and B-200
What is need is to extract the Correct name for project beginning with A. The assumption is that the correct name is the name that is most common. So for project beginning with A the count is 2 for MV Vanessa and 1 for MV Vanesa – so I need a formula to give me the name that is most common among projects starting with A. So I type in “A “and the formulae will produce MV Vanessa and I type in B and the formulae will produce MV Anneley
Regards
Bruce
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 the name is spelt incorrectly ie A-300 and B-200
What is need is to extract the Correct name for project beginning with A. The assumption is that the correct name is the name that is most common. So for project beginning with A the count is 2 for MV Vanessa and 1 for MV Vanesa – so I need a formula to give me the name that is most common among projects starting with A. So I type in “A “and the formulae will produce MV Vanessa and I type in B and the formulae will produce MV Anneley
Regards
Bruce