Recent content by ranaray

I am going crazy trying o figure out why is my countif formula not working. I have attached the spreadsheet for your reference. Thanks Rana

Sorry to start this thread again - but this has come back to bite me. Deepak : The data is not organised. The trouble I am having is - an employee could have a leave date or may not have a leave date. - I want to reduce the data so that I have the line just before the employees leave date...

Khalid it isnot working because its populating a leave date for an employee who doent have a leave date. Can you please check for he employee - 900001 on the sheet. I hope you getting it.

This wont work either - as this will only populate whts in coloumn E. There has to be connection with the employee ID - s that it understands the number of lines thesame employee hs ad then populatt leave date from coloumn E.

Sorry Jaya - this one is failing for employees who dont have a leave date. Its working for the ones who have a leave date

Please find attached

Hi, Can someone please help me crack a formula that satisfies the below criteria? I need the formula to copy the leaving date for a person into multiple lines and stop when a new person appears then do the same for that person and so on. Coloumn 1 = employee unique ID Coloumn 2 & 3 =...

Hi Luke, I want the macro to create the sheets and want the password to be hardcoded into the macro. thanks Rana

Hello gurus, Can you please help me ? I have gone through various forums but not getting what I need. what I need the macro to do in the ollowing order. 1. Select the specified column ( Colomn heading : name of business partners) 2. Generate an unque list of these business parners 3. Cut...

Thanks Nebu : now I need to get this to work for coloumn A based on values in coloum B

Hi Asheesh, Rule 1 : this works perfectly : this is cell A1 turns red if value of cell B1 is <3 Rule 2: I need the cell A1 to highlight only if I put a figure in cell A1 which is more than 0 else it should remain as is. This is the bit thats not working. Hope I was able to explain well. Rana

I am struggling with a formula that i want to work in conditional formatting. I want the cell A1 to highlight if the value of B1 is <3. However the cell should not highlight if there is no value in A1 or if teh value is 0 Thanks Rana

There is something that I am not doing right in the formula. Eg : if I do a standard median formula for 9 accounts above, I get a differnt median number as compared to the above formula event after using (CTRL+Shift+Enter). Its off by 400 Any advice?

Hi gurus, Struggling to get a median if formula. The one that I am using is =MEDIAN(IF(B:B=B5,C:C)) Want to find the midpoint for the below data. where B = the Range of names B5 = the actual name within the range C = values related to the Bs Personal Job Title (B) Annual Pay (C) Abnormal...