Hi gijsmo
Thank you so much for helping out with this, very much appreciated..
Have a great day
KInd regards
DezB
Hi gijsmo
Thank you so much for helping out with this, very much appreciated..
Have a great day
KInd regards
DezB
Hi folks
I really need some help please?? On the attached SS there is a total number of jobs per rule in column D. In Column E I really need to show a number of jobs, that when totalled across all the rules equates to 1500, a number which is entered into D27 and may change whenever required. However the figures that are created in E6:E23 need to be weighted in favour of the larger figures in D6:D23, but if the those figures are 10 or less then the whatever number is in D6:D23 should be in it's adjacent cell in E6:E23.
Is this even possible, and if so, has anyone an idea of how it might be accomplished please as it's way above me I'm afraid.
Many, many thanks on this, much appreciated.
Kind regards
DezB
Hi Pecoflyer
Perfect, thank you, very much appreciated...
Cheers
DezB
Hi Folks
I'm trying to get a Countifs to work which counts the number of times a name appears in a range when the day in a date also appears: =COUNTIFS(D5:D20,"="&L3,F5:I20,K4)
The column of dates has been formatted as "ddd" and the name is just a name
I'd really appreciate some help please as I've tried numerous variations but keep getting a #VALUE error
Many thanks
DezB
Hi Rory
Of course, duh.. thank you...
Kind regards
DezB
Hi Folks
I have a column with a date/timestamps and would like to extract the date then turn that date into something that can be used.
I've used the LEFT function to extract the date into another cell then use the INT in another cell to convert it to a date that I want to use.
However, I was wondering if I could combine both those functions to do the same job in one? Any ideas please??
This is the date stamp:
2023-05-30 16:49:16.468000+00:00
Kind regards
DezB
Hi MBCV
Perfect, thank you, very much appreciated....
Kind regards
DezB
Hi Ali.
It's good to hear from you, thank you for responding.
The idea is to look at the date in cell M4 and match that to row D1:I1, look at the Criteria in Cell L10 and match that to column C4:C34, also look at the Version number in cell N9 and match that row D2:I2, then return the value from D4:I34.
In the example the result in Cell N10 should be: 565
I hope this helps, (and makes sense...)
Kind regards
DezB
Hi Folks
I'm playing with the XLOOKUP function at the moment but have run into a problem. If I just use two nested XLOOKUP's it works fine, but as soon as I enter a third XLOOKUP I get a #VALUE error
Can someone give me some guidance and help please?? I've attached a sample so that you can see where I'm going wrong
Thank you.
Kind regards
DezB
Hi AliGW
You star, thank you so much..
Kind regards
DezB
Hi Folks
Sorry if this turns out to be something really simple, just overloaded I think.
What I'm trying to do is:
If cell Q31 is empty, do nothing. If it has a date in it, check that date against TODAY(). If there are between 30 and 89 days return "Yes", if it's more than 89 days return "No"
I hope someone can tell me where I'm going wrong....
=IF($Q31="","",IF(AND(TODAY()-Q31>30<89),"Yes","No"))
Thank you..
Kind regards
DezB
Hi Rory.
Worked like a dream, thank you.. Much appreciated
Hi Rory
That sounds interesting, I shall have a play, thank you... Much appreciated...
Hi Rory.
That's where I also have a quandary as it needs to count is a 1. Basically what's being recorded is if there is a change in the position of funding. I was trying to start with greater than 0 but I guess what it really needs to look at is, is there a figure anything other than 0.00. I hope this helps, it's been a long week, although it's been a short week in the UK
Kind regards
DezB
Hi All.
I'm trying to get a COUNTIFS to work where it looks at a date and an ID number then counts data in 3 columns. However, what it needs to do is look at the first column, if it is 0.00 then ignore it, if the next column is 0.00, ignore that too but if there is a number greater that 0.00 in the last column, count it as 1
If there are figures are greater than 0.00 in one or more of the columns then also count it as 1 and total up all the 1's in the formula column.
I've attached a sample, I really hope that helps.
Any assistance will be gratefully received, thank you......
Kind regards
DezB
So am I, especially as I should have seen it right before my eyes, a bit of "wood and trees" popping in I think..
Kind regards
DezB
Hi Folks.
I know this is going to be a silly error on my my part, but can anyone tell me why excel is not seeing this as a formula??
=IFERROR(SUMIFS('Errors-YTD'!$H:$H,>0,'Errors-YTD'!$L:$L,"<="&D$14,'Errors-YTD'!$C:$C="Customer",'Errors-YTD'!$E:$E,$B33),0)
H:H is a column of numbers and I need it to sum up all the numbers that are above 0
L:L is a column of dates and the formula looks for any dates less that or equal to the date in D14
E:E is a list of codes and the formula looks for the code that is in B33
Somehow I'm missing a quotation or a comma I think..
Any help, much appreciated as usual please...
Kind regards
DezB
Hi Carim
This forum always helps me out, as it does countless others, it really is an amazing place to turn to thank you... Long may it continue...
Kind regards
DezB
Hi Both
Thank you so much for the advice, very much appreciated as usual...
Kind regards
DezB
Hi
I need to count the number of times a name appears in a range and also on either the Tur or Fri. Also how many times in each month the name appears.
I've attached a sample workbook if that helps and would really appreciate any help please..
Kind regards.
DezB