Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel "extract" ranges of numbers listed in the A column?
Hi, I have a LOOOONNNG list of 5-digit numbers in a spreadsheet. They are all
listed in the A column. We only need to report the unknown ranges for this numbers, not the actual numbers. How can I do that? Doing this manually after sorting the data is taking us forever. Here's an example, I cut and paste a super-small portion of the sorted data he 41222 41223 41224 41225 41226 41227 41762 41763 41764 41765 41766 41767 41768 41769 41770 41771 41772 41773 41774 41775 41776 41777 42302 42303 42304 42305 42306 42307 42308 42309 42310 42311 42312 42313 42314 42315 42316 42830 42831 42832 42833 42834 42835 42836 42837 42838 42839 42842 42843 42844 42845 42846 42847 42848 And this is what we need: Range 1: 41222-41227 Range 2: 41762-41777 Range 3: 42302-42316 Range 4: 42830-42848 etc... Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
My Column display as "numbers" instead of "alphabets" | Excel Discussion (Misc queries) | |||
Can Excel "extract" ranges of numbers listed in the A column? | Excel Discussion (Misc queries) | |||
Column listed as "Number Stored as Text" - Exported from Access | Excel Programming |