act

Hello! I'm struggling with needing a formula that allows me to: 1) Look at the date range in column B, 2) verify for this cell which would be named July above it, that it looks in B1:B1000 for any date in July, 2) verify in column F that "INT" is within the text 3) if so, total the values in...

I've spent quite some time trying to figure this out, but can't - seeking assistance from those with far better skills than I. I am trying to calculate the number of days between two dates (A2 & B2) excluding: weekends, holidays (by state) as well as for a ticket received before or after 1PM...

Hi Guys! I'm getting frustrated with my indolence in solving the following problem. Hope some smart good people can help me :) I have a spreadsheet in which I add project actual and forecast cost on monthly basis. There is around 500 different projects which, obviously, have different duration...

I am trying to insert an and/or argument into countifs but can't get it to work. I tried SUMPRODUCT(ISNUMBER(MATCH,RANGE,CRITERIA,0))*ISNUMBER(ETC)) Can't figure out how to do it. For example <tbody> Student A GPA SAT ACT Student B 3.0 900 21 Student C 3.4 1200 Student D 3.0 1080 25...

Hi! My problem is the following. In cell L2 is a sentence that can contain 4 different words. The function first need to find the word, then act on it. As exampel: text WW text text text text text XX text text YY text text text text text text ZZ When cell l2 contains WW, cell M2...

I'm looking to have an inserted shape (button) act as a hyperlink to a main excel tab. Ultimately a hyperlink to the first tab. Since the tabs are quite busy, I don't want to cover up, add a row or column to the tab, I'm looking to have a shape act as a button but scroll with the user. I'm...

Hello, I have the following code which i have to protect my workbook and allow filtering. Sub ProtectSheets() Dim wsheet As Worksheet For Each wsheet In ActiveWorkbook.Worksheets If wsheet.NAME <> "TB - EPM" And wsheet.NAME <> "ACT - GLORY" And wsheet.NAME <> "ACT - BARC" And wsheet.NAME <>...

Hi Guys, I am just wondering anyone could help me to build a bar chart graph. The vertical axis is amount and horizontal axis is customers. <tbody> Customer Week1 Week1 Week2 Week2 Act Fcst Act Fcst A 10 5 20 10 B 42 10 20 15 C 30 43 24 18 D 49 34 20 19 </tbody> Is it possible...

Hi Im stuck on how to achieve this so any input would be appreciated. I have imported the data from tables in Word and I need to clean and sort it. Its a fair bit of data (50,000 rows). The imported data is set out as per below: <colgroup><col><col><col><col></colgroup><tbody> CEMETERIES AND...

Hi, I have a table that I have created pivots for and need to now create a chart from the pivot. I am having an issue due to the way my table is formatted, hopefully someone can help. Ok, my original table is laid out in this way. <tbody> jan jan feb feb mar mar apr apr may may jun jun jul...

<colgroup><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody> Sl Site_Name Value Reason 1 A 200 Act Formula in the below 2 B 250 Pas 3 A 300 MISC Site_Name Max_Value Max_VALUE_Reason 4 A 890 Act A 999 Act 5 C 700 MISC B 6 B 450 Other...

Hello, I have a long string of data that is laid out horizontally and I am trying to find a way (without VBA) to relatively easily convert it to be vertically stacked. Below is a small example of what I need to be able to do on a much larger scale. If I set up the horizontal spreadsheet to...

Hello, I'm trying to import from ACT into Excel. The field I want is "contact name". I would like to only import the first name. The field contains two or more names. "jane doe" or in some cases "jane & john doe". Is there a way to eliminate the last name and get "jane" or "jane & john" only?