LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJB AJB is offline
external usenet poster
 
Posts: 40
Default show a filter of a range

I have a pricing grid which has labels in column A, quantities in column B,
rates in column C, and total price in column D. There are about 60 rows.

Typically, the finished result only uses ~20 of the items. What is the best
way to show a summary in column G that list only the labels which have been
assigned quantities?

thanks in advance,

Andy


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show a filter of a range AJB Excel Discussion (Misc queries) 1 February 7th 09 10:39 AM
Show Data In Range not appearing in Separate Range Brent E Excel Discussion (Misc queries) 3 April 30th 07 09:32 PM
When in filter mode status bar doesn't show range of cells filted Marie McNamee Excel Worksheet Functions 1 November 20th 06 03:18 PM
FILTER: show/don't show selection with tickboxes ancharwashere Excel Discussion (Misc queries) 2 October 11th 05 09:20 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM


All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"