Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value match within date range
Hi All
Could anyone help wih this formula calculation i am trying to establish whether a machine that i refurbished (has a 12 month warranty) has failed (been returned to me and logged) during that warranty period, the data i have to work with is the serial number of the equipment plus the date it was refurbished. Therefore i would like to perform a serial number match over the last 12 months per month as all equipment is returned to me for repair. Data i have is: "With costs" worksheet, "Serial no" column and "Date" of the refurb column (among others, but i figure i will only need these two columns for the calculation) The sheet i want to put the data onto has the 12 months of the year Jan - Dec ("Monthly") so that i can see how many failures during Jan how many during Feb etc Hopefully someone can understand my bad explanation :) Many thanks Derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match 2 Conditions then Avg Range | Excel Discussion (Misc queries) | |||
How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
2 column lookup - match to date range | Excel Worksheet Functions | |||
Index-Match from a range | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |