Results 1 to 7 of 7

How to count rows based in numerical order based on cell values?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    How to count rows based in numerical order based on cell values?

    Hi everyone

    First thanks again to Fluff13 who provided the formula found in column D, it works well. As i was completing my workbook I found one issue that I tried to fix but get a "False" value.

    The formula provided counts the number of rows depending on the date selected. What the formula should first do is look for any products named special and if their greater than 20, it should count that row first, then count the others with the difference. Column "L" is how the results should be, column "N" has my formula that kinda works...

    =IF(AND(A10="Special",M10>20),IF(ROWS(10:10)<=$G$6,ROWS(10:10),"")
    Attached Files Attached Files
    Last edited by AccountingJ; 02-15-2019 at 09:19 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to index values based on criteria - in numerical order
    By ironfelix717 in forum Excel General
    Replies: 11
    Last Post: 11-23-2017, 10:41 AM
  2. [SOLVED] Creating copies of muliple rows based on numerical value in a cell.
    By Keybler in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2017, 05:53 PM
  3. Creating copies of muliple rows based on numerical value in a cell.
    By Keybler in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2017, 03:39 PM
  4. [SOLVED] Numerical Incident Order based on Department Name
    By Anarchus in forum Excel General
    Replies: 7
    Last Post: 01-24-2017, 12:11 AM
  5. Insert rows based on count and fill rows with adjacent values
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-19-2015, 02:57 PM
  6. Delete unwanted rows and update count of rows based on values
    By boddulus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2015, 08:34 PM
  7. Macro to rearrange cells based on numerical order
    By Mbutler132000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2010, 11:02 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