checking Sequential numbering
I currently have a spreadsheet containing information about the process route
of products that we manufacture. the lay out is as follows: Column A: Part No Column B: Operation sequence Column C: Machine Column D: Stage Vaule These are currenlty sorted by part no, then operation sequence. The stage value column is the way we calculate the added value of the product, 1 being the 1st value & 12 being the last. Each time the porduct goes from 1 stage to the next it gains more value. The problem I have is that some of the stage values have not been populated in ascending order. ie they may go 1,2,5,4,9,7 when it should be 1,2,4,5,7,9, So what I am wanting to do is check that for each part no. in operation sequential order that the stage value goes up and not down. Can this be done easily? The Rook |
checking Sequential numbering
Manually: Apply autofilters, select each Part No from the filter list, and then eyeball the Stage
values. Using functions: Sort the entire list based on Part No. then in Cell E2, use the formula =IF(A2<A1,"",IF(D2<D1,"OUT OF ORDER","")) and copy down to match your list, then filter on column E to see the "OUT OF ORDER" values. HTH, Bernie MS Excel MVP "TheRook" wrote in message ... I currently have a spreadsheet containing information about the process route of products that we manufacture. the lay out is as follows: Column A: Part No Column B: Operation sequence Column C: Machine Column D: Stage Vaule These are currenlty sorted by part no, then operation sequence. The stage value column is the way we calculate the added value of the product, 1 being the 1st value & 12 being the last. Each time the porduct goes from 1 stage to the next it gains more value. The problem I have is that some of the stage values have not been populated in ascending order. ie they may go 1,2,5,4,9,7 when it should be 1,2,4,5,7,9, So what I am wanting to do is check that for each part no. in operation sequential order that the stage value goes up and not down. Can this be done easily? The Rook |
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com