+ Reply to Thread
Results 1 to 5 of 5

Count the number of cell rows address from top to bottom?

  1. #1
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Count the number of cell rows address from top to bottom?

    Dear All

    Example:
    When C2 input 1 start from row A3 to the end of Other, D2 is Row address 3 , E2 is row address 6
    When C2 input 2 start from row A3 to the end of Other, D2 is Row address 10 , E2 is row address 18
    When C2 input 3 start from row A3 to the end of Other, D2 is Row address 22 , E2 is row address 27

    D2 and E2 formula

    Thanks for any help!
    Attached Files Attached Files
    Last edited by rayhen; 12-11-2020 at 03:52 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,081

    Re: Count the number of cell rows address from top to bottom?

    D2:
    =MATCH(C2,A:A,0)+1

    E2:
    =MATCH("Other",INDEX(A:A,MATCH(C2,A:A,0)):A$1000,0)+D3-ROW($A$2)

    The main question is why do you want this? I suspect that you are going to use them for other calculations that could be accomplished more easily in other ways. So... what happens next?
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Re: Count the number of cell rows address from top to bottom?

    Awesome, that does the trick! Much appreciated! Glenn Kennedy tqvm

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,451

    Re: Count the number of cell rows address from top to bottom?

    D2 cell formula
    HTML Code: 
    E2 cell , array formula
    HTML Code: 

  5. #5
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Re: Count the number of cell rows address from top to bottom?

    Amazing , that does the trick! Much appreciated! @wk9128 tqvm

+ 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. [SOLVED] Top most cell address, if selection is made BOTTOM RIGHT to TOP LEFT
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2017, 04:56 AM
  2. Replies: 1
    Last Post: 09-26-2017, 12:05 PM
  3. [SOLVED] Count number of deliveries to same address on different days
    By tgljl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-28-2016, 08:07 PM
  4. Replies: 4
    Last Post: 03-13-2013, 06:27 AM
  5. [SOLVED] Trying to count from the bottom of a column to a certain number
    By davidhale87 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-04-2013, 04:34 PM
  6. Macro to count rows of different data and put that number in a cell
    By king12yan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2010, 04:31 PM
  7. putting count of the number of rows at the bottom
    By lpdarspe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2006, 07:55 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