Displaying numbers that are missing

S

Shu of AZ

If I have a column that is 26 rows showing values which are never duplicated
and these values are auto populated from another source data into this
column, is there a way or formula that can tell me which ones are missing. I
know what the possibilities of the values are and there are only 26. Thx in
advance.

The values:
1
1A
1B
2
2A
2B
3
3A
3B
4 thru and including 20
 
H

Harikrishna

Hi,

Is the data source from which you get data into the column is a table in
DataBase, if so are you getting it using dataconnection into your form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying missing values 1
Page numbering with Merged Document and IF statements 1
Display specific values in Dropdown2 based on selection in Dropdow 4
VBA HELP: Display values in Dropdown2 based on Dropdown2 selection 2
Separting negative numbers from letters in cells 1
calculating a pattern 4
Report in Certain Order 5
Totaling Cells with Like Information 3

Top