and

I hope someone will be able to help me In the attached screenshot you can see that the scope of work (column D) there is a list of transport jobs, if they have the necessary training in columns PMVA, FREC 3, FREC 4, ACA, DCA (Column E to I) which would be a date and it greater than today then...

Hey, I'm trying to find the average of 1 cell that is linked to another cell. In the image below, I am trying to get the average of the numbers linked to column A - so AAA and BBB. Taking 'AAA' as an example, I first need to find AAA in column B and then take the letters in column C and find...

Hello All, I have a data set where I need to match some numbers with each other but they have two letters in front of them that make it currently impossible to do. So for example I have: CP2003 in Cell B2 and RD2003.001 in Cell C2. I would like to know how to get a formula that matches just...

Hi MrExcel, I would like to find a easier way using my excel formula and maybe someone can give me some advice. The formula I have set up and is working is as follow (in german)...

Hello, I have the following formula written, but it’s not returning both ‘true’ or ‘false.’ Would love for feedback: AND(Q2=“abc”,G2=“D”,ISNUMBER(Match(k2,abc_dom,0))) Essentially, want to say if cell Q2=abc, and g2=d (that’s true) and if cell K2 matches the list from abc_dom, return false...