Search results

Hi, please could you help me with the below measure, My table : query 1 The column “Indicator” contains unique number like , 119 Mertric_Numerator is my calculated filed by choosing option from slicer I want to get the result for Indicator number 119, then IF sum( numerator) is blank OR 0 or...

Could you add a criteria for whatever you type in C4, highlight the finding in Red. i.e if i Type Emma All to be shown in red in ContactList Table. Thanks

ignore my message I have done it. Thanks

If i type an initial or Emma in column N, nothing will show up, how can i etend the range that covers the A:K in sheet 2 Thanks

Thanks NoSparks. This is great.

Hi Guys. Could you please look at the code for filtering. by typing Emma in the box I 'd like to see all the Rows are including Emma, I can see two instead of five Emma in data table. file attached. here is the code: Private Sub TextBox1_Change() Dim c, col As Long With...

Great .Thanks Peter

Thanks Bosco

Hi Guys, Essentially it is to have the 75th percentile of radiation dose and time separately from the obtained patient readings. I am going to use the dose and time measurement on the 75th percentile for our dose and time references. Please help, file is attached. Many Thanks

Hi Hui, ignore my previous message, I have corrected it myself by changing the Rows number AS18 TO 30 =IFERROR(INDEX(INDEX(Datum,0,3),SMALL(IFERROR(IF(INDEX(Datum,0,2)=(1*$G$2),ROW($AS$1:$AS30),9999),9999),ROW(D1))),"") Thanks for your help and time, You are brilliant at what you are doing.

Could you please check why some of the date are not showing up randomly , Mandatory Calendar, have I confused it with my conditional formatting?! Please help.

Thanks Hui, Fantastic.

Great job I can see why you guys are called Ninja :). Thanks indeed for your help and explanation which helped me a lot to learn my mistakes. Sorry I am bothering you again, If i edit or remove any date the green colour of that edited date will stay as green on Calendar. how can i get rid of...

Please could you look at my VB and formula on right side of "Mandatory Calendar" tab Calendar. I want to click on date and details appear on table on right side. Thanks guys

Hi Paul, I have used intersects but it is still does not work. see below Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("B5:AQ20")) Is Nothing Then Range("G2") = Target.Value End If End Sub

Could you please help where I have gone wrong. Clicking on colored date on calendar, wont show up the details of the course on the right side of calendar. I'd like to select a cell (calendar date) and events on that day are shown next to the calendar on right. Many thanks for help

Thanks so much deciog. great job

Many Thanks PaulF. it is working for counting the course type. but could you look the conditional formatting i.e. I want to have those three dated for CPD to be highlighted in blue on calendar as well. I appreciate it if you can help.

Hi, Please could you check the error in counting the course name on " course summary" tab and conditional formatting to highlight the proposed date for Course Name on calendar in Blue. Many Thanks

Hi Peter, It is fantastic. Thank you so much.

Hi, Could you please help changing this working time sheet in a way that basic user can copy and paste template below the the next one without changing anything else. I know it is easy to do it by creating one sheet for each staff, but having so many staff it is not easy to have 100 tabs across...

Hi, Please could you help. Calculating staff overtime and time taken. They should use their overtime hours within 3 month (I need this to be flagged up or goes red). Also if they are in deficit (means if times taken was more time than overtime show negative not like this ######. Many Many thanks

Many Thanks got it :)

I am sorry I can not see any changes in the file, have u uploaded the right one or is it me being stupid :)