vbaexpresshelp1.xlsm
Im in need of a formula that only includes visible rows so that I can use filters on my sheet to refine an outcome.
attached is sample sheet if anyone can help.
Thanks
vbaexpresshelp1.xlsm
Im in need of a formula that only includes visible rows so that I can use filters on my sheet to refine an outcome.
attached is sample sheet if anyone can help.
Thanks
No data to test this on.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
If you look at the attached pic there is data in the cells that are to be referencedHe's looking at your attached file. There's no data to test this on.
Last edited by plasteredric; 10-16-2017 at 10:49 AM.
I have this formula for cell 'AH6' which works to count the number or instances in the column, i just don't know how to only count the rows where there is a value in the AH column
=SUMPRODUCT(($Q$30:$Q$9999=$Y6)*(SUBTOTAL(103,OFFSET($Q$30,ROW($Q$30:$Q$999 9)-MIN(ROW($Q$30:$Q$9999)),0))))
Not 100% sure what you're after but test this in AH6 copied down and across:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(AH$30,ROW(AH$30:AH$99924)-ROW(AH$30),0)),--($Q$30:$Q$99924=$Y6))
Also test 103 instead of 3.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
While I have no doubt the solution works, I would not regard testing on 3 unique items a real "test". What is the issue in providing a realistic data sample? Personally, I'm not going to spend my time filling in random data for testing results.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'