PDA

View Full Version : Generating a new Batch No as per the Creteria



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

p45cal
01-27-2015, 10:29 AM
This ignores calues in columns A and B altogether:
in C2:
=ROUNDUP((ROW()-1)/100,0)
copy down.
Convert formula results to values with Copy, paste-special, Values.

sethu29
01-28-2015, 11:48 PM
Thanks for the Great help p45cal.