I have a challenge where I would like to use a slicer to select a name from a range of names contained in a slicer. Based upon the name that is selected, I would like to have range of cells (D6:G20) return the status of modules assigned to that manager.
No for the challenge. Is...
Brilliant suggestion PCosta.
I have done a Power Query request for files and I can only get to the file names but I can't extract the tables imbedded in the files (.xltx, .xlsx, .xlsm). That is why I was thinking that if I could do a concatenation of the file paths and name of the files, the...
I do see what you mean with "%201". That was a error in the construction of the example and should have been "[Sheet1.xlsx}Table'!$B$1" with the sheet numbers counting up.
I did open your attachment and unfortunately, I see...
Good afternoon Ninja's.
My VBA is not the best and I have been searching the internet for an example that I can make work but I haven't had any luck.
What I am trying to do is link two columns that will be of variable length together. Once combined, this will be the path to a specific file and...
Hui, you are awesome!
For some reason though, Indirect is not working for me. I did a direct copy/paste from the source document into the workbook I am working on and closed the source workbook to be able to verify the correct address. Constructed Indirect/Concatenate so they are identical and...
I am trying to construct a dynamic link based upon the concatenation of variables contained in other cells.
The concatenation would look like the following:
This is where it becomes tricky. How do...
Hello all and thank you in advance.
I am trying to use Power Query to extract information from a folder in a SharePoint site. I have multiple tables in the folder and I know how to merge tables from a local folder but I am receiving an error when I try to do the same thing from SharePoint.
Good afternoon all.
Here is my scenario and any help would be appreciated.
Lets say that in Worksheet 1, a condition is meet with a cell calculated value, is there any way have a text string in a cell in Worksheet 2 auto populated?
Formula for cell B2...
Hello Ninja and thank you in advance for any assistance you may be able to provide in advance.
I was wondering if there was a way to link the displayed equation of a line in a chart to a cell.
Currently the value in the chart is:
Good morning Ninjas.
I am running into a situation where I would like to use the information provided by an excel graph with I ask that the equation of the line in exponential format be shown on the graph.
The equation provided is y=0.9019e^0.0002x
So, how do I use the data that goes into...
Okay. I found the problem but I am no closer to the answer. Here we go.
Cell AM1 is the calculated standard deviation ST.DEVP=0.1014
Cell AM4 is the average of the cell range 1.6248
When I try to calculate +/- 3 deviations, I am using
=AM4-(3*AM1) Which translates to 1.6248-3*0.1014...
Thank you again Narayan.
I have worked through this problem a number of different ways, tried other cells as well and I am finding that I am having similar issues with other cells. Let me ask a few questions and see if it stimulates some thoughts:
Is there a limit to how many calculations...
Thank you again. Unfortunately, this is a simplified equation. Using the helpercell function is the only way that I could have tackled this problem otherwise, the equation would have well over a hundred components in the numerator and denominator each.
Thank you again for sharing your...
Thank you Narayan for the tip but I have a quick question. When you say, "helpercell", are you suggesting that I create a name formula under Name Manager for this function?
If I do that, I will have an issue with the rest of the work sheet because I am trying to "clean up the data" and the...
If I "F9" through the process starting with the False conditions, the equation works.
First of all, thank you in advance for looking at this question because I feel silly posting it because I have done thousands of If statements in excel and this time I have had an error that is bizarre to me.
The following is a copied from the spreadsheet...
That is a beautiful answer! Knowing that now, I will not be using the "+" at the beginnng because I am relatively new but I will be able to see who the veterans are. And thank you for the answer Luke. Felt like I was missing something but I didn't know what it was and searching didn't provide...