Dear Valko,
Yes, you are right, I already tried that. But the result turns out the Greek
Sign shown in the cell of F22.

But I want the Greek Sign show in F17 and the rest of the cell show "-".
Therefore, I revise your formula slightly! So I am thinking how to revise
the formula in order to achieve show the Greek Sign in F17 and the rest of
the cell show "-".

Many thanks.
Wilchong





T. Valko wrote:
Below is the formula I put from the cell of F17 to F26:
=IF(ROWS(F$17:F17)COUNTIF(F$5:F$14,"<-"),"-",INDEX(F$5:F$14,SMALL(IF(F$5:F
$14<"",ROW(F$5:F$14)),ROWS(F$17:F17))-ROW(F$5)+1))

That formula returns "-" in every cell. You have a slight typo in the

SMALL(IF(F$5:F$14<""

Should be:

SMALL(IF(F$5:F$14<"-"

Dear T. Valko,
Thanks for your suggested formula! Your formula is working very perfect.
[quoted text clipped - 64 lines]
Thanks for your advice,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200909/1