Thank you Charles, now I have to spend a lot of time learning how this code works. This is VERY helpful
Charles, I was able to download the file, took me about 4 times as I kept getting empty files. This is going to take me a bit of time to read ...
Unfortunately, I can't download the file. All I get is garbage on my screen. Thanks any way.
Phil, Thanks for your response, this more of the response I was looking for, rather than a "yes". The form that I showed was for a contact data...
Not a particularly informative answer. I want it to look like that and I want it to act like that. My question was more about is there a forms b...
Turns out the answer to my problem is very simple and should have been obvious but then obvious isn't always obvious. Here is the solution =TEXTSPL...
In the example that I provided the rows of information are not in a structured table, they are just different colors. As for using different formul...
Here is the file that is an example of what I want to do
Discovered the solution and why the previous formula didn't work. The correct formula, that works is =SUMPRODUCT(--(YEAR(Withdraws[Date])=2023...
Since I posted this question, I actually found a solution that almost satisfies the question. This function works: =GET.CELL(63,INDIRECT("rc, FALSE...