| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
colating data from a table - for bespoke report
Hi
I have a simple 1000 row table and I am interested in only the data in the columns shown below. Proj Code Name PC01 colin PC01 fred jones the project Code column data can change and a name is shown against ONLY if associated with that proj code. I am producing a report that has a lookup cell to select the name and then automatically it will return all the Proj Codes that name is shown against. I can get it to select the first match but not go down all the rows :) Many thanks for any and all help with this.. Cheers UKMAN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| colating multi rows of data into single rows - no to pivot tables! | Excel Worksheet Functions | |||
| Creating Bespoke Template - how do I bring up a specific data rang | Excel Discussion (Misc queries) | |||
| Help creating a report from a data table | Excel Discussion (Misc queries) | |||
| Report choosing a Pivot table data | Excel Worksheet Functions | |||
| how do I format data into columns using a pivot table report? | Excel Discussion (Misc queries) | |||
Threaded Mode
