Excel
SalesAid Software
dguille...@gmail.com
From: Surendra Singh
Sent: Thursday, May 10, 2012 3:14 AM
To: Surendra Singh
Subject: $$Excel-Macros$$ urgent - Please Help _Urgent
Dear Group,
Please help me, please provide the formula for the attach file, If any employee
moved from one department
Hello Surendra ,
PFA!
On Thursday, May 10, 2012 11:14:26 AM UTC+3, Surendra Singh wrote:
> Dear Group,
>
> Please help me, please provide the formula for the attach file, If any
> employee moved from one department to any other dept. I have to make a
> separate entry in the sheet, but
Hi,
Try this formula in F16.
=IFERROR(INDEX(F$5:F$8,MATCH(1,($A$5:$A$8=$A16)*(F$5:F$8<>""),0)),"")
Apply with "Ctrl+Shift+Enter"
Regards,
MARIES.
On Thu, May 10, 2012 at 11:14 AM, Surendra Singh <
surendra.si...@in.aegisglobal.com> wrote:
> **
> Dear Group,
>
> Please help me, please provide
Dear Group,
Please help me, please provide the formula for the attach file, If any
employee moved from one department to any other dept. I have to make a
separate entry in the sheet, but for the payroll prospective I have to
consolidate the complete attendance in a single row. please make some
fo
