excel & match & replace

My excel workbook consists of data below : 0 0 0 0 1 2 3 0 0 1 2 3 0 1 0 0 0 1 2 0 0 0 0 0 0 0 0 0 I want to calculate number of starting zeroes in each row. So my result for the above row would be: 0 0 0 0 1 2 3 => 4 0 0 1 2 3 0 1 => 2 0 0 0 1 2 0 0 => 3 0 0 0 0 0 0 0 => 7 I'm not...

Hi, I am looking for multiple criteria lookup/max date. I have two different sheets, Sheet 1 contain main data and Sheet 2 contain Terminal and i want to extaract the (Terminal id Max date and transaction with branch) <colgroup><col><col><col><col><col><col></colgroup><tbody> Sheet 1 A B...

Hi I am looking for some one help..my data is as below. <colgroup><col><col><col><col><col></colgroup><tbody> DATE Dept BRANCH Transaction Terminal ID 8-Oct-15 TT MCT IN 21666446 8-Oct-15 TT NIZ OUT 21666434 8-Oct-14 TT MCT OUT 21666446 26-Mar-11 TT MCT OUT 21666760 26-Mar-11 TT MCT...

<tbody> 1 A B D E 2 jdoe Acct jdoe Accounting 3 jsmith Business jsmith Business Office 4 tmax HR tmax Human Resources 5 hgerald Acct hgerald Accounting 6 dhummer Admin dhummer Administration 7 dlane Sec dlane Security 8 rsmith Admin rsmith Administration </tbody>...