solved

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

Hi folks. Here is my scenario I'm trying to sort with using only formulas (older external program will not read .xlsm or .xlsx). I'll spare you the details of my own hackneyed attempt but let's just say I felt I was getting close with INDEX, MATCH, FIND and VLOOKUP but hit a wall. Columns A...

Hi All, Problem/Headache: I am trying to apply some sort of conditional formatting based on a cell value however, I only want the formatting to affect the corresponding cell to left or right not the whole column. Not sure if that even made sense, sorry if it didn't. . Example: In B1 I have a...

Hi All, I have been working on a workbook to manage the cases my office manages. The most important part of this is managing contractual timeframes and this is what the workbook is based around and so most formulas are simply IF workday functions with some edays and network days thrown in for...