help in excel - count function i guess

ssaifan

Active Member
Joined
Jul 29, 2003
Messages
355
i have in row 3 - dates from cell c3 to ax
i have in row 5 below those dates .......in each cell 0 or 1..........
1 means i am in ...
0 means i am out.......

so row 5 looks like

0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


what this is sayin to me is that .........i start at date oct 2004 and i am out on nov 05......

i want to be able to get these dates in cell ay and az in row 5......

how do i get that ????

pls help....

ss
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Try these formulas....

in AY5

=INDEX(C3:AX3,MATCH(1,C5:AX5,0))

in AZ5

=LOOKUP(2,1/C5:AX5,C3:AX3)

you may need to format these cells as dates
 

Forum statistics

Threads
1,136,991
Messages
5,679,014
Members
419,799
Latest member
APInfa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top