Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sort a list of telephones # by every 10th, 20th number?
How do I sort a list of telephone numbers, to get another list of every 10th
or 20th number? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sort a list of telephones # by every 10th, 20th number?
In an adjacent column
=if(mod(row(),10)=0,"Keep","Skip") drag fill down the column. select this column and do Data=Filter=Autofilter and select keep in the dropdown -- regards, Tom Ogilvy "t rock" <t wrote in message ... How do I sort a list of telephone numbers, to get another list of every 10th or 20th number? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plot or extract every 10th or 20th pair of values from 33,000 poin | Charts and Charting in Excel | |||
Select every 10th number in a list | Excel Discussion (Misc queries) | |||
Excel's 20th birthday? | Excel Programming | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Need to remove hypens from typed in telephones (not formatted)!! | Excel Worksheet Functions |