| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select data from list without duplicates on a certain criteria
Kindly Help!!!
In Sheet 1 I have the following data Clmn A 1 2 3 4 5 16.10.08 AA BB CC BB AA 17.10.08 CC DD AA AA BB 18.10.08 BB AA CC AA AA In Sheet 2 I have a drop down list of dates. When I choose a certain date I want excel to display the items in that particular date (without duplicates) and the number of times that item is present. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
| Find duplicates in data with multiple criteria | Excel Discussion (Misc queries) | |||
| how do I update a list to overwrite duplicates with new data | Excel Discussion (Misc queries) | |||
| data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
| Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
Threaded Mode
