HELP!!! URGENT
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
A B C D
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.
