grateful

As I am combining data it seems to do the job just that it deletes or removes the entire rows, which I still require. For context, there are data from columns A to O, and I segregate only the data I require starting from cell Q2, the function I require help with is currently removing the entire...

Hello All. I would be grateful if somebody could help me please. I have a list of names that exist in D14:D42 which I'm endeavoring to copy the text to cell D4. The criteria for this list exists in column G14:G42. Using sumif, as shown below, it works if numerals are used but not for text...

Hello forum friends, I have an issue with the results of a DATEIF formula I am trying to build. I am receiving a result of $161.92 and it should be $50.06, so I am WAY off somewhere. I have included snapshots of the cells in question below. If anyone has any ideas, I will be grateful. Excel...

Hi all I managed to create a macro to build a graph which updates each time the lenght of the columns change. When I try to put the name of the horizontal axis, it work. When I try to do the same with the vertical axis it doesn't. Anyone willing to help? I am very grateful Thanks a lot valentina

I'm having a few troubles trying to solve a task in Excel. Task 1 - https://gyazo.com/a84dc9eeae2f3d1d10df66a2b756a077 Task 2 - https://gyazo.com/3b5a3e89d22046ad1b1c8cecd161d64a Let me know if you would rather me upload the excel file, but i'd be very grateful if anyone can help me with the...

Hi I cannot seem to get my spreadsheet to calculate over 24hours. I have tried the [h]:mm format but this is still showing values over 1000. I suspect it might be the calculations throwing it off but would be grateful if anyone can help me fix it. I have put a linlk to pictures of the...

Hi there, I have 3 columns of data in the following format: 1234 99 1234567 and I want to get it all into one column but in 2 different formats as such: 1234991234567 and 1234-99-1234567. Would be most grateful for any help

Hi there, I have a range (EF60:IV60) and I need to return the last value which is not blank or 0 I'm having a brain freeze moment... I've tried: =IFERROR(0,LOOKUP(2,1/(EF60:IV60<>""),EF60:IV60)) but it's not having it.... If you can point me in the right direction, I'd be most grateful Thanks

I wouldlike to form the sumproduct of an array B1 to B5 with a Gaussian probabilityfunction where the x-values are in cells A1 to A5. I tried the followingexpression =SUMPRODUCT(B1:B5,NORMDIST(A1,mean,sd,FALSE)):NORMDIST(A5,mean,sd,FALSE)) However,this is invalid and I would be grateful if...

Hi Guys, I would be very grateful if anyone can help me with the best formula to use on this one. I help coach with a junior football team and we have a squad of 15 players, but we can only select 10 on a match day, and there are 18 games during the season. Whats the best way to put a...

Hi, How do I write a code to replace cells that contains "0" in column A with the word at the top row of each 0 group? <tbody> AD 0 XX 0 XX 0 XX 0 XX AC 0 XX 0 XX DE 0 XX </tbody> Above is sample table and below is the output that i wish to obtain. <tbody> AD XX...

Hello, everyone. This is my first post so apologies if I am breaking etiquette - I mean not to and please point out if I am. I am hoping someone can help with the following: I need a formula for the table below that will count the number of times a specified fruit is mentioned in a particular...

I have for columns and am trying to create a formula that will place "X" in the first column if: 2nd column is greater than 11 and the third column is greater than 85(regardless of the value in the fourth column), or the 2nd column is greater than 11 and the forth column is less than 1.5...

Hi, i have built this if formula, which works correctly until the last if CZ>99 criteria is met, when the formula returns #Name? =IF(CW2<3,"Catch up",IF(AND(RIGHT(E2,3)<>"MPM",CL2>0),"100% Testing",IF(OR(CD2>100,CI2>100,CH2>100),"100% Testing",IF(CY2>99,"100% Testing CI",IF(CZ>99,"100% testing...