• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula

R

ranaray

Member
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 = Employee name
Coloumn 4 = employee leave date. Unfortunately not all employees have a leave date and each employee had more than 10 lines of data.

So technically the formula should copy the leave date and populate it against the employee then start the process for the next person.
 
Sorry Jaya - this one is failing for employees who dont have a leave date. Its working for the ones who have a leave date
 
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.
 
ranaray said:
this one is failing for employees who dont have a leave date. Its working for the ones who have a leave date
Click to expand...
Hi,
=IF(ISNUMBER(E2),E2,F1)
its working fine with the desired outcome you've mentioned in your attachment.

if it is not what you are looking for, then you need to be more specific about your requirement.

Regards,
 
Khalid NGO said:
Hi,
=IF(ISNUMBER(E2),E2,F1)
its working fine with the desired outcome you've mentioned in your attachment.

if it is not what you are looking for, then you need to be more specific about your requirement.

Regards,
Click to expand...

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

Does the following array formula exhibit the desired behaviour?

=IF(MAX($E$2:$E$1916*($A$2:$A$1916=A2))<>0,MAX($E$2:$E$1916*($A$2:$A$1916=A2)),"")
 
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.

The reason why the above formulas are working so far is because there are employees in the sheeet that are still in the company hence no leave date. The formula is putting a leave date next to them.

Hope this makes sense.
 
You must log in or register to reply here.
Back
Top