Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
skipping cells
i have a list of statistics from a callcenter i work for that are all
in a table in excel, and i want to only select ones that apply to a monday, 5th of the month and other specific dates (eg bank holidays) how could i go about doing this or even is this posable? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
skipping cells
Hi
What do you mean by select? If you mean SEE, then you can use filter for the dates you want. If you want something else then you must spell it out...in detail. regards Paul On May 15, 11:38 am, wrote: i have a list of statistics from a callcenter i work for that are all in a table in excel, and i want to only select ones that apply to a monday, 5th of the month and other specific dates (eg bank holidays) how could i go about doing this or even is this posable? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
skipping cells
no i didnt mean see i ment select so that i could find the average
monday |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
skipping cells
Hi
One way Assuming dates are in column A and value you want to average is in column B =SUMPRODUCT(--(DAY($A$2:$A$100=5),$B$2:$B$100)/SUMPRODUCT(--(DAY($A$2:$A$100=5)) -- Regards Roger Govier wrote in message ups.com... i have a list of statistics from a callcenter i work for that are all in a table in excel, and i want to only select ones that apply to a monday, 5th of the month and other specific dates (eg bank holidays) how could i go about doing this or even is this posable? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
Sum and skipping cells | Excel Worksheet Functions | |||
Tab is skipping 10 cells, how do I stop this? | Excel Discussion (Misc queries) | |||
Skipping Cells | Excel Worksheet Functions | |||
skipping cells | Excel Discussion (Misc queries) |