recursive

TextSplitVar is a recursive formula to split a single cell or text array by the delimiter and return the variable chosen. It checks the number of variables and provides the last variable if the user asked for too large a number. It also adds one more delimiter at the end on the first iteration...

I have a model containing some internal code that I want to be able to programmatically remove from the model before saving it as an "external" version. I searched and found code to remove an entire module that works great. However, now the resulting "external" file gets compiler errors when...

Hi folks, I have been using a neat bit of code I found on Mr. Excel to take two columns of information and return an array of the possible, non-recursive combinations. The code is below. Below that is a mini-sheet to help what I am trying to get to. I would like to have only the array with...

Hello there! Currently, I have a Userform with a textfield that is validated once the "Submit" button is clicked. There are two possible outcomes: 1) The textfield value is valid and the form closes. 2) The textfield is not valid, and the user must continue filling or editing the form...

Hi, I have Data table which has data as shown below In this I need to get the "Component" data which are structured under "Item" and after that each component will be considered as "Item" and recursive CTE comes here. Please help me to sort this out. Sample Input: Sample Output in...

This LAMBDA provides a recursive loop to extract subarrays of given set of dimensions, or warns the user if their provided dimension(s) are bigger than their target array; I am returning the list of the subarrays using ARRAYTOTEXT, but this could be substituted with another function to suit the...

Can someone help me find a shorter formula. I would like the corresponding row's first column to appear in successive columns in a second sheet. Each F number (ie F1, F2, etc) refers to a person. the cells to the right of each person refer to a job that they will be doing (ie Team 1, Team 2...

Hi! I had a set of ~50 project folders (format e.g. 12345_Project_Name) which mere migrated to another server, but in the process were moved into different subfolders and in some instances were renamed, so I cant, for example, simply rename hyperlinks from \\drive_a\ to \\drive_b\. I've pulled...

I have a table with Bill of Material information in four columns; Parent PN, Child PN, Quantity, Units of Measure. Given a parent part number as an input I am returning the "exploded" or "indented" bill of material. Essentially that means I am returning all the children of the parent, all the...

Hello , I have a vba code which captures the data every 20 second from a dynamically changing cell value and stores in the sheet along with some calcuations using Application.Ontime In the sheet , on checking the difference with the timestamp, show data has been entered at 20 seconds most of...

Hi there, I already have VBA code that will recursively trawl through a directory. I am currently using this to identify if any columns in any of the worksheets in any of the Excel workbooks within that directory contain email addresses and, if so, those columns are then deleted. Here's the...

I have an organizational chart that has approximately 15000 employees and is about 8 layers deep. I'm trying to associate all employees to their respective "Vice President". So far I've got a recursive vlookup but it seems unstable and messy. I've tried also creating an index table, but...

Hi, I have been creating folders in Outlook using a simple macro that creates folders from the first column of an Excel sheet under the folder currently selected. That macro is based in Outlook. We are at the beginning of a new fiscal year and I would really like to create the whole tree at...

Hi all, I'm looking for a simple code that can obtain the properties of a windows folder. On windows if you right click a folder and go to properties you can obtain the number of files/number of folders etc. in a few seconds. However, if you use the recursive method of looking through each...

I have written an SQL query to bring BOM data into Excel from Sage 200. I am now trying to make the query recursive so that I can have a single listing of all the components used in a build. This will update an existing spreadsheet which brought in all this data from our older system The key...

I usually have difficulty explaining my issues on access but I do need some some assistance/expertise from this glorious forum in order to make my life easier at work, so here it goes: Basically, I started a job a few months ago and there is a spreadsheet (in Excel) with (firstly) 6 columns of...

Dear community, good morning. I am new to this forum and hope you can help me. Here is my problem. Short version: 1. I need VBA to generate all possible combinations following a certain logic 2. Once a new combination is found, this combination needs to be evaluated with a certain function...

HI there I was wondering if someone can help me. I am working on a project that is incredibly hard to test, therefore we decided to come up with a simplified problem to take the first steps in resolving our problems. My problem is that I can't solve this simple problem using maths in excel so...

Hello, I have been searching for a solution to a problem for quite some times now, and I was hoping one of you have a great idea in this forum. I first like to appreciate any help and any reply to my problem. My problem is, I have an excel macro that does multiple thing for a report purpose...

Hello I'm trying to generate a report in PowerPivot which recursively calculates the total number of employees reporting to a Manager. I have a typical Employee table as shown below. If would like to filter by EmpID and the report should show me the count of the Employees reporting to the user...