Hi, You can refer to following link by Microsoft - http://support.microsoft.com/kb/324991
Regards, DILIPandey On 7/27/11, XLS S <xlst...@gmail.com> wrote: > Dilip sir, > > i want to learn offset function, please provide the basic tips and example > > On Wed, Jul 27, 2011 at 9:59 AM, Dilip Pandey <dilipan...@gmail.com> wrote: > >> Hi, >> >> You can use following formula in the next column and drag it down till >> you have data. >> >> =OFFSET($A$1,COUNTA(A:A)-ROW(A1),0) >> >> Sample file is also attached. >> >> Regards, >> DILIPandey >> >> On 7/27/11, qcan <comeonove...@gmail.com> wrote: >> > Hi, >> > >> > A little different request here. I am looking for a way to reverse >> > sort rows: >> > >> > Example: >> > >> > ABC123 >> > ABC493 >> > ABC961 >> > >> > Would become sorted in decending order as: >> > >> > ABC961 >> > ABC123 >> > ABC493 >> > >> > Thanks. >> > >> > -- >> > >> ---------------------------------------------------------------------------------- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> > >> > To post to this group, send email to excel-macros@googlegroups.com >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > Like our page on facebook , Just follow below link >> > http://www.facebook.com/discussexcel >> > >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY, mvp >> MBA,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > ......................... > -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel