multiple array formula

I am after some help please on the following if any of you kind people wouldn't mind. I have this formula in a cell working fine =IF(OR(Q27="",Q27="Yes",Q27="N/A",N27="Yes",J27="Gap",P27="Yes"),"",T27-TODAY()) but I want to add another function if possible which would be If V27=Fail...

Good Morning, Here is what I have: In column B is a employee number, in columns C through R is a bunch of data that is irrelevance to this need, but then in column S is where another formula returns a value of "None", or another value such as "COBC", or a few other possible items. Below all of...

Hi Team, Can anyone help me with below requirement....here is the data <tbody> Customer Product Name Amount Contribution by Final Status Cust1 Product 1 17,991 Team 1 Cust2 Product 2 19,901 Team 2 Cust3 Product 3 18,948 Team 3 Cust3 Product 3 10,730 Team 1 Cust5 Product 5...

I currently have a workbook with over 50,000 rows of data based on color, make, model, package, year and price of cars and I'm using an array formula to retrieve price based on multiple criteria. The formula works perfectly when all information is in one workbook, but the array formula does not...

Hi All, First time poster beginner/intermediate vba coder. I've used userforms and input boxes in the past to build financial models but nothing like what I'm trying to do now. Situation: I have a large Master Data File ~25mb excel file that uses an AFO to pulls customer information from a SAP...

Hi All, First time poster beginner/intermediate vba coder. I've used userforms and input boxes in the past to build financial models but nothing like what I'm trying to do now. Situation: I have a large Master Data File ~25mb excel file that uses an AFO to pulls customer information from a SAP...

I wanted to make a study planner for myself. For that I have created three Excel Sheets namely Schedule, Tool and Status In "schedule" Sheet I have created a table as below <tbody> Slot 1 Slot 2 Slot 3 Date Status Topic Lookup Status Topic Lookup Status Topic Lookup...

Hi all, I have the following fields of data: A2 'values': (shows the value 'low', 'mid' or 'high) B2 ' ratings': (shows a value rating of between 1-5) I need a formula to populate the %'s in the table below, based on the rating and value. I.e. If Rating is 1 and value is 'low' show 0, if...

Hi everyone I've been trying to create a spreadsheet that tracks our golf group (boring I know!). And I have a table ranking the players that have won the most match points, made the most pars, birdies, etc, over the course of the week. I can use INDEX and MATCH functions to find the highest...

Hi All, I have a column called region that needs to look up a tab (Suburbs)with all suburbs and states in Australia and return a certain region for that suburb, However as some suburbs duplicate i need to index match 2 seperate columns. So the XX term below under region should return the value...

I have a workbook with multiple worksheets set to show/hide. I've created the below macro as a start to set the printing format so that it doesn't change for the users. I have two questions: 1) will the print settings apply when the users save the document in pdf format, and 2) how do I get the...

Hi, I'm having a slight issue with a multiple array formula I am using to copy over data from one worksheet to another. The formula works ok but as is it a Multiply Array I have to press CTRL+SHIFT+ENTER. However my original spreadsheet has over 15,000 lines of data and as each formula...