Soldato
- Joined
- 12 Feb 2009
- Posts
- 4,399
- Location
- London
Hi there I'm having trouble trying to find a way to do this.
Basically in excel a supplier provides a list of products with the attribute on each row either in stock or out of stock. Now the software my shop uses needs a number to calculate stock instead of the text in or out of stock.
Is there anyway in excel I could convert all the cells that say in stock to a cell next row over to them saying 2 (which would be avaliable quantity). Then all cells saying out of stock to be in the next column to 0?
I know its not a actual stock quantity but it means atleast one is avaliable.
Thanks.
Basically in excel a supplier provides a list of products with the attribute on each row either in stock or out of stock. Now the software my shop uses needs a number to calculate stock instead of the text in or out of stock.
Is there anyway in excel I could convert all the cells that say in stock to a cell next row over to them saying 2 (which would be avaliable quantity). Then all cells saying out of stock to be in the next column to 0?
I know its not a actual stock quantity but it means atleast one is avaliable.
Thanks.