intersection

Seeking your help to determine an array formula that will filter the values in the first column of a table (multiple rows and columns) with the values in an array and summing or counting specific values in a column of the remaining unfiltered rows. The data table consists of the following on...

Good Morning, this is my first forum, so please bare with me. I am producing a tracker for some people so that we can track and update any training that we need to complete and know when we need to complete it. What i am looking for is as follows. I a to have a database (I have made already)...

Hi, I have a number of systems that exchange information and I have the number of exchanges between each combination of two sites below in month last year. Based on last years activity, I want to achieve the maximum number of exchanges by enabling only 100 sites. I have 8000 sites so I...

Hello all, I was wondering if there exists a neat effective way of calculating the number of days two date intervals overlaps? Example: Interval 1: 5. jun 2011 - 21. jun 2011 Interval 2: 10. jun 2011 - 15. jun 2011 Interval 3: 1. jan 2011 - 30. sep 2011 Intersection( interval 1, interval 2 )...

I need some help...I've simplified the spreadsheet down to a couple columns, as follows. Essentially, the spreadsheet defines a continuous line in the "X" dimension (imagine if you are plotting this) by giving several points. So, think of a "Zone" as a continuous line, defined by the points...

Hello all, As a starting user of VBA in Excel I have frequently used this forum for solutions to my vba problems (many thanks for that!). This time I couldn't find an answer to my problem, so I decided to register and ask for myself. I wrote a sub that is fired by the Worksheet_SelectionChange...

I have a database with multiple columns named age, sex, occupation etc. I need to make multiple tables from this data on a separate sheet. One example is: Age Category No. of Males in the category No. of Females in the category 0-3 4-5 6-9 10-15 16-21 22-24 Taking the same...

I'm working on what is essentially a timesheet to help a friend calculate expected pay, but I've run into a roadblock in one area and would appreciate some help. I have a date/time when she punches in and another when she punches out. Calculating total time spent on the job is easy, but I also...

Hi guys, I really hope someone out there in VBA land is able to offer me some assistance with this...even if that is to say that I can't do what I want to !! I'm writing a some VBA code that tests to see if two non contiguous ranges overlap. I'm using the Intersect method to test for this...

Hello Quick question: I was wondering if it was possible either via hotkey or some other setting or option so that if I click on a cell the row and column containing that cell are highlighted. I have a lot of information to sift through and I would love if I could click on say A47 and have A...