Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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


Attached Files
File Type: xls Excel Sorting help.xls (36.7 KB, 91 views)

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

Attached Files
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.xls (42.0 KB, 51 views)

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.

Attached Files
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (32.0 KB, 39 views)

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.

Attached Files
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (32.0 KB, 37 views)

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

Attached Files
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (39.0 KB, 40 views)

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

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™