Excel help on countifs

Originally Posted by nickkan

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

Originally Posted by chella pandi

Hello niccken i found some solution for your problem.

please see it.

Originally Posted by carora

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

Originally Posted by adnanalam2

Dear,

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

Best Regards,

Alam