Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return unique number, skip blanks
All I have is excell and I'm not allowed to download anything.
Column M has a list of numbers including repeats. Coumn EC already displays unique numbers using the formula - I don't remember how I made this work. =IF(COUNTIF($M$5,M5)=1,M1,"") I want to display the unique numbers consecutively in Column ED without blanks. How can I do this? I don't want to delete any cells because I don't want to move information in a section below it. desired result Column M Column EC Column ED 45518 45518 45518 42850 42850 42850 43850 43850 43850 42850 42580 45518 45520 42580 42580 43850 42850 45518 45520 45520 43850 42850 45518 Sorry if the columns don't line up. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Unique Records ... No Blanks | Excel Discussion (Misc queries) | |||
number columns skip blanks | Excel Discussion (Misc queries) | |||
skip blanks | Excel Worksheet Functions | |||
Skip Over Blanks | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |