Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering using critera
A B C D E F 1 2 TXT 3 Plot 3 4 TXT 5 Plot 0 6 TXT x 7 TXT x 8 9.9.A-0002 9 Plot A 10 TXT 11 TXT 12 9.9.A-0004 Hi, I'd like to filter some rows using some criteria. Once you reach an ID-number in row c with an ID-number, 9.9.A-XXXX (X could be any number) I'd like to make a copy of the row above and the next one and so on until you reach a number or a letter in row c (the cells inbetween are empty as you can see). The row with a number or letter has to be included in the copy. In this case the copy would be 5-7 and 9-11.It would be great if the copied material would be automatically updated if any modifications of the source file were made. I would really appreciate any help I can get. Thanks! -- Kind regards, Nic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if Critea 1 and critera 2 are met | Excel Worksheet Functions | |||
Formula with multiple critera | Excel Discussion (Misc queries) | |||
Average only with specific critera | Excel Discussion (Misc queries) | |||
Count if the the critera is met then half it | Excel Discussion (Misc queries) | |||
How do I sum with two critera? | Excel Discussion (Misc queries) |