nested

I am trying to add classifications to my leagues based on year. Some leagues change classifications on a year-to-year basis. I am trying to use XLOOKUP to look up the year and the league, and select the proper classification from a range. The problem arises when a league changes...

Hi, We are trying to build a basic dashboard that is automated having to only paste in a raw data sheet that is cleaned and then uses the data from the 'clean data' sheet. At the minute we are trying to work out MODE of a text string within a range per week client activity is live. The...

What I am trying to accomplish is increment my CONCATENATE formula by one. My issue however is that this is already located within a counter that applies the formula to every other row. I have tried to include detailed comments in my VBA code to follow what everything does. In short, in the...

Dear Mr Excel I would be so grateful for some help with this. I have 4 Sheets that contain data that i am trying to write a code for. MessagesSheet (Which is named "replies" followed by "date" and "time"): This contains text messages received. The data is organised as follows: Each row...

HI All I would be grateful for the advice on the following: I have two "For Next" Statements nested inside each other. The outer loop takes a phone number from a spreadsheet, then looks the number up on a messaging service. The inner loop identifies the message conversations and drops each...

Hey guys I seem to be stumped! I have a spreadsheet and I am trying to get a value in an individual cell based on two rows of data on two different tabs and then multiply by another row of data :oops: Sheet 1 has column A, 63 lines with numbers column B, 63 lines with numbers Sheet 2 has...

I got a task in which i have 2 Files One is a Master File containing the names of the clients and the EMI amount with Payment 1 detail And there is Another file containing Daily Collection with payment 2 Detail In Master File there are two column Pay 1 Pay 2(Values Coming From Another File...

Hi all, I would like to: Check if row value in Column AM = "APAC" Check if row value in Column AR = "APAC" Check if row value in Column AJ has partial string match containing "OFIA" Check if row value in Column AJ has partial string match containing "Intra-Asia" If all above...

Hi Excel geniuses, I'm looking for help simplifying this ugly (but working!) formula. First it performs a test to see if a PO is over or under a certain number. (Thank you @Peter_SSs and @etaf !) Based on that PO Number, I direct the next calculations to one of two VLOOKUP tables — one has old...

hello, I have a text file with blocks of data defined by parentheses, something similar to ( asas dsdss ) ( wwqee weqqe ) I need to extract the content between the parentheses. the problem is that sometimes the parentheses are nested. any suggestions? Thank you

Looking for a possibility of making this formula shorter, any ideas? Thanks =IF(AND(INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),7)=0,INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),8)>0),INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),1),"") This formula is producing this The active cell is A6...

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

Hi all Need to check if both matches are on the same row =row(A6)=row(B6) which works, but i need it nested within my other formula =IF(AND(COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),A6),COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),B6)),"Match","No Match")+ Cant work it out, could...

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

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

Hi, 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 IF(ISNUMBER(G2),"1","0") Can anyone help I am really struggling.

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