| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how we can find out any missed number in a series?
Please answered as soon as possible.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how we can find out any missed number in a series?
=match(full_list, partial_list, 0)
copy down the list For example: A1:A100 contains the complete list C1:C100 contains the list you want to find missing values in In B1 type: =match(A1, $C$1:$C$100,0) This will put an #N/A next to any number in A that does not exist in B. Does that help? "Excel" wrote: Please answered as soon as possible. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the missing number? | Excel Discussion (Misc queries) | |||
| how to write function to find max deviation from specific number . | Excel Worksheet Functions | |||
| FIND is not "finding" a number in a column which contains the numb | Excel Worksheet Functions | |||
| find smallest number not equal to 0 | Excel Worksheet Functions | |||
| how do I find an average number of specific words in a column | New Users to Excel | |||
Linear Mode
