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 bkrike 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 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
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
-
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...
