Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced filter
I have database in excel that works as follows Column A is the part number.
Column B is the description. Column C is the price per unit. Column D is the quantity required for Job number 1. Column E is the total price for each item required in Job number 1. Column F is the quantity required for Job number 2. Column G is the total price for each item required for Job number 2. Etc. Is there anyway to use advace filter to hide all rows that have no entry in the quantity column. Please understand that Job number 1 might have 2 of item xyz but Job number 2 might have none of item xyz but this row would still need to be visible. Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced filter
"Dave" wrote in message
... I have database in excel that works as follows Column A is the part number. Column B is the description. Column C is the price per unit. Column D is the quantity required for Job number 1. Column E is the total price for each item required in Job number 1. Column F is the quantity required for Job number 2. Column G is the total price for each item required for Job number 2. Etc. Is there anyway to use advace filter to hide all rows that have no entry in the quantity column. Please understand that Job number 1 might have 2 of item xyz but Job number 2 might have none of item xyz but this row would still need to be visible. I would suggest that you produce a helper column with the total quantity of the item across jobs 1 to n, and filter on that. -- David Biddulph |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced filter
Thanks David that works great.
Any ideas how I would adjust to to work with a variable amount of Job? ie the worksheet could end at column E (1 job) or go on for 20 jobs? Dave "David Biddulph" wrote in message ... "Dave" wrote in message ... I have database in excel that works as follows Column A is the part number. Column B is the description. Column C is the price per unit. Column D is the quantity required for Job number 1. Column E is the total price for each item required in Job number 1. Column F is the quantity required for Job number 2. Column G is the total price for each item required for Job number 2. Etc. Is there anyway to use advace filter to hide all rows that have no entry in the quantity column. Please understand that Job number 1 might have 2 of item xyz but Job number 2 might have none of item xyz but this row would still need to be visible. I would suggest that you produce a helper column with the total quantity of the item across jobs 1 to n, and filter on that. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using Advanced filter | Excel Discussion (Misc queries) | |||
Hiding advanced filter | Excel Discussion (Misc queries) | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
advanced filter | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |