ifand formula

Hi all! I'm racking my brain trying to figure out how to create what I thought was a simple spreadsheet for our company's contracted tow roster. We have 4 towing companies. Each time a vehicle is towed, the next company on the roster gets to tow the next vehicle and so on until all 4 have...

Hi. I have an issue with a formula that doesn’t seem to be working. It was working until I added the AND statement to include the F = Y part. I need it to look in two separate columns, one with a simple yes or no and one with a search within text, then give me the joined list of correct results...

Good afternoon, I believe this is quite a niche and complex ask and not sure if it is possible. I have 2 workbooks which will be called "Workbook 1" and "Workbook 2". Workbook 1 has items that I am trying to input into Workbook 2. I want to be able to read "MD500" from Workbook 1. "MD500" is...

Hi, We have a date in cell A2. Date is 06/08/2023 now we want to come "OKK" if some condition meet the condition one work till we have no entry in B2, if we have entry in B2 then the below condition will not work Condition one - is If A2 is equal to today or smaller then today then OKK

Hey guys, bit of a tricky one here and would love some help, will try explain as well as i can. In the cells below i have A1-C3, A1 tells me if the action has been completed, No means it hasn't and so no. B1 tells me the device used C3 tells me the product The formula i am after will...

Hey guys, Struggling here with a big project of mine and really need some help! So the data i get in has two columns, a and b. In a it provides me with two answers either yes or no. This tells me if this was planted or not. Column b provides me with my trees data tag. i need to find a way to...

ABCDEFGH1SkuCompetitor SkuCross 1Disti 1Cross 2Disti 2IF ANDExpected Results211111x11xZ11xXZ and XZ and X322222x22xZ#N/A#N/A#N/AZ433333x33xZ33xXZ and XZ and X544444x#N/A#N/A#N/A#N/A#N/ANo655555x55xZ55xXZ and XZ and X78Disti 1 SkuDisti 2...

Hi, I am confused as to which formula would be more appropriate for the below problem I am trying to resolve. 2020 monthly payment tab I have a list of participants who give £3 per month and can select a product. They can stop participating at any time. If product A, £1 is allocated to product...

Hello! I'm looking to copy an entire row from one worksheet (Sheet1) to another (Sheet2) based on multiple criteria. For example, in the image below, I need to be able to find all the "Green" fruits and then refine that further to only "Medium" Size. Then, I need to copy the entire row (as long...

Hi there, I have a bunch of data with multiple entries and I need help creating a formula / process to eliminate duplicates based on a certain criteria. I only want to count one of each opportunity if it meets the following: 1) To Stage column (column F) must be "Negotiations/Deal Point...

Hi there, I'm new to the community. Please help me to follow the right procedures. I have a problem with nestling and I need your help. Here's the formula, it's a simple ifand formula. The formula works like a beauty until the last city (Yangon). Then the error message pops up. The...