Hi, I have to sort some data on a spreadsheet with the following column headers;
Location,Pallet No,Description,Product ID,Qty,Price,Product Code,Comments,Date Returned.
Many of the items repeat but in different columns, i.e. same product code/description etc but different date, is there a way to filter these please?
I also need to be able to show on a seperate worksheet three different price %'s depending on the time the stock has been in storage. Some of the stock will also be out of date and i also need to show this on the sheet, is it possible to filter or search dates in some way ?
I also need to display items worth less then 10.00 after these have been calculated.
I'm also not allowed to use any macros,
any ideas or advice would be welcome.
Thanks.
This message was edited by Anx on 2002-04-08 04:16
Location,Pallet No,Description,Product ID,Qty,Price,Product Code,Comments,Date Returned.
Many of the items repeat but in different columns, i.e. same product code/description etc but different date, is there a way to filter these please?
I also need to be able to show on a seperate worksheet three different price %'s depending on the time the stock has been in storage. Some of the stock will also be out of date and i also need to show this on the sheet, is it possible to filter or search dates in some way ?
I also need to display items worth less then 10.00 after these have been calculated.
I'm also not allowed to use any macros,
any ideas or advice would be welcome.
Thanks.
This message was edited by Anx on 2002-04-08 04:16