Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Choosing Data and skipping other
I wish to have Excel choos items from another worksheet according to the
criteria I set (ie: if =1, then choose ... but skip if not = 1 and select the next item = to 1 ...) I can set this up so it replicates the other worksheet - but I end up with a lot of blank lines - I don't want the lines blank - but only have lines with information = to my querry. Thanks, David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent equation from skipping data when referencing import data? | Excel Discussion (Misc queries) | |||
Does Excel support Auto fill on filtered data? | Excel Discussion (Misc queries) | |||
Can I paste data skipping the hidden cells ? | Excel Discussion (Misc queries) | |||
skipping data for a chart | Charts and Charting in Excel | |||
Skipping cells while reorganizing data | Excel Discussion (Misc queries) |