Results 1 to 4 of 4

find the last item in a range and retrieve the count of rows

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-05-2015
    Location
    Albania
    MS-Off Ver
    2013
    Posts
    215

    find the last item in a range and retrieve the count of rows

    Hello ExcelGurus
    as you can see from the image, as I said in the title i need a formula that gives me back the count of rows of a column that as more full rows.
    In this case is the result is 7 because in this table the columns that as more NOT empty cell is column D

    EDIT
    find the last number in a range and counts how many rows has got that range
    Hope is clear!

    Thank you for your help!

    \1
    Attached Files Attached Files
    Last edited by XLalbania; 02-22-2016 at 11:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to SUM and COUNT rows that have been seperated by an Item.
    By bkanealy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-23-2014, 01:59 PM
  2. [SOLVED] Find top 10 item's count from 2 columns in excel
    By raw_geek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2014, 09:22 AM
  3. Find last date an item was entered and count the days since
    By hlb129 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-14-2014, 08:14 AM
  4. Resetting a count to zero when entering a specified item in a data range
    By Kerr01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2014, 04:48 AM
  5. Overcoming Error when Find item not in excel range
    By trex46 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2011, 02:45 AM
  6. Replies: 4
    Last Post: 09-15-2010, 08:45 PM
  7. IF function to find an item within a range.
    By Steve-B in forum Excel General
    Replies: 4
    Last Post: 03-11-2009, 05:36 AM

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