VnV Knowledge Buffer

Posted by Team of VnV for internal use of employees of VnV

Saturday, 28 December 2013

Find Last Record

Do you know if you have to find the last record value in a column

a)      Use CountA(column)

a.      It would give the number of items in that column

b)      Use offset Function

a.      Use the Offset refering to row increment of the above value

 

Posted by CA Venugopal Gella
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

By Title

  • Tech Tip (27)
  • Income Tax (12)
  • General (10)
  • Service Tax (10)
  • Thought for the day (5)
  • Corporate Law (3)

Blog Archive

  • ►  2023 (1)
    • ►  April (1)
  • ►  2020 (6)
    • ►  September (1)
    • ►  July (5)
  • ►  2019 (1)
    • ►  February (1)
  • ►  2018 (1)
    • ►  May (1)
  • ►  2017 (3)
    • ►  May (1)
    • ►  March (1)
    • ►  January (1)
  • ►  2016 (13)
    • ►  November (2)
    • ►  October (2)
    • ►  September (4)
    • ►  August (1)
    • ►  July (3)
    • ►  February (1)
  • ►  2015 (13)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (2)
    • ►  August (1)
    • ►  July (3)
    • ►  March (1)
    • ►  January (1)
  • ►  2014 (11)
    • ►  October (3)
    • ►  September (2)
    • ►  August (1)
    • ►  July (3)
    • ►  March (1)
    • ►  February (1)
  • ▼  2013 (75)
    • ▼  December (1)
      • Find Last Record
    • ►  November (1)
    • ►  October (5)
    • ►  September (3)
    • ►  August (4)
    • ►  July (18)
    • ►  June (23)
    • ►  May (19)
    • ►  February (1)
VnV. Simple theme. Powered by Blogger.