ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need to print table values greater than a certain value (https://www.excelbanter.com/excel-discussion-misc-queries/67490-need-print-table-values-greater-than-certain-value.html)

BDP

Need to print table values greater than a certain value
 
I have a table with about 150 rows, each row for a single helicopter part
(time in service for the individual part, etc.). When I update the
helicopter total airframe time all the individual parts times update
automatically and each part has a service life that decrements to a point
where overhaul/replacement is required.. I need to find a way to have a
report print at the bottom of the spreadsheet that lists only those parts
with less than a specified number of service hours remaining (say, less than
25 hours remaining).

Any ideas???

Thanks.

Pete

Need to print table values greater than a certain value
 
Use autofilter on the hours_remaining column and select Custom then
enter your criteria (less than 25 in your example).

Hope this helps.

Pete



All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com