Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
As an alternative if you want to do other comparisons, you might
consider using autofilters. You could filter for dog colour in one column and for eye colour in another and this formula would give you a count of the visible rows: =SUBTOTAL(3,A3:A5000) You could insert a new row at the very top of your spreadsheet and put this formula there, so that it is always visible when you apply the filters. I am assuming that you have a header row (which would become row 2), so that your data begins in row 3. Adjust the range to suit. Choosing other filters would allow you to record other counts. Hope this helps. Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Join three columns containing phone number and format as (000) 000 | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Multiply two columns in Excel or one column by one number | New Users to Excel | |||
concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
Increasing number of columns in spreadsheet | Excel Discussion (Misc queries) |