hi all i currently have the following data on sheet2
Date Unit Rank Name --- 9 columns all up
01/01/05 xxx xx xxxxx
on sheet 1 i have the following
A1 = Mar
a2 = =COUNTIF(Sheet2!A1:A8,A1)
a4 = =IF(N($K4),INDEX(Sheet2!A$2:A$9,$K4),"") 0ut to j4
My problem is that to get this to work i have to change the dates in sheet2 to text fields ie "mar".
How can put "mar" in a1 and it will check on sheet though all the dates that are formated like 01/03/05 etc
any ideas would be appreciated
cheers
Date Unit Rank Name --- 9 columns all up
01/01/05 xxx xx xxxxx
on sheet 1 i have the following
A1 = Mar
a2 = =COUNTIF(Sheet2!A1:A8,A1)
a4 = =IF(N($K4),INDEX(Sheet2!A$2:A$9,$K4),"") 0ut to j4
My problem is that to get this to work i have to change the dates in sheet2 to text fields ie "mar".
How can put "mar" in a1 and it will check on sheet though all the dates that are formated like 01/03/05 etc
any ideas would be appreciated
cheers