• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    Data Duplicate

    In this Line Dim dictFor As New Dictionary, dictIn As New Dictionary
  2. I

    Data Duplicate

    Hi Sir & Narayan I have used your code but it is showing the compile error Regards Muhammad SHakeel
  3. I

    Data Duplicate

    Hi Sir & Narayan
  4. I

    Data Duplicate

    @ Deb @ Kaushik @ shrivallabha Thank you all for assistance.
  5. I

    Data Duplicate

    Hi Sir, Thanks a lot, its working now 100%, and it took less than one minute. Great thanks sir. My whole day working is now on minutes. Regards Muhammad Shakeel
  6. I

    Data Duplicate

    Hi Sir, its working awesome in 2 minutes it done the job. i have a file in which about 400,000 entries with series. Barcodes are added on daily basis. I need to find only new barcodes from new file. and in new file all items are mixed. My old list have all duplicates in new, but new have...
  7. I

    Data Duplicate

    Hi Kaushik Thank you for your effort. Brother when we use v.lookup on 400,000 cells, it will hang the excel file. also at the time of sorting or filter, same problem occurred.
  8. I

    Data Duplicate

    Hi Deb Bhai! i have only need to do the task as fast as can...you can suggest any method brother. The above method takes almost 1 hour. Is there any method to work in minutes.??
  9. I

    Data Duplicate

    DEB Bhai!
  10. I

    Data Duplicate

    Hi Deb! Brother as my data is of about to 400,000 so these formulas reference to your link hang my system. Please see my this file https://www.dropbox.com/s/cq8w7cc132or3py/Barcodes%20Data.xlsx i hope now you understand Thanks
  11. I

    Data Duplicate

    Deb bhai i think i am not clarify my requirement I have prepare a utlity in which i had to Update only new barcodes generated by our sourcing department. I can get the total list of barcodes from system. while in utility i only want to update new ones. My aim is to know about new...
  12. I

    Data Duplicate

    DEB Bhai May You Live Long.... I have use your code but it is showing this "I swear.. there was no any duplicate befor this point & I have only One Column " Than show debug error Please see the file below, i paste the data duplicate and unique...
  13. I

    Data Transpose from 4 Columns to 12 Columns (from 12000 rows to 4000 rows)

    Thanks Deb....your people are great...thanks a lot
  14. I

    Data Transpose from 4 Columns to 12 Columns (from 12000 rows to 4000 rows)

    shrivallabha thanks you almost done everything i want great work
  15. I

    Data Transpose from 4 Columns to 12 Columns (from 12000 rows to 4000 rows)

    Narayan Thnx you are really ninja in excel ..deb bhai is also awesome...Thank you all
  16. I

    Data Transpose from 4 Columns to 12 Columns (from 12000 rows to 4000 rows)

    Need help :(
  17. I

    Data Duplicate

    These are updated on daily basis.... You can say i have a list of 400,000 Unique Names, New unique Names added on daily basis...i only want to know about new added names by using duplicate formula or anything else Barcode L123451988 L134568970
  18. I

    Data Transpose from 4 Columns to 12 Columns (from 12000 rows to 4000 rows)

    Waalaikum Aslam! Dear Bahi Deb.. Thanks you have done almost. i need one thing more..Please if you can.. I want this to do the pages from up to down pages not right to left Please see the file https://www.dropbox.com/s/5tzsemebz5a4ywr/Data%20Transpose.xlsx i will be very greatful...
  19. I

    Data Duplicate

    Hi Friends! I have a file with 1 coulumn and 400,000 rows. Its bar code file. Our data base of bar codes is regularly updating. today is 400,000, data after 2 days it will be 400,200. My issues is when i use duplicate formula it works, but when i sort the data by color, it hang my system, as...
  20. I

    Copy Paste from pdf files

    you can use total pdf converter, it is best software to convert pdf data into excel or other files. You can get it from google search engine.
  21. I

    Data Transpose from 4 Columns to 12 Columns (from 12000 rows to 4000 rows)

    Hi All, I am in trouble at office, i am doing a very boring & repeated task on daily basis, can you people give me a VBA or any formula to make me awesome at office. I have data in 4 columns and 12000 rows, i want to divide it in 12 columns & 4000 rows. But problem is that it will be...
View older results
Back
Top