Missing Numbers

[Soniya]

Hi All,

How can i get missing numbers in a serial in a filtered
data sheet?

Within the first number to last number which is already a
filtered data (which will exclude hidden rows)

TIA
Soniya

 

[Frank Kabel]

Hi
not quite sure what you're trying to achieve. Can you give an example?

 

[Soniya]

i have in my sheet1 something like

A B c

RecNo Amount Category
1 10 A
1 5 B
2 10 C
5 5 A

For each category there are differnt receipts with same
serial and entries are stored in sheet1

i want check whether tthere is any missing serail for a
specific category within the fist number and last number
for that catogary.

so when i click mu commandbutton1 in userform1 listbox1
should list all missing numers for that category

in the above eg for category A Rec 1 and 5 is isseued
while 2,3,4 is missing

so in listbox1 that numbers should appear

thanks for your kindreply

Soniya