Hi all, hoping somebody can help me with this.
I have a big list of organisation names, populating column B. Some of these are companies, some are not.
When they are companies, I have provided a relevant company number.
However, I have some gaps (as in, the name appears twice in my list, but only one line has a company number).
To avoid having to manually trawl the data, I am sure there must be a formula to work out if
A) There is a duplicated name and
B) If there is a corresponding company number already there which should be used
The below example table may help bring it to light?!
- Organisation 1, 5, 7, 8 and 10 are NOT companies, so correctly have no company number present.
- Organisation 2,3,4,6 and 9 ARE companies, so have the company number populated
- Company 6 has a company number (987654) which is present for three of the four entries; therefore is there a formula to check if a number exists for an existing company in the dataset and then populates that return?
<tbody>
</tbody>
I have a big list of organisation names, populating column B. Some of these are companies, some are not.
When they are companies, I have provided a relevant company number.
However, I have some gaps (as in, the name appears twice in my list, but only one line has a company number).
To avoid having to manually trawl the data, I am sure there must be a formula to work out if
A) There is a duplicated name and
B) If there is a corresponding company number already there which should be used
The below example table may help bring it to light?!
- Organisation 1, 5, 7, 8 and 10 are NOT companies, so correctly have no company number present.
- Organisation 2,3,4,6 and 9 ARE companies, so have the company number populated
- Company 6 has a company number (987654) which is present for three of the four entries; therefore is there a formula to check if a number exists for an existing company in the dataset and then populates that return?
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | - | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | ??? | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | - | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>