Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy only specific information from one colum to another worksheet
I am looking for a formula that will allow me to copy data from one
spreadsheet into another based on values within my initial worksheet. For example, if I have 5 colums of data listed below and their corresponding data; A B C D E F 3 4 3 5 3 3 I only want to display data that is equal to 3 on another worksheet, so this would appear as; A B C 3 3 3 I am trying to find a formula that will allow me to pull across only these values and exclude the other colums as they do not equal 5. Thanks, Brandon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy specific information from a master sheet? | Excel Worksheet Functions | |||
Copy multiple worksheet into one colum | Excel Discussion (Misc queries) | |||
Copy multiple worksheet into one colum | Excel Discussion (Misc queries) | |||
AUTO-COPY INFORMATION FROM ONE WORKSHEET TO ANOTHER | New Users to Excel | |||
How do I copy information to the ascending by LName worksheet? | Excel Worksheet Functions |