MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by SASA on January 31, 2002 5:56 AM

I have the remaining of the day to acomplish this task so pls help!
I received one sheet with 43000 entries in column B showing reg. num. of companies. Column A shows type of company.
Column C contains reg.num. of companies every time they applied for any reason, and contains 178000 entries.
I would like to show in column D which type of company is related to entries in column C, acording to column A.
I hope you understand.
MAny thanks in advance. This is URGENT :)

Posted by Andy Gee on January 31, 2002 6:03 AM

Bit more info please

Could you send a snipit of a sheet (real data or not) so I can get a handle on what you need. Slightly unclear

Posted by Sasa on January 31, 2002 6:08 AM

Re: Bit more info please

Private 1234567 1234567 Private
Enterprise 7654321 1234567 Private
1234567 Private
7654321 Enterprise
7654321 Enterprise
1234567 Private

I would like to fill in column D with data from column A refering to company in column D.

Posted by JohnG on January 31, 2002 6:09 AM

Is the reg.num in A the same that appears in C?

Posted by Sasa on January 31, 2002 6:21 AM

In A is type of company. I have 178000 entries in column C with reg.num. of companies from column B.