banner_ad

Excel

This query is : Resolved 
Profile Image

Profile Image

(Querist)
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
Profile Image

@VaibhavJ

Profile Image

@VaibhavJ (Expert)
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
Profile Image

@VaibhavJ

Profile Image

@VaibhavJ (Expert)
15 October 2014 Check this: https://www.ashishmathur.com/generate-a-list-of-missing-invoice-numbers/

Thanks
Profile Image

ATUL BELEL

Profile Image

ATUL BELEL (Querist)
15 October 2014 THANKS A LOT SIR....
Profile Image

@VaibhavJ

Profile Image

@VaibhavJ (Expert)
15 October 2014 Thanks for Acknowledgement.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
12 May 2026
Accounts Executive

Nafa Group

Mumbai

B.Com

View Details
Company
19 May 2026
Fundraising Expert

MentorsWorld Ventures Private Limited

Ahmedabad

Others

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details