Extracting Values from Database

[sid1986]

Hi,

I am not sure if this question has been posted before.

I have a sheet of data which has revenue earned by date. Now what i want to do is to compare data day wise for example, I would want to compare revenue earned today, which is wednesday with all the previous wednesday's of the year and Rank today against the year.

 

[Scuderia]

OK Sid

Now I have your column refs...

Column G [Revenue To Rank] Formula =IF(F2=TEXT(MAX($A$2:$A$5000),"DDDD"),E2,"")
Column H [Rank] =IF(ISERROR(RANK.EQ(G2,$G$2:$G$5000)),"",RANK.EQ(G2,$G$2:$G$5000))