how the result show in the respective column? the 1st times in appeared in
the worksheet show in column A and 2nd times in column b

Eg
Amt A (1R) B(2R) C
(3R)
1 Movie S$1000 S$1000
2 Movie S$5000 S$5000
3 Drama S$3000 S$3000
4 Drama S$500 S$500
5 Movie S$8000
S$8000
4


"Piglet" wrote:

Need to found out the text eg Movie appeared how many times in a worksheet.
If 1 time = 1R , 2 time = 2R, 3rd times = 3r etc