Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Help with figure this issue

Latest post Wed, Aug 13 2014 10:13 AM by PeterG. 15 replies.
  • Wed, Aug 13 2014 10:13 AM In reply to

    • PeterG
    • Top 10 Contributor
    • Joined on Mon, Feb 25 2008
    • Posts 224
    • Points 3,368

    Jerry

    The point is that there are no rows of data that have 99245 in column A and a non-blank Pmt Remit Carrier Abbrev entry in column B i.e. all the rows of data that have 99245 in column A have blank cells in column B and so the formula
    =COUNTIFS($A$2:$A$24065,$E1,$B$2:$B$24065,"<>")
    evaluates to zero.

    You need to go back to my first reply and consider filling in the blank cells in column A with a formula which returns the value of the cell directly above it. This is not a nice thing to do because column A then contains a mixture of formulas and values - a recipe for a potential disaster. So in the attached workbook Example_3.xlsx, I've introduced a helper column in column E, and adjusted Roger's formulas accordingly.

    Peter

    • Post Points: 5
Page 2 of 2 (16 items) < Previous 1 2 | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.