LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 989
Default Interesting problem in excel, producing a list for aspecific date

Hi probably a silly one but i want to make a list of people to be seen on a
specific date, my data is in a table where column one is a date list and
subsequent columns are headed with clients names. Data is recorded against a
date as the number of reviewsthatclient has had so the sheet look something
like this

AB CD EF GH IJ
01/01 1 3 1
01/02 2 4
01/03 4 2
01/04 2 3
01/05 5



It would be great ro be able to type in a date and have a listof those to be
seen and whatnumber review it is produced to print off: to look alittle like
this:

Date Client Review No
01/04 AB 2
01/04 CD 3


Cananyone help?
 
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
Interesting Custom Format Problem mr-tom Excel Discussion (Misc queries) 2 June 16th 09 11:30 AM
Interesting Formula Problem Michael Laferriere Excel Worksheet Functions 6 March 9th 07 12:44 AM
Very interesting problem that should be a snap to figure out! KenRamoska Excel Discussion (Misc queries) 3 March 15th 06 08:38 PM
Interesting Workbook formula problem Bill R Excel Worksheet Functions 3 September 2nd 05 09:04 PM
Interesting TIF file problem TBird Excel Discussion (Misc queries) 5 July 5th 05 10:32 PM


All times are GMT +1. The time now is 03:13 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"