derive

Hi everybody, I'm writing an 'on_click' event for one of my ActiveX labels. But how do I reference itself in the code? I need to derive the label's name when I click on it. Is there a way on how to do it? thanks...

Hi, In below example in column A+B, i have hierarchy on the node level of the parent in column A and the child in column B. I would like to derive the text of each parent in column C, like below. Is there a formula for column C how i can derive this value? Column A Column B...

I have a range where I need to derive the level/depth in the hierarchy for each cell where some cells are comma seperated , for example: <tbody> Task SubTask ParentTask T1 T2 T0 T5 T3,T4 T8 T2 </tbody> In this example range, the level of T0, T5 is 1. The level of T1,T3,T4 is 2. The...

Hello - I am trying to derive the MODE of a sequence of times. I have the following format to convert: 12:00:00 EDT I imagine it does need to be converted Into text or number format so as to derive the MODE of this sequence. I have tried several approaches to no avail. I also wish to derive...

Hi, Need a formula to derive list of clients who has become overdue Client Date A 31/3/2017 B 25/3/2017 C 15/3/2017 D 5/3/2017 If the due is 17/3/2017, i want the formula to throw client name C and D who has become...

Given a list of 20 numbers between 65 and 100. Anything less than 70 = Fail (F); between 70 - 93 = Pass (P); and anything over 93 = exceed (E). What is a formula that I can use to derive results.