+ Reply to Thread
Results 1 to 3 of 3

Find last occurance of value in column and count entries below

  1. #1
    Registered User
    Join Date
    08-16-2016
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    88

    Find last occurance of value in column and count entries below

    Hi,

    I'm looking help with some VBA which will find the last occurrence of value in a column and count cells below that. I've attached sheet which will hopefully explain things better.

    Using the attached file...

    Column A lists either W, D or L

    I would like to search for each of these values one at time starting from the bottom up (in other words, find the last occurrence) then count how many entries are below that point.

    Any help, advice or ideas would be great :D

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,068

    Re: Find last occurance of value in column and count entries below

    Alternative to VBA in E2:*
    Please Login or Register  to view this content.
    *...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-16-2016
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    88

    Re: Find last occurance of value in column and count entries below

    Wow, what a superstar!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find last occurance in column
    By Len Silva in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-02-2016, 05:24 PM
  2. Find occurance with respect to count
    By puttu in forum Excel General
    Replies: 2
    Last Post: 11-19-2013, 02:01 PM
  3. count occurance of particular name or text in column
    By meetvivek72 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2013, 07:38 AM
  4. Count Occurance in Column
    By Brokovich in forum Excel General
    Replies: 3
    Last Post: 04-18-2007, 01:10 PM
  5. Excell: count occurance of letters in a column
    By Ispencer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. Excell: count occurance of letters in a column
    By Ispencer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. Excell: count occurance of letters in a column
    By Ispencer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-08-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1