by Kranthi » Fri Jan 22, 2016 12:24 am
Hi Dude,
Thank you for the suggestion. Yes i agree i did not present full information. For your reference i have attached the Excel sheet in which first column contains Dates and third column Lot numbers.
Kindly note below points:
- If i mention any date that can be 20-01-2016 then Lot number should start from there in third column. For e.g, if a date starts with 20-01-2016 then Lot number should be in third column is "Lot-1" and Here we consider 21-01-2016 as holiday then if date is 22-01-2016 then lot number should be "Lot-2". if there is any date in the next cell of the first column after 22-01-2016 then it should reflect next lot number. if suppose date is 25-01-2016 in next cell of first column then lot number should be "Lot-3".
- If suppose date is repeated twice or thrice then then lot number should be same as it is reflected, for suppose for date 22-01-2016 lot number is "Lot-2" and date in next cell is again 22-01-2016 then lot number also should be same i.e., "Lot-2".
- Sometimes there will be already a value in Third column(Lot column) then it should not be changed. It should be as it is. Only blank cells should be filled in third column if a corresponding first column cell has date.
I have attached the excel sheet for your reference which helps you to understand more better.
Thanks,
Karthik
You do not have the required permissions to view the files attached to this post.