Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to indicate a missing # in a series
I have an inventory list with inventory tag #'s associated with it. I would
like Excel to indicate when a # in the sequence is missing. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to indicate a missing # in a series
It depends on what you define as "missing", and how you want this indicated.
What I do is use a conditional format like: =a2<a1+1 and choose a highlight color. Regards, Fred "A Sunfire" <A wrote in message ... I have an inventory list with inventory tag #'s associated with it. I would like Excel to indicate when a # in the sequence is missing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying missing numerical values in a series | Excel Discussion (Misc queries) | |||
confirm the missing numbers in a series | Excel Worksheet Functions | |||
Find missing values in a series | Excel Worksheet Functions | |||
Function for missing data in a series? | Excel Worksheet Functions | |||
How to find missing numbers in series | Excel Worksheet Functions |