LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel formula needed

I have 2 worksheets in my workbook. The 1st worksheet is a datase of part
numbers and classification codes. It has about 30,000 part numbers and 100 or
more classification codes. The 2nd worksheet is where I enter part numbers to
get the classification code. I'm using a vlookup on sheet 2 to reference part
numbers on sheet 1. When I enter the part number, I also enter cost & weight,
and excel provides the correct classification code.

However, I need to summarize by classification the total cost & weight.

I have a table on sheet 2 that will do that, but I would like excel to
automatically populate the classification code. I was able to do this with
nested IF functions, but it stops at 7 or 8 variables.

In the column of classification codes, row 1 will always be row 1 in the
summary table. But the classification code in row 2 may or may not match row
1. Sometimes row 1 through 15 will be the same and row 16 will be different.
Or Rows 1-4 are the same, row 5 is different than rows 1-4, rows 6-10 are the
same as 5, and row 11 is the same as rows 1-4.

Is there a formula where excel can see a change in value and return that new
value?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Needed Barb Manjarres Excel Worksheet Functions 2 September 14th 08 08:31 AM
Excel Formula needed Coopster8 Excel Discussion (Misc queries) 15 June 5th 07 11:56 PM
Excel formula - help needed! b1888 Excel Worksheet Functions 7 June 7th 06 01:35 PM
Excel - formula help needed GimmeStars Excel Discussion (Misc queries) 1 January 31st 06 05:12 PM
Excel formula help needed SteveFox Excel Worksheet Functions 2 November 23rd 05 12:52 AM


All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"