Search results

Hello Ninjas Just wondering if there is a native way to convert an .xlsx to a ESRI .shp file. I have come across some python scripts on how to do this but trying to avoid the middlemen. Thanks! Sean

I have a solution. I used PowerQuery to perform an extract and used VBA on a button to do a refresh all. Thank you to all that viewed this post.

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

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

One other thing to note. The source file starts with 'http://sharepoint/... Not sure if this makes a difference.

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. A1="AHU RTU4.xlsx" A2="//sharepoint/support/Arizona/2016" The concatenation would look like the following: =concatenate(a2,"[",a1,"]Table'!$B$2") 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. I...

Thanks Somendra!

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? Ex. Formula for cell B2...

Awesome! Thank you KenU

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: y=-1E-09x6+0.0003x5-33.945x4+2E+0610x2+1E+15x-7E+18 The...

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

Got it! It was caught in the middle of a circular reference. Thanks all!

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

Additional information. If I "F9" through the process starting with the False conditions, the equation works. =IF($B8="","",IF(OR(FALSE,FALSE),1.62484510966994,1.61371126062468)) Stepping through =IF($B8="","",1.61371126062468) =1.61371126062468

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

Quick question that I haven't found an answer to. What is the difference between using Index and +index or any function where you use a "+" sign in front of the function name? Thanks!

Thank you Colin Legg!