I have a text file with blocks of data defined by parentheses, something similar to
I need to extract the content between the parentheses. the problem is that sometimes the parentheses are nested.
Looking for a possibility of making this formula shorter, any ideas? Thanks
This formula is producing this
The active cell is A6...
I'm relatively new to more complex nested formulas in Excel (Windows, 2016) and would appreciate some assistance. I’m trying to add a condition to an existing formula that currently performs vlookups based on the text of another cell (H3); the new condition that says if cell H2 contains...
Need to check if both matches are on the same row
which works, but i need it nested within my other formula
Cant work it out, could...
My formula is developing nicely, but i need to add in one last check but cant quite think how to incorporate in, hope someone could help.
I need to be able to make sure that the matches im looking for are on the same row as each other.
My formula looks like this so far...
Hi All bit of a complicated one to explain, so bare with me.
There are two workbook lets call them Book1 and Book2, i need to find if there are match's(multiple criteria)
Each Book has a tab called Tab1, Book1 has more columns on then Book2, but the columns never change place.
On Book2 i need...
First post, hopefully I've followed the rules. I've had a good search but can't find anything specific to the issue I am having. It's very basic so I'm surprised it isn't working.
I've attached an image that hopefully clearly explains the issue I am having. Basically I'd like to...
Hello, could you please kindly help me with the below, to make it so that it'd only consider values for the calculation if the corresponding value in column 'A' = "XX", and instead of specifying the range, sums up all the matched values in a given column?
Please also note that values start in...
First time posting a thread, long time user/reader of threads. I need help solving a problem that I can't find the answer (or close to the answer) to.
What I want to do:
Given a table of data which includes Part number, quote date, quantity, price and supplier, I want iterate through the...
Trying to write this formula and keep flat lining.
If G2 is a error (always #VALUE ), return blank...otherwise run the below if statement
Can anyone help I am really struggling.
I am trying to write a macro that sums several layers of nested subtotals. The lowest level subtotals (subtotal 2) are already calculated and pulled from another tab. Subtotal 1 needs to ONLY be the sum of the individual Subtotal 2 lines. In my example below, the first subtotal 2 field...
I'm been working on a nested formula, with the other parts working but after a week I've worked out my problem is here and it still gives me #Value . After a full day trying several solutions I'm about to 'scream'...
Could you please help me to fix the below formula in column and its drop down (by increase cell count) till the last row in the VBA Macro
=IF(C2<2,"0-1 Days",IF(C2<3,"1-2 Days",IF(C2<4,"2-3 Days",IF(C2<6,"3-5 Days",">5 Days"))))
at the drop downing Column C has to increase...
Hello, can you please help point me in the right direction on this formula.
Basically it has 3 conditions depending on day count.
If <60 it should return “80%”
If >60 but under 180 it should return 75%
And if over 180 it should return 65%
I am trying this but it wont work...
I am attempting to write a nested if formula that currently looks like this =IF(I15:L15="NA","NA",IF(I15:L15="No","N",IF(I15:L15="Y","Y",""))) and am not getting the expected results. Currently cells I-L all equal NA. I'm sure I did something wrong and am looking for guidance to fix this or even...
Hi. I'm creating a spreadsheet for a music group that pays tutor expenses for travel. For a round trip up to 200 miles the standard payment is £25, for a round trip of between 200 and 400 miles its £50, and anything over a 400 mile round trip pays £100. What I want is to be able to enter the...
I just finished writing a decent TO-DO list that was to be used at the office while working on my home computer.
Unfortunately my office doesn't have working MAXIFS functions with their version of Excel... I've looked up a few alternatives but I don't think an array will work...
Sorry. I know there is a simple solution to this and I’m just blind to it.
Calculating Sliding Scale Percentage
Current Formula in cell A46
This works perfect, however I need this formula to consider the value of A43...
I am learning about nested loops but what I cannot determine is how to take values in a 2 dimensional array and through a nested loop move each row down 1 row and create a blank top row for new info to be inserted.
I will call this sub over in over from my main code I am working on to...