sethu29
01-27-2015, 06:00 AM
Hi Support,
We have a random Application no's in Column A in the attached sheet and also column B have Unique Serial Number(USN) which is not in sequential order.
Now we would like to generate a batch no for each 100 no's in Column C.
Ex(Batch No "1" for the first 100 Unique Serial No's and Batch No "2" for the second 100 Unique Serial No's and so on)
Please make note that Unique serial no's are not in the ascending order.
May someone help us on this case. Highly Appreciating in advance
We have a random Application no's in Column A in the attached sheet and also column B have Unique Serial Number(USN) which is not in sequential order.
Now we would like to generate a batch no for each 100 no's in Column C.
Ex(Batch No "1" for the first 100 Unique Serial No's and Batch No "2" for the second 100 Unique Serial No's and so on)
Please make note that Unique serial no's are not in the ascending order.
May someone help us on this case. Highly Appreciating in advance