Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifying the every nth document in a column
how to identify the every 50th document in the column, work sheet contains
60,000 columns |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifying the every nth document in a column
Do you mean 60,000 rows?
Are we to assume you have a list of documents, one per row, and that you would like to retun a list of every document in every 50th row? Assuming that is the case, then in any other column, though preferably one next to the column of document references, pop a title into say B1 and then starting in B2, put the following formula and copy down =IF(MOD(ROW(),50)=1,"FLAG","") This will flag the data on the 51st row, the 101st row etc (Assuming you have titles in row 1 and so the 50th doc is on row 51). If you actually want the docs on row 50 / 100 / 150 etc then just change the 1 to a 0 =IF(MOD(ROW(),50)=0,"FLAG","") Now just filter on Column B for the word FLAG Regards Ken............................. "boby" wrote in message ... how to identify the every 50th document in the column, work sheet contains 60,000 columns |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifying the every nth document in a column
=INDEX($A$1:$A$60000,ROW()*50)
if A is the column with the document, then copy it down "boby" wrote: how to identify the every 50th document in the column, work sheet contains 60,000 columns |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying Last Column With Text | Excel Discussion (Misc queries) | |||
Identifying the row and column of a table value | Excel Discussion (Misc queries) | |||
Trouble identifying filtered column | Excel Discussion (Misc queries) | |||
Dame: identifying duplicate numbers within a column | Excel Worksheet Functions | |||
Identifying single column within named range | Excel Discussion (Misc queries) |