• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Native .xlsx to .shp

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

    Using Slicer to change a range of cells values

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

    Using Slicer to change a range of cells values

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

    VBA to create a dynamic link from a dynamic range

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

    VBA to create a dynamic link from a dynamic range

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

    VBA to create a dynamic link from a dynamic range

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

    Construct a link to another workbook with Concatenate?

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

    Construct a link to another workbook with Concatenate?

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

    Construct a link to another workbook with Concatenate?

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

    Merging Tables from a SharePoint site using Power Query

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

    Auto populate a cell in another worksheet.

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

    Auto-incorporation of a calculation from a chart

    Awesome! Thank you KenU
  13. S

    Auto-incorporation of a calculation from a chart

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

    How to recreate the equation of the line from an Excel graph.

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

    Problems with an If statement.

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

    Problems with an If statement.

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

    Problems with an If statement.

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

    Problems with an If statement.

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

    Problems with an If statement.

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

    Problems with an If statement.

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

    Problems with an If statement.

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

    +index

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

    +index

    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!
  24. S

    Best free add-ins for excel

    Thank you Colin Legg!
Top