nickkan
1

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

From Australia, Perth
Attached Files (Download Requires Membership)
File Type: xls Excel Sorting help.xls (36.7 KB, 100 views)

VASAN
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
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.xls (42.0 KB, 53 views)

chella pandi
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.
From India, Coimbatore
Attached Files (Download Requires Membership)
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (32.0 KB, 40 views)

vmohan1978
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
From India, Bangalore
chella pandi
Hello niccken i found some solution for your problem. please see it.
From India, Coimbatore
Attached Files (Download Requires Membership)
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (32.0 KB, 39 views)

carora
1

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

From United Kingdom, Hounslow
carora
1

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!
From United Kingdom, Hounslow
adnanalam2
14

Dear, Check the attached file. Hope that your problem has been solved. Any clarification, please revert back. Best Regards, Alam
From Oman, Muscat
Attached Files (Download Requires Membership)
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (39.0 KB, 49 views)

mukeshjoshi82
Dear all can any help me how to calculate pf return and formalities of subimission the same regards mukesh
From India, New Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.