Hi,
I have created a table with real time and percentage data get refreshed
every minute. I need to get the data in column D for that particular minute.

Var.Time Var.Perc. Fix Time Perc. At par. Time
10:30 PM 33.45% 10:30 PM 33.45%
10:31 PM
10:32 PM
10:33 PM
10:34 PM
10:35 PM

I have created a formula i.e. =IF($A$2=C2:C$7,$B$2," "), But the problem
arises when the time changes to 10:31 pm, it shows the percentage at
particular time to 32.66 %, but cell D2 turns blank, which is supposed to be
33.45%.

Var. Time Var. Perc. Fix Time Perc. At particular Time
10:31 PM 32.66% 10:30 PM
10:31 PM 32.66%
10:32 PM
10:33 PM
10:34 PM
10:35 PM
Please help me in fixing the correct formula.

Thanks in advance.



--
sidd