|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#11
November 6th, 2008, 08:52 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to increment cell reference every 8th row
Yes, that may work...
Now if you have contacts and their company (client is same as company, right?) names on Sheet2 then why not simply copy those two columns over to Sheet1? You can always sort on Comany name... Since contacts would be unique not the company, you should look for company name given a contact...Simple VLOOKUP will do. What am I missing here? btw what does C[38] signify... I believe it refers to 38th column from C1... "Sandy Crowley" wrote: Maybe I should start over: Sheet 1 has unique names of all the Clients in C1 (each Client per Row = 526 Clients) Sheet 2 has a list of all contacts and the companies they work for (Table Array Sheet 2 R2C1:R4476C[38] I would like to return all the contacts that relate to each client. I'll Fill the formula down and over and I need at least 8 rows to allow for 8 different contacts per Client. How would you write that nested formula? -- Thank you, scrowley(AT)littleonline.com 
|
|
#12
November 7th, 2008, 02:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need formula to increment cell reference every 8th row
Thank you, Sheeloo!
I did as you suggested and it worked. Thanks again. -- Thank you, scrowley(AT)littleonline.com "Sheeloo" wrote: Yes, that may work... Now if you have contacts and their company (client is same as company, right?) names on Sheet2 then why not simply copy those two columns over to Sheet1? You can always sort on Comany name... Since contacts would be unique not the company, you should look for company name given a contact...Simple VLOOKUP will do. What am I missing here? btw what does C[38] signify... I believe it refers to 38th column from C1... "Sandy Crowley" wrote: Maybe I should start over: Sheet 1 has unique names of all the Clients in C1 (each Client per Row = 526 Clients) Sheet 2 has a list of all contacts and the companies they work for (Table Array Sheet 2 R2C1:R4476C[38] I would like to return all the contacts that relate to each client. I'll Fill the formula down and over and I need at least 8 rows to allow for 8 different contacts per Client. How would you write that nested formula? -- Thank you, scrowley(AT)littleonline.com
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
