Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HEy,
I have used Month field and used a list box but my months are not coming in Jan-Dec order. They are coming in A-Z order.
What to do , please help.
Thanks
plese check the spelling of 'july'
filed values names should also match in Match()function then only it will reflect the correct order
E.g:
MonthFiled
Jan
Feb
Mar
April
May
June
July
.
.
.
.
.
Then you have to wrrite like
Match(MonthFiled,'Jan','Feb','Mar'.....)
Exactly same as above its case sensitive
Hey,
Thankx buddy.
it works.
Hey,
BUt can you tell em how the following works??
I did not get the working...
Match(Month,'Jan','Feb','Mar','Apr','May','Jun','July','Aug','Sep','Oct','Nov','Dec',1,2,3,4,5,6,7,8,9,10,11,12)
Hi Nikhil, Please see attached file, you can use the sort option and apply the formula. See the attached file.