Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with Dynamic range in formula
Hello Skip Thanks for the help, when i try it on my sheet i get a value of 1565 , when I am expecting a value of 62, which I get by using static ranges. =SUM(IF((Support!$B$1:$B$1501<=G87)*(Support!$P$1:$P$1501="")+IF(Support!$P$1:$P$1501>G87,Support!$B$1:$B$1501<=G87),1,0))...- hammers1
- Post #3
- Forum: Microsoft: Office
-
Help with Dynamic range in formula
Hello I have defined a dynamic range called opening date =OFFSET(Support!$B$1,0,0,COUNTA(Support!$B:$B),1) I have also defined a static named range called testopening_date =Support!$B1:B1501 I am then using the following function which works...- hammers1
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
count on a date range accross 2 columns
Skip, Great thanks for the help and prompt reply, what service and the fix works perfect. I have tried everything today, I think it was a case of not seeing the wood for the trees.- hammers1
- Post #3
- Forum: Microsoft: Office
-
count on a date range accross 2 columns
I have 2 columns column A when a ticket was opened and column b, when a ticket was closed. what I would like to get is a total of tickets the were open between two date ranges for this example 01/02/2005 to 28/02/2005 They would need to have been opened before 28/01/2005 and not closed between...- hammers1
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Excel CountIf() or SumIf() with multi criteria
Please ignore previous post, sorry wrong page- hammers1
- Post #41
- Forum: Microsoft: Office
-
Excel CountIf() or SumIf() with multi criteria
I have 2 columns column A when a ticket was opened and column b, when a ticket was closed. what I would like to get is a total of tickets the were open between two date ranges for this example 01/02/2005 to 28/02/2005 They would need to have been opened before 28/01/2005 and not closed between...- hammers1
- Post #40
- Forum: Microsoft: Office
-
Awk search output into an array or assign to a variable
Hello CaKiwi Your reply is just what I was looking for. Thanks for you help. One last question if you don't mind. I have tried to do the folowing nawk -v st=if -v ed=fi -f 7.awk xaa (from the command line) but can't get that to work, does the awk syntax behave differently when you use... -
Awk search output into an array or assign to a variable
Hello I have a input file called xaa, i want to extract the lines between if & fi including if & fi from the input file and assign each group of lines that match that search pattern to an array or variable. The idea is so I can search a group of scripts and find all the instances of if & fi...
