Home |
Search |
Today's Posts |
|
View Poll Results: How to filter row but delete certain cells from report | |||
Sorry Im lost | 0 | 0% | |
not sure what to do | 1 | 100.00% | |
Voters: 1. You may not vote on this poll |
Reply |
|
LinkBack | Thread Tools | Display Modes |
#1
|
|||
|
|||
Pull records based on name in more than 1 column
I have a pay roll sheet with a 1000 rows. I need a report that pulls base on reps name. That only pulls rows with his name. example row 3 a3 rob b3 rob c3 stan d3 $100 row 4 a4 bill b4 stan c3 stan d4 $50
Pull report and now delete stans & bills names from report for privacy. so i can print and give to rep. But keep all the other data in that row. |
#2
|
|||
|
|||
Quote:
__________________
Asobi Wa Owari Da |
#3
|
|||
|
|||
Unless I am missing something. I can not use a pivot table. I need something that will reference more than one column in a row. Pull any row that has that query in any column. Yet NOT show any names in that row that are not queried. Yet show the names queried. If you can do this with a pivot table please send instructions or a example.
Thanks |
#4
|
|||
|
|||
Quote:
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete records when certain records have duplicate column data | New Users to Excel | |||
How can I pull complete records from a table using an outside valu | Excel Discussion (Misc queries) | |||
How to pull in rows based on Column A data? | Excel Worksheet Functions | |||
What function should I use to pull those records that match | Excel Worksheet Functions | |||
How do I pull a particular set of records from a larger file? | Excel Discussion (Misc queries) |