Register
Log In
Unanswered
Home
June 25, 2016
Offline
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
See Answer
Dashboards
June 25, 2016
Offline
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
Answers Post
Most Users Ever Online: 57
Currently Online: azri adrin, Mark Lund, Rudi
24 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Joy Berryhill
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
