Notifications
Clear all
Topic starter
Hi mynda,
Hey there,I want to ask sth.I have repeated series I want to formula it by order like 1st,2nd and so on in column order
Date series order
17 Jun 16110056 1st
18Jun 16110057 1st
19 Jun 16110056 2nd
20 Jun 16110058 1st
21 Jun 16110056 3rd
..........
I use COUNTIF it works but I can't have st,nd,rd,th
Regards
Posted : 21/07/2016 11:15 pm
Hi rathanak
Did you mean Ordinal numbers?
I have attached a file with a sample but the formula is only good up to 50th orders.
Hopefully it will be sufficient.
Sunny Kow
Posted : 22/07/2016 11:03 am
Topic starter
Yes,thanks
Posted : 22/07/2016 11:26 am
