Excel

This query is : Resolved

ATUL BELEL (Querist)
Follow

15 October 2014 SIR
IS THERE ANY WAY TO GET THE MISSING NUMBER IN A SERIES, WHEREBY IN A SERIES THE NORMAL SERIAL NUMBERS ARE THERE BUT SCATTERED. SO I JUST WANTED TO KNOW IF THERE ANY NUMBER WHICH IS MISSING IN BETWEEN...
SUPPOSE IN A EXCEL SHEET THERE IS A COLUMN WITH NUMBERS BEGINNING FROM 2401 TILL 3000, NOW THE NUMBERS ARE NOT IN A PERFECT ORDER BUT ALMOST ALL NUMBERS PRESENT, HOW TO DETECT THE MISSING NUMBER?
PLEASE SUGGEST ME ANY EXCEL TOOL TO DETECT THIS.....
THANKS IN ADVANCE

@VaibhavJ

@VaibhavJ (Expert)
Follow

15 October 2014 Hi

Suppose data is in col A, then Sort column A in ascending order, in cell b2, put formula =A2-A1 & drag down till end,

If value of any cell in col B is more than 1 then it is missing no.

Thanks

@VaibhavJ

@VaibhavJ (Expert)
Follow

15 October 2014 Check this: http://www.ashishmathur.com/generate-a-list-of-missing-invoice-numbers/

Thanks

Message likes : 1 times

Upgrade to CAclubindia Pro. Subscribe Now!

ATUL BELEL

ATUL BELEL (Querist)
Follow

15 October 2014 THANKS A LOT SIR....

@VaibhavJ

@VaibhavJ (Expert)
Follow

15 October 2014 Thanks for Acknowledgement.