Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract list of persons available from an availability list
Using Excel I have prepared a table listing in column A fixture dates of
matches and in row 1 a list of persons and and inserted "y" in appropriate name column their availability for certain fixtures. How can I easily extract a list of persons available on a certain date i.e. where there is a "y" in their name column in a fixture date row |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract list of persons available from an availability list
Why not have the names listed in column a and the in b,c,d etc have the
dates. Once completed with Y all you need to do is use a filter to obtain a list of who is available. Click Yes if this was helpful please. "GeoH" wrote: Using Excel I have prepared a table listing in column A fixture dates of matches and in row 1 a list of persons and and inserted "y" in appropriate name column their availability for certain fixtures. How can I easily extract a list of persons available on a certain date i.e. where there is a "y" in their name column in a fixture date row |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract list of persons available from an availability list
I have just put up a file for you at:-
www.pierrefondes.com It is item number 34 towards the top of my home page prepared in EXCEL 2007. 1. Open the file where you will see I have included some data. 2. Click on the drop down button in cell A 1 and select y (only). Hit OK. 3. On the drop down in cell C 1 click on the date that you wish to look at. I have seen the following results:- a and c are available on Jan 9th. b and d are available on Jan 16th. a and c are available on Jan 23rd. b and d are available on Feb 6th. a and c are available on Feb 13th. Be careful when you are selecting the dates as it is a bit tricky but, if you are careful, I believe that you will see the results you require. If my comments have helped please hit Yes. Thanks! "GeoH" wrote: Using Excel I have prepared a table listing in column A fixture dates of matches and in row 1 a list of persons and and inserted "y" in appropriate name column their availability for certain fixtures. How can I easily extract a list of persons available on a certain date i.e. where there is a "y" in their name column in a fixture date row |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract list of persons available from an availability
To clarify
Names 01/01/2010 08/01/2010 15/01/2010 22/01/2010 29/01/2010 05/02/2010 12/02/2010 a y y y b y y y c y y y y y d y y e y y y Then filter each date as required. Tables do not appear correctly in the reply (sadly I don't have a site like TTT) but it may be better viewed if you view as if making a reply. "Arceedee" wrote: Why not have the names listed in column a and the in b,c,d etc have the dates. Once completed with Y all you need to do is use a filter to obtain a list of who is available. Click Yes if this was helpful please. "GeoH" wrote: Using Excel I have prepared a table listing in column A fixture dates of matches and in row 1 a list of persons and and inserted "y" in appropriate name column their availability for certain fixtures. How can I easily extract a list of persons available on a certain date i.e. where there is a "y" in their name column in a fixture date row |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract list of persons available from an availability list
Here's a small sample file that demonstrates this.
xGeoH.xls 14kb http://cjoint.com/?bjs25I5muc Note that the formulas entered in C15:C19 are array formulas. Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "GeoH" wrote in message ... Using Excel I have prepared a table listing in column A fixture dates of matches and in row 1 a list of persons and and inserted "y" in appropriate name column their availability for certain fixtures. How can I easily extract a list of persons available on a certain date i.e. where there is a "y" in their name column in a fixture date row |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract list of persons available from an availability list
Neat solution, Biff
-- Regards Roger Govier "T. Valko" wrote in message ... Here's a small sample file that demonstrates this. xGeoH.xls 14kb http://cjoint.com/?bjs25I5muc Note that the formulas entered in C15:C19 are array formulas. Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "GeoH" wrote in message ... Using Excel I have prepared a table listing in column A fixture dates of matches and in row 1 a list of persons and and inserted "y" in appropriate name column their availability for certain fixtures. How can I easily extract a list of persons available on a certain date i.e. where there is a "y" in their name column in a fixture date row __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4757 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract list of persons available from an availability list
Thanks, Roger!
-- Biff Microsoft Excel MVP "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Neat solution, Biff -- Regards Roger Govier "T. Valko" wrote in message ... Here's a small sample file that demonstrates this. xGeoH.xls 14kb http://cjoint.com/?bjs25I5muc Note that the formulas entered in C15:C19 are array formulas. Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "GeoH" wrote in message ... Using Excel I have prepared a table listing in column A fixture dates of matches and in row 1 a list of persons and and inserted "y" in appropriate name column their availability for certain fixtures. How can I easily extract a list of persons available on a certain date i.e. where there is a "y" in their name column in a fixture date row __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4757 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract list of persons available from an availability
http://spreadsheets.google.com/ccc?k...zN4Y mc&hl=en
Try this "Arceedee" wrote: Why not have the names listed in column a and the in b,c,d etc have the dates. Once completed with Y all you need to do is use a filter to obtain a list of who is available. Click Yes if this was helpful please. "GeoH" wrote: Using Excel I have prepared a table listing in column A fixture dates of matches and in row 1 a list of persons and and inserted "y" in appropriate name column their availability for certain fixtures. How can I easily extract a list of persons available on a certain date i.e. where there is a "y" in their name column in a fixture date row |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract a list from master list | Excel Worksheet Functions | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
extract data from a random list & place in another ordered list | Excel Discussion (Misc queries) | |||
Dividing a value list equall among multiple persons | Excel Discussion (Misc queries) |