and

Can anyone assist with unpuzzling what I did wrong with this formula? I am still learning how to create MATCH and INDEX formulas. Because of the vast amount of information in the file I would prefer not sharing the cleaned file because of how long it would take to scrub it clean. If I must, I...

I am trying to evenly assign work amongst employees based on their availability and language. Please help, thank you very much in advance.

Hi All I'm running into a bit of an issue I can't work out, granted I have a horrible cold right now... I have this formula to find content in a sheet called "Test", it works perfectly until later (G94)...

I'm struggling to take a median of a set of data with multiple criteria I have a set of raw data (Shown Below) I want to find the Median of the data in Row K (Gain) for all the cells where the DEF Call (Row H) is "Base Tommy" AND it's in Hole (Row R) 2 OR 3 OR 4 OR 5. (I don't want the median...

Hi all, Hoping someone can help me with this query. I have a workbook I am working on that currently sums all the values in column "O" if the value on the same row in column "L" is "WP" or "BS" until an empty cell is reached. I would like to expand upon this formula so that it still sums like I...

Hi, I am a beginner Excel user and I have been researching a problem. I cannot figure it out so I thought I would ask this forum. I am looking to combine a COUNTIF and an IF statement into one formula to arrive at my answer (Yes or No) for a survey type of project. Basically, I want to count...

Hi there, I have 5 conditional formats that I need to combine into one. Conditional format 1 =AND(M$9>=$J19,M$9<$J19+ROUNDDOWN($D19*($K19-$J19+1),0)) Conditional format 2 =AND(M$10>=$J19,M$10<$J19+ROUNDDOWN($D19*($K19-$J19+1),0)) Conditional format 3...

So i have a cell with product codes inside of that. for example cell a1 contains data - 1x ddjed8cx7ee cell a2 contains data - 4x ddjeudaadi3 cell a3 contains data - 1x nddnadjnfke 1x ajo37danunau 4x aud73ndnnak and so on I am trying to find a formula that can A. return the value of 30...

Hi everyone, I am working on a case management tool and am trying to identify 6 different types of renewals by comparing submission month, day, and year between two different cells. D2 is the certification period end date (renewal date), and D4 is the date we received the renewal form. I have...

Hi all, I am trying to write a formula where I can calculate all the 4a’s that are in the Gym, playing Basketball and are on a Tuesday. Hoping to find a formula where I would be able to drop down H3, H4, H5 to give me what I want at any time. Is it possible given that the dates are column...

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

I have a dataset with 500+ athletes, each with information on age category, best distance, season in which PR was achieved, and the absolute time of the PR. On another tab ("SBT") I have the overall season best time per age category on 6 distance over 5 seasons (total of 150 season best times)...

Hi all, I'm struggling to make a condition to a value to show a result based on the value of rows below in the same column. The idea is to give either R, A or G result, based on what is below. So if i have X amount of rows below, and each one has different values in combinations of R, A...

I have a spreadsheet which holds contract data i need to check if a contract has ended part way through the contract term and amend the end date to renewal date but also return nothing if the contract has no end date This is the formula i was using AA=IF(AND(Q1<>"",Y1=0 O1=12)...

Hi, wondering if anyone could help? I am trying to find a formula which can tell me if the numbers in that cell match another number - but for a range of numbers. To explain further, here is some data: Scores Satisfaction Work 4 Relationships 3 Friendships 8 Hobbies 1 Score...

Hello all, I recently updated my MS Office version, and am encountering a new problem using IF(AND with named ranges. As can be seen in the image below, the named ranges work fine for a simple IF function, and the IF(AND formula works fine if I use the cells. But when I use the named ranges...

Hi, I'm trying to make a column that will be used to inform a pivot table, however because the data sheet is populated by dates and not numbers, if i take data from both columns for the pivot table, there will be an overlap and inflation of resulting totals where both columns contain...

I need some basic help on this i m stuck please if anyone can help ? sheet attached

Hi all, I am trying to get a yes/no answer if a cell is between a time range. It is set up as a table on Office 365. I have tried IF and IFS statements with both AND and TIMEVALUE in it. I have attached a screen grab of what i'm working with at the moment. Any help is greatly appreciated. Chris

I am wondering if someone can help assemble a formula. I have a rota and wish to count the amount of people on night shift. Easy enough to separate and total them with a "countif" however, when people mobilise, instead of the usual "NS" for nightshift or "1" for Day shift, we now have the...