LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
 
Posts: 159
Default How to extract a few results (names) from i big list into a small

I want help to make this possible: 60 salesmen have their own sheet with
different results in different columns, one row for each day of the year.
Lets say 10 of them make a sale and/or an appointment per day, but different
people from day to day. Is it possible for me to make a day by day list where
only those with sales appear? Of course I can make a helpfile for a day by
day list with all 60, sort it and make and extraction with those 10 at top
with sales, but if it is an another and easier way I'd like to know.

Jan Ingvoldstad
 
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
Find a group of names in a long list Carl_Monday Excel Discussion (Misc queries) 1 August 9th 06 03:49 PM
want a list of selectable names on my worksheet Excel Worksheet Functions 4 August 7th 06 08:49 PM
Help to extract text when using LIST & AUTOFILTER Stephen Rainey Excel Discussion (Misc queries) 0 July 27th 06 01:45 PM
How- seperate a combined list by filtering out first list of names Briana Excel Worksheet Functions 1 March 21st 06 03:16 PM
how do i set up a list of names on a sheet frm various sheets in e mcvities_69 Excel Discussion (Misc queries) 1 January 27th 06 02:51 AM


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

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

About Us

"It's about Microsoft Excel"