Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unique numbers
Hi,
I have a collumn with sequenced numbers. (1.2.3.4.5.6.7.8.9) Each time a row is added i count the amount of numbers in the collumn +1. Now, after they have been put in, there are some numbers replaced bij "x" meaning the item does not exists anymore. Now here's the problem: When the "x" replaces a number i have two times the same number in the collumn because the remaining numbers don't automaticly adjust to the lost number. (1.2.3.4.x.6.7.8.9.9) How do i solve this, so the numbers automaticly follow eachother up (1.2.3.4.x.5.6.7.8.9.10...) after the "x" is set. Hope you understand what i mean. Regards, Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count equal numbers as unique numbers | Excel Discussion (Misc queries) | |||
Count unique numbers | Excel Worksheet Functions | |||
how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
unique numbers | Excel Programming | |||
Unique numbers | Excel Programming |