Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT: Comparing Ranges, Selecting Values, and blah blah blah
Hi,
Need some urgent help. Here is what I'm trying to do: I have a number of machines at different locations. There is a list o dates which specify the end of life for a machine. When that life end we need to replace the machine or buy a new machine. We can replace i by another machine from our fleet if there is a machine whose revenu is less than 30. So we go through the date list one by one (in the sorted order so tha we attend to the machine which has the earliest end date), find replacement for it (which has revenue less than 30- if it doesnot hav any replacement we say buy a new one). And we can display it any forma on a new sheet. In my excel workbook I have 2 worksheets. In the DATE worksheet I hav 2 columns, one with machine locations and one with end of life dates They are sorted in ascending order of end of life. In REVENU worksheet, I have information about revenue earned by each location fo every year for a period of 15 years. I've been trying to do this for long and need to get it done asap Please help. I can even send you the workbook if you email me a I really appreciate the time you have taken to read this post :) Thank a lot Ker -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT: Comparing Ranges, Selecting Values, and blah blah blah
"desikerl " wrote in message ... Hi, Need some urgent help. Here is what I'm trying to do: I have a number of machines at different locations. There is a list of dates which specify the end of life for a machine. When that life ends we need to replace the machine or buy a new machine. We can replace it by another machine from our fleet if there is a machine whose revenue is less than 30. So we go through the date list one by one (in the sorted order so that we attend to the machine which has the earliest end date), find a replacement for it (which has revenue less than 30- if it doesnot have any replacement we say buy a new one). And we can display it any format on a new sheet. In my excel workbook I have 2 worksheets. In the DATE worksheet I have 2 columns, one with machine locations and one with end of life dates. They are sorted in ascending order of end of life. In REVENUE worksheet, I have information about revenue earned by each location for every year for a period of 15 years. I've been trying to do this for long and need to get it done asap. Please help. I can even send you the workbook if you email me at I really appreciate the time you have taken to read this post :) Thanks a lot Kerl --- Message posted from http://www.ExcelForum.com/ Hi Kerl You were explicit about what you are doing but not why you contacted this group ...;) Best N10 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT: Comparing Ranges, Selecting Values, and blah blah blah
How do you determine the revenue for the machine? Is it the value in the
REVENUE worksheet for the last year the machine was in use? Or is it the value where the year is 2004? If you could structure your REVENUE data (or create a separate table) so that it only contains one row per machine, then you could use a VLOOKUP formula in the DATE worksheet: =vlookup(MachineLocation, RangeWhereRevenueIsHeld, ColumnContainingTheRevenue, FALSE) Check the Help for more info on VLOOKUP. Post back if this is unclear. -- Dianne Butterworth Hi, Need some urgent help. Here is what I'm trying to do: I have a number of machines at different locations. There is a list of dates which specify the end of life for a machine. When that life ends we need to replace the machine or buy a new machine. We can replace it by another machine from our fleet if there is a machine whose revenue is less than 30. So we go through the date list one by one (in the sorted order so that we attend to the machine which has the earliest end date), find a replacement for it (which has revenue less than 30- if it doesnot have any replacement we say buy a new one). And we can display it any format on a new sheet. In my excel workbook I have 2 worksheets. In the DATE worksheet I have 2 columns, one with machine locations and one with end of life dates. They are sorted in ascending order of end of life. In REVENUE worksheet, I have information about revenue earned by each location for every year for a period of 15 years. I've been trying to do this for long and need to get it done asap. Please help. I can even send you the workbook if you email me at I really appreciate the time you have taken to read this post :) Thanks a lot Kerl --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need urgent help selecting correct test!! | Excel Worksheet Functions | |||
=[Book.xls]Sheet1!A1 and not c:\blah\=[Book.xls]Sheet1!A1 | Excel Discussion (Misc queries) | |||
URGENT: Using Named Ranges with Chart Wizard | Excel Worksheet Functions | |||
IF'S Blah | Excel Worksheet Functions | |||
Macro - code for ranges urgent!!! | Excel Programming |