Help in Index Match Formula!!

[JawaharPrem]

Hi,

iam working on a dashboard using index , iam getting proper output what i required, but i have 2 Errors.

1. I cant change the date format
2.Percentage not updating properly.

I enclosed sample file please help on this..


Thanks
Jawahar Prem

 

[bosco_yip]

Try..........

1] In Sheet1 D11, formula copy across to K11 and all copy down :

=INDEX(Daywise!D$1:D$600,MATCH($A$2,Daywise!$C$1:$C$600,0)-1+ROWS($1:1))

2] See attached file.

Remark :

If you wanted to revise your formula, in Sheet1 D11 revised formula copy across to K11 and all copy down :

=IFERROR(INDEX(Daywise!D$4:D$561,AGGREGATE(15,6,(ROW(Daywise!$D$4:$D$561)-ROW(Daywise!$D$4)+1)/(Daywise!$C$4:$C$561=$A$2),ROWS(D$11:D11))),"")

Regards
Bosco

 

[JawaharPrem]

Hi sir,

The both formula is working fine thanks for providing new one...


Thanks
Jawahar Prem