Help quick
Ok. I'm working with a customer who has two spreadsheets. She's trying to count the number of people based on there Lane and New Step. She's has a section called Lane (which can be numbers from 1-6) and New Step (which can be numbers from 1-19). Now the code is going to have to check the selected cell's for the customer and then match them to the other spreedsheet's correct lane and New step. So, when it's done i cant tell how many customer were a Lane #1 + New step #1 or Lane #1 + New step #2. Does anyone have any idea's on how i would set this up. I though about IF statements, but i would need a for loop and i don't think excel will enjoy my 3 page coding in Excel per Cell. Is there any other way to do this? -- nempo ------------------------------------------------------------------------ nempo's Profile: http://www.excelforum.com/member.php...o&userid=28401 View this thread: http://www.excelforum.com/showthread...hreadid=563474 |
Help quick
I have though of that. However, the problem is is if those two Cell's don't match the other two. Then i need it to continue going down until it finds the right one. My main question i guess is can you use for loops and hold varibles. Because pretty much i need to create something that will Say this spreedsheet is Lane #1 and New Step #1 if customer is this then add one if not go to New Step #2. If get's to Step #19 Then start over and go to Step #1 until you find the correct location to add one. So, once it's all done ill be able to tell how many customer are Lane #4 and Have New Step #2. (There's 156 Customers). -- nempo ------------------------------------------------------------------------ nempo's Profile: http://www.excelforum.com/member.php...o&userid=28401 View this thread: http://www.excelforum.com/showthread...hreadid=563474 |
Help quick
then perhaps a sumproduct formula will help???
=sumproduct((a2:a22="lane #1")*(b2:b22="step $19")) -- Don Guillett SalesAid Software "nempo" wrote in message ... I have though of that. However, the problem is is if those two Cell's don't match the other two. Then i need it to continue going down until it finds the right one. My main question i guess is can you use for loops and hold varibles. Because pretty much i need to create something that will Say this spreedsheet is Lane #1 and New Step #1 if customer is this then add one if not go to New Step #2. If get's to Step #19 Then start over and go to Step #1 until you find the correct location to add one. So, once it's all done ill be able to tell how many customer are Lane #4 and Have New Step #2. (There's 156 Customers). -- nempo ------------------------------------------------------------------------ nempo's Profile: http://www.excelforum.com/member.php...o&userid=28401 View this thread: http://www.excelforum.com/showthread...hreadid=563474 |
All times are GMT +1. The time now is 04:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com