Excel Help On Countifs - Xls Download

Hi Friends,
I need one more favour. I though to post it separate but was sure would be able to get solution from someone of you. Attached is another workbook in which I need some help.
Sheet "Acrobat to Excel" column b have tag nos and column c have amount. By any formula/way I want to get tag no and following amount in same row. For example 7487981- and $3 in cells D3 and E3.
Now I copy column b and c and paste it in different sheet and then sort tags as all are in sequence and go to constants for amount and then copy and paste it. It works allright but seems that there is an additional step which I wish to avoid.
Attached herewith is the sheet. Pl let me know if do you have any questions.
Thank you in advance.
Regards,
Navin

Pl chk if this is what u want. It is not working in ur case because, the criteria that u r looking (eg. d233) is not an exact match in column c

hi nickkan.,
i think i tried some best solution for your excel problem. please check it out and reply me...
if it is correct solution.

Instead of dept you can get no of employee by using cell reference of code only.
why you have to creat one more column Dept.
other option i am looking in to that once i find i will reply

Hello niccken i found some solution for your problem.
please see it.

When you use a cell refernce and use like * option then it should be used along with &, that`s how excel works.
If you are not using cell referecne then you can use like * option without &
Hope this clarify your doubt.
Cheers

When I opened this file, it shows me binary digits like character. I really can not read this file, so really can not help by the time file cotains proper information.
Cheers!

Dear,
Check the attached file. Hope that your problem has been solved. Any clarification, please revert back.
Best Regards,
Alam

Dear all
can any help me how to calculate pf return and formalities of subimission the same
regards
mukesh