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

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

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

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

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

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

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

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