Search results

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...

Hi gurus, I have been asked to find what will be the age of a person between 31/09/14 to 31/12/14. The issue I have is that its a date range. I know how to find age between a start date and a perticular date or today (=datedif(startdate, enddate,"Y"). But I am a bit confused as I have been...

Thanks Narayan, Can I not determine the year based on the month? I dont have B1 in this situation. I have to determine B1 based on if A1 id less than June or more than June. Thanks again Rana

Hi All, Can you please help me with this formula where; If DOB1 = 11.11.54 if want the formula to return = 1.12.2013 Thus taking it to the 1st date of the next month in 2013 if DOB2 - 11.3.54 Formula to return = 1.4.2012 Thus taking it to the 1st date of the next month in 2012

Hi all, This is really confusing and I hope I can explain it well. If cell a4=3 then I want cell b1,b2 & b3 to be =3 If cell a10 = 5 i want b4:b9 = 5 so if a cell in coloumn A has the number 50 , the 50 cells above in B row should have the number 50 in them. please help Rana

Thx Hui - this is awesome

Hi, I have a coloumn of names and these names are spellet like MarkMR, SteveMR etc. However I also have there names without the MR at the end ( Mark, Steve etc). What formula can I use to look at the last two characters and if 'MR' then remove MR and give me the name else simply return the...

Narayan - this one works but I need borders as well. Very sorry to be a pain - but thank you

The macro should paste Formulas, number formats and cell formats :(

Sorry Narayan - the above code works like a charm but does not paste the cell format. It only pastes the number format. Please help. I want it to paste number and cell format.

This works like a charm - thanks a lot #thebestexcelhelp