solved

Having trouble wrapping my head around condensing this. The blue version is working, the black version is working, but the green is what I'm trying to make happen but not sure how to go about it. It's making "test" a value of zero rather than copying q to test. I get why just not the how to...

Hi everyone its been awhile since i have been on here to post a question. so appologise now for this question. How do i mark my post as solved? i can not seam to find it anywhere. Thanks in advance

-Excel 2013 -Windows 7 Professional I would like my scroll button to hide the same rows in specific Worksheets. I'm new to VBA so I used the Record Macro trick, however the constant switching the screen does causes the application to freeze. I wrote the code to the point where it hides the...

Hello, Looking around I couldn't find any way to do it, but maybe i'm not looking at the proper place, is there a way to tag a thread as solved so other members can identify the issue as solved ? Thanks Matthieu.

Hi all! I've been trying to get this one to work for a while now to no avail. I've googled and searched forums, tried all sorts of formulas and just keep running into walls and errors :( I have a workbook with multiple sheets of staff performance figures. Each staff member's sheet is the same...

Hello MrExcel, Your solution is highly helpful for me, bacause I was also suffered same problem. Fortunately, it was solved by button[8] solution. Only one question. What does it mean as for [8]?. I have investigated in the websites. I cannot find information. Kind regards, Runtime error 619 in...

Hello, Long time lurker, first time asker. I have always been able to find old questions to figure out my own questions. But this one has me hitting a wall. I have a strong feeling it it so simple I am just not seeing it. I have all the worksheets in my Workbook with code names set so that...

Hello! I am attempting to compare budgeted vs. actual costs per full-time employee using PowerPivot, and running into some challenges. I want to display the running total in a line chart, and for the line to stop when there is no more data. A demonstration, using total costs (not per FTE) I...

I haven't experienced this little conundrum before. I have pivot tables and slicers to help people identify who is responsible for what. Everything is working perfectly... except the drill down. When I double click to drill down into a new spreadsheet, it instead brings up a window called "Show...

Hi, How to filter on value fields? I have this Pivot table and want to filter out ‘Sum of Amt’ below 100. Is this possible without introduce a new column with SumOfCust in the data table? (It’s a very large table..) Data Table: Pivot Table...

Hi guys, I'm vba beginner and I struggle with sending formula via VBA into a cell.. getting run-time error 1004 ActiveCell.Formula = "=LEFT(TRIM(MID(A19952;SEARCH(""."";A19952)-2;99));SEARCH("" "";TRIM(MID(A19952;SEARCH(""."";A19952)-2;99)))-1)" Actually this Formula works if I put it directly...

Good Afternoon, First of all I want to say I am a long time reader, first time poster on MrExcel. Because of this board, as well as others, I have become quite skilled in matters of Excel and Access (or at least been good at finding what I need at the time). However I have been unable to find...

Hello all, Currently I have a column of cells that contain numbers like this: "1,13,19" "2,14,19,45,50" "1,12,21,31" "14" "11,13,21,30" ... and also a column of ID numbers. I am hoping to convert the individual values to characters so that I can combine it with an ID and perform a countif...

I am trying to make conditional formatting to highlight 7 consecutive non blank cells in a row Lets say the range is J19:AN19

the named range should refer to corresponding row where the formula uses the named range and it should be E:AI so lets say we call the named range XXX if i enter formula on 3rd row counta(XXX,1) the formula should count the range E3:AI3 if i expand the formula on the next row 4 the formula...

I am currently working on a spreadsheet and I need two separate results from countif to show up in one cell for example this is an overtime calculator I want if someone refuses overtime if I put an "r" in the cell it to add 8 hours and if I put an "rr" a Cell I want it to add 16 hours. Another...

Hi guys, I have a function like this Function newor(num, num1, num2, num3) Application.Volatile num1 = Range("Sheet1!B1").Value If (num = num1 Or num = num2 Or num = num3) Then newor = True Else newor = False End If End Function This function works wells when i type =newor(1,2,5,6). It will...

Good Morning - I'm trying to figure out how to have a dynamic list automatically sort without using macros (not allowed in Excel IOS). The setup is this: Cell E11:E50 contains names of tasks or projects that are abbreviated. In column F, if I enter an X next to a task or project, that...

Hello, I am a first time poster to this forum and have found everyone's advice to be invaluable. The code below is working for my purposes for the most part. I am looking to have my team be able to use the sheet it is for and would prefer it save to our shared drive rather than my documents...

I am trying to get a count of dates in column I that are equal to or less than the date in column J for each worker whose name is in a rotating series in column C. SO far, I have =COUNTIFS('April 2016 CARL Assigned'!$C:$C,"'April 2016 CARL Assigned'!$C2",'April 2016 CARL...