Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I would like to create a file of data that has quanties used from one time
period. Then, periodically take another file of the same items from another time period and bump it up against the first one. I want to match the items and put the usage quantities side by side. Then calculate a variance of the change in quantities and sort from hi to lo. I know how to do the basics but how to write a macro so that I take the new file and just do the bumping up against automatically. -- NLRHU91 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching items in 2 list to consolidate to one list | Excel Discussion (Misc queries) | |||
Matching a Value with a list | Excel Discussion (Misc queries) | |||
Copy # fm one list to matching id in list 2? | Excel Worksheet Functions | |||
matching value of top 20 in a list! | Excel Worksheet Functions | |||
matching one value in a list of values | Excel Worksheet Functions |