Calculating Serial Number where the data cant be sorted

[muralidaran]

Hi,
I have some data set and i have to calculate the serial number but unfortunately the data cant be sorted since the first block of data is fetched from access database and the second block of data is entered manually in the excel workbook.

Any help would be much appreciated, Thanks.

[Richard Buttrey]

Hi,

The following in B22 will work

Please Login or Register  to view this content.

However your ID numbers aren't incremented consistently. The first set of IDs increment by 10 wheras the second set by 1.
Is there some rule to determine what the increment should be?

[muralidaran]

Hi,
Thanks for your feedback, my fault, I feel that I didn't explained it properly, I'm trying to calculate the serial number not the expected Item ID.
Item ID in the first block is fetched from Access table and the Expected Item ID will be entered manually in this work book. Please have a look at the Sl No and that is what i have to calculate either using a formula or VBA in the same order i have input manually.

[muralidaran]

Hi, Could someone help me on this please....

[Richard Buttrey]

In that case mofify the formula I gave you. i.e.

Please Login or Register  to view this content.

[muralidaran]

Sorry, could you please check the latest attached file.

[muralidaran]

Hi, could someone help me on this please.

[Ace_XL]

In Cell B2 try

=RANK(C2,$C$2:$C$23,1)

Copy down

[muralidaran]

Thanks, that worked.