Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi - I'm trying to set up an array formula that will count the number of
entries for each location that has a Time Notified ie: the result should be 2 for WACH, 0 for WIMU and 1 for WMIC. I am stumped - any help would be greatly appreciated! Location Time Called Time Notified TAT WACH 05:00 05:40 0:40 WACH 07:00 07:20 0:20 WIMU 06:00 forumla to return "" or TAT WMIC 06:00 08:20 2:20 -- I.M.Confused |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array Formula | Excel Discussion (Misc queries) | |||
Array Formula | Excel Worksheet Functions | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
array formula help | Excel Worksheet Functions |