Excel Formula & Data Cleanup
Budget: $15 – $25 USD
Summary
have a excel project need to generate a formula with following: Base of Story: I m Handle a client who is steel coil distuributor and processor The steel coil will be converted to sheet and some each product is identified with seperate Batch Numbers. The Batch number will be changed in followin circumstance.
1. When the Coil is convertied to cut sheets
2. When the Coil is Shifted from GOdown to Godown
3. Sheet is Shifted from Godown to Godown
From initial Purhase coil to final sheet there ill be multiple Batch numbers need to find the initial Batch number from the for Each Sheet and every conversion is identified by voucher number
have a excel project need to generate a formula with following: Base of Story: I m Handle a client who is steel coil distuributor and processor The steel coil will be converted to sheet and some each product is identified with seperate Batch Numbers. The Batch number will be changed in followin circumstance.
1. When the Coil is convertied to cut sheets
2. When the Coil is Shifted from GOdown to Godown
3. Sheet is Shifted from Godown to Godown
From initial Purhase coil to final sheet there ill be multiple Batch numbers need to find the initial Batch number from the for Each Sheet and every conversion is identified by voucher number