How to find out if there is any month without pay.

[GVN KUMAR]

From the list below we need to know when our employees have joined and when they went on transfer

From the list of wages details, we find out whether they went on transfer or arrived from the month with zero.

1 Therefore Must have a salary in April and the name of the month from which zero salary was taken.

2 There should be zero salaries in April and the name of the month from which they have been paid since then.

Anyone can write a formula for this problem Thanks

 

[bosco_yip]

Try,

In M2, formula copied down :

=IFERROR(INDEX(B$1:L$1,MATCH(0,B2:L2,0)),"")

 

[GVN KUMAR]

SIR WITHIN A MINT GIVE SOLUTION SIR

REALLY WONDER SIR

THANK YOU SIR