Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT NUMBER OF ROWS
Each account number should be scheduled a various number of times per week.
Column A = Account Number; Column B = Times/wk they SHOULD be scheduled Each row represents a scheduled service, i.e. if they are ACTUALLY scheduled 2x per week, there should be two rows. Driver numbers are also in the other columns as well. How can I quickly identify services that are not scheduled for the appropriate number of services, i.e. the number of rows for each particular account is not equal to Column B? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT NUMBER OF ROWS
=sumproduct(--(A1:A100<B1:B100)
perhaps? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keep It Simple Stupid" wrote in message ... Each account number should be scheduled a various number of times per week. Column A = Account Number; Column B = Times/wk they SHOULD be scheduled Each row represents a scheduled service, i.e. if they are ACTUALLY scheduled 2x per week, there should be two rows. Driver numbers are also in the other columns as well. How can I quickly identify services that are not scheduled for the appropriate number of services, i.e. the number of rows for each particular account is not equal to Column B? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT NUMBER OF ROWS
One way would be to use Format | Conditional Formatting in column B
Assuming you are in row 2, select cell B2 and then start conditional formatting. Instead of "Value Is", choose "Formula Is" and enter this =COUNTIF(A:A,A2)<B2 then choose the format you want when the number of entries in column A that are same as entry on current row (2) are less than the number in column B of the row. You could even set up a second condition the same way like =COUNTIF(A:A,A2)B2 and set up formatting to show you when you're checking on a client TOO often. "Keep It Simple Stupid" wrote: Each account number should be scheduled a various number of times per week. Column A = Account Number; Column B = Times/wk they SHOULD be scheduled Each row represents a scheduled service, i.e. if they are ACTUALLY scheduled 2x per week, there should be two rows. Driver numbers are also in the other columns as well. How can I quickly identify services that are not scheduled for the appropriate number of services, i.e. the number of rows for each particular account is not equal to Column B? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count rows within a cell? | Excel Worksheet Functions | |||
Pivot table row fields limit vs. number of rows in use for Excel 2 | Excel Discussion (Misc queries) | |||
Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
Getting Count field to recognise rows with negative values in Exc. | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |