Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling entire row when criteria is met.
I am importing information for a database to an Excel worksheet. This
worksheet will have all the info I am working with. Other worksheets will be open for each salespersons number and these worksheets should only have the information for each salesperson. Raw data: Calculated Field Sls# date sell price commission 154 1-1-02 256.50 25.65 156 1-1-02 565.55 56.56 154 1-5-02 1255.05 125.50 I want to have the indvidual worksheets to pull any row of data that has a particular sls# anywhere in the entire column so a sheet could be printed and given to each salesperson. The commission field will be calculated once the information is imported. I tried using an IF function but something is not right with the way I am doing it because it will pull information but have blank spaces where the other sls# are instead of shuffling everything to the top. Any help is much appreciated. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling entire row when criteria is met.
Using another column (eg insert a new column B), you could set up this
formula: =A2&"_"&COUNTIF(A$2:A2,A2) and copy it down - this will give you a sequentially numbered addition to each sls number, like this: 154_1, 156_1, 154_2 etc. Then on another sheet you could make use of VLOOKUP or INDEX/MATCH to bring the data across for each occurrence of a particular sls number (often you would select this through data validation from a pull-down list of available sls numbers). Hope this helps. Pete On Feb 20, 11:30*pm, Mike Koop wrote: I am importing information for a database to an Excel worksheet. *This worksheet will have all the info I am working with. *Other worksheets will be open for each salespersons number and these worksheets should only have the information for each salesperson. Raw data: * * * * * * * * * * * * * * * * *Calculated Field Sls# * * date * * *sell price * * * * * * * commission 154 * * 1-1-02 * * *256.50 * * * * * * * * 25.65 156 * * *1-1-02 * * 565.55 * * * * * * * * 56.56 154 * * 1-5-02 * * *1255.05 * * * * * * * 125.50 I want to have the indvidual worksheets to pull any row of data that has a particular sls# anywhere in the entire column so a sheet could be printed and given to each salesperson. *The commission field will be calculated once the information is imported. *I tried using an IF function but something is not right with the way I am doing it because it will pull information but have blank spaces where the other sls# are instead of shuffling everything to the top. Any help is much appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pulling out Numbers | Excel Discussion (Misc queries) | |||
Pulling info from other spreadsheets based on a set of criteria... | Excel Worksheet Functions | |||
Copy entire row to another sheet based on a criteria | Excel Discussion (Misc queries) | |||
pulling back dates that meet certain criteria | Excel Worksheet Functions | |||
Pulling out every nth value | Excel Worksheet Functions |