How to extract list of persons available from an availability list

[GeoH]

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

 

[Arceedee]

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.

 

[trip_to_tokyo]

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!

 

[Arceedee]

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.

 

[T. Valko]

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.

 

[Roger Govier]

Neat solution, Biff

--
Regards
Roger Govier

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






__________ 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

 

[T. Valko]

Thanks, Roger!

--
Biff
Microsoft Excel MVP

Neat solution, Biff

--
Regards
Roger Govier



__________ Information from ESET Smart Security, version of virus
signature database 4757 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Arceedee]

http://spreadsheets.google.com/ccc?key=0AjhPChIe1hRCdDY2bkRpdDRtWnF3UlI3WFA4YzN4Ymc&hl=en

Try this