LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default How to make list of Items displayed in AutoFilter? Any Function?

Hi,

Dear I am beginner in EXCEL,

Can anybody explain me, How to make list of Items displayed in AutoFilter?
Any Function?

Currently I am doing manually by each individual items using autofilter,then
Copy-paste. This consumes lot of time and hundreds of items are there. e.g.

Datasheet

Apple 1
Apple 2
Apple 9
Banana 3
Banana 4
Carrot 5
Doll 1
Doll 7
Doll 5
Doll 6


List - Summary sheet

Apple 12
Banana 7
Carrot 5
Doll 19


Please help. I have tried to know by help but not succeded.

Thanks in advance!
 
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
XL VBA function needed for a list of items Valerie Excel Worksheet Functions 1 February 17th 09 08:49 PM
Need to make a drop down list of 3 items that input a value in ano solarflare New Users to Excel 2 March 14th 08 10:58 PM
How to make the items in Drop Down List appear as workable hyperli dadejesus Excel Worksheet Functions 0 February 8th 08 06:47 PM
Function to count unique items in list XP Excel Worksheet Functions 2 April 10th 06 06:30 PM
need function to sum top ranking items in list QuantumPion Excel Worksheet Functions 13 June 6th 05 10:42 AM


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

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"