Search results

Hi. I have a team of people that record jobs onto a system in the format of dd:hh:mm the sheet could be a weeks worth or a days worth depending on how many days I pull off to review. The column does not have a total and when I try to add the days hours and minutes booked it does not total. Is...

Hi. I did get a solution but there is one problem with it. I have attached a section of the sheet for your attention. I have a selection process for the project title, from that result I use an XLOOKUP to fill cells to the right, the problem is the filtered data does not show the last line of...

Thank you I will try and give this a try.. 🤞

Is it possible to link an item from a drop down list that completes another action, for example. I select a title from a drop down list in B2, Would it be possible to select automate and reference the drop down result so that you can generate an automated reaction. What I want to do is when...

Thank you so much I will try this. Another thought was is it possible to link this action with a automation rule? the only thing is how would you combine the drop down list with the rule? Just a thought...

Hi. Thanks for your respons. Could I explain a little more please. I have attached a sample of the sheet to better explain my intention. In the top of the sheet I have a drop down created by a validation list. When I select a title which is highlighted in the sheet I would like the title to...

I have created a drop down list from a selection of titles in a project sheet. What I want to do is select a project title from the drop down and that project title appears at the top of the page so that it can be reviewed. The sheet is in excel. I hope that makes sense any help most welcome...

That is perfect thank you very much, I have leaned a lot since the short time on this group.

=IF(COUNTIF(D25:D27,">0")=0,C28*C8,AGGREGATE(15,6,D25:D27/(D25:D27>0),1) Hi, Thanks for the response. I have entered the formula as you sent above. The trouble is D25:D27 can be any number and they need to be totalled into D30, if D25:D27 are "0" only then do we divide D23 by 50% which is C28. I...

The available space D1 is floor space. If there is no measurable ventilation data the D5 or D6 or D7 and they say 0 then divide D1 by C8 (50%) answer into D10 If there is ventilation type and D5>0 or D6>0 or D7>0 then the lowest number answer in D10 I hope that makes sense, happy to clarify if...