Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 96
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 96
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 96
Default 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
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
Extract a list from master list js Excel Worksheet Functions 4 September 28th 07 06:15 AM
Extract list of units based on error criteria to new list Sheila Excel Worksheet Functions 14 August 9th 07 03:57 AM
Extract list of units based on error criteria to new list Sheila Excel Worksheet Functions 0 August 9th 07 01:50 AM
extract data from a random list & place in another ordered list sean8690 Excel Discussion (Misc queries) 1 January 2nd 07 07:06 PM
Dividing a value list equall among multiple persons bf44qv1 Excel Discussion (Misc queries) 2 March 8th 06 02:28 PM


All times are GMT +1. The time now is 10:25 AM.

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"