Results 1 to 7 of 7

ROW(A20) vs ROWS($A$1:A20), Which One is Faster?

Threaded View

ceeyee ROW(A20) vs ROWS($A$1:A20),... 10-16-2012, 05:52 PM
tlafferty Re: ROW(A20) vs... 10-16-2012, 05:56 PM
ceeyee Re: ROW(A20) vs... 10-16-2012, 06:00 PM
TMS Re: ROW(A20) vs... 10-16-2012, 06:01 PM
JBeaucaire Re: ROW(A20) vs... 10-16-2012, 06:04 PM
ceeyee Re: ROW(A20) vs... 10-16-2012, 06:16 PM
ceeyee Re: ROW(A20) vs... 10-17-2012, 03:28 AM
  1. #1
    Registered User
    Join Date
    07-31-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    22

    ROW(A20) vs ROWS($A$1:A20), Which One is Faster?

    To get the row number of a cell, is ROW faster or ROWS faster?

    For example
    ROW(A20) vs ROWS($A$1:A20), which one is faster?

    I have hundreds of thousands of formulas containing these (many are inputs for other formulas) and I want to pick the more efficient one.

    (Furthermore, how about simply ROW() without parameter on the row where the target cell is located. Is it the fastest?)


    Thanks.
    Last edited by ceeyee; 10-16-2012 at 06:03 PM.

Thread Information

Users Browsing this Thread

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

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