+ Reply to Thread
Results 1 to 12 of 12

Compare Price List for Duplicate Service Code & Service Description.

  1. #1
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Compare Price List for Duplicate Service Code & Service Description.

    Hello,

    I am looking for a help to find the duplicate then records i.e. Repeating of Service code & Service Description.

    Here is the explanation.

    1. Script should check within the same sheet i.e. Old List or New List whether the service code is repeating without matching Service Description & price.
    2. Script should check within the same sheet i.e. Old List or New List whether the Service Description is repeating without matching Service Code & Price.

    If the above mentioned fields are repeating then then complete row should copy to third sheet i.e. Duplicate with following additional information for track the record.

    1. The script should write the prices of the records based on how many times the record is repeating. Example: If the record is repeating 3 times with 3 different price. It should write all the three prices i.e. 50, 40 & 100
    2. The script should tell me how many time the service code & service description is repeating within the same sheet i.e. Old List Or New List.
    3. The script should tell me what is repeating i.e. Service Code or Service Description.
    4. The script should tell me the sheet name and the row number. Sheet name should be one time but the row no. will be multiple based on repeating times.

    I hope this will clarify what I want.

    Please see the attached sample file for more clarification.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Compare Price List for Duplicate Service Code & Service Description.

    hi hecgroups, please check attachment

  3. #3
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Compare Price List for Duplicate Service Code & Service Description.

    Hai Watersev,

    Thanks for your respond. Please note the following:-


    Difference in Service Code (Option 1): It is showing the service code correctly with the price but when it comes to service description it is not showing correctly.
    Explanation: Service code is repeating 5 times. 3 Times with same Service description and same price. But 2 times different service description and different amount.


    Difference in Service Description (Option 2): It is displaying the service codes correct with service description but the price is not showing properly.
    Explanation:Service description is repeating with different amount but it is not showing all the prices only 1 price.

    * If no duplicate service code or service description then the user get a message saying "no duplicate records found"
    * If possible please make all cell values in center.

    Might be due to my English language i cannot explain to you properly. Please see sheet Actual Result in attached workbook for more clarification.

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Compare Price List for Duplicate Service Code & Service Description.

    it would be helpful if your sample file provided contains full result output basing on all the data of the file. If no records have been found F1 on Duplicate sheet has zero value.

  5. #5
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Compare Price List for Duplicate Service Code & Service Description.

    Thanks for your valuable help i will provide your feedback tomorrow after working on original file. There will be one more request will come from my side that will be the final i hope so.

    If there is no issues then the topic will be closed.

    Thanks once again for your help.

  6. #6
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Compare Price List for Duplicate Service Code & Service Description.

    Hai watersev old list is OK but there is problem in new list. Below is the details:-

    Same service code and same service description but difference price. Insteat of giving one row it is displaying below result (Individual information). It should give me the result in one row.


    Service Code Service Description Price Remarks Errors Found In Repeating Times
    Sheet Name Row No.
    105 INTERNAL SPECIALIST EXAMINATION 50 Duplicate Code New List 5 3
    105 INTERNAL SPECIALIST EXAMINATION 60 Duplicate Code New List 6 3
    105 INTERNAL SPECIALIST EXAMINATION 70 Duplicate Code New List 7 3

    Also if the price is 3 digits it not displaying the amount correctly i.e. 300, 300, 3000. It is showing 300300300

    Unable to attached the sample file so for more clarification please see the images below:-

    Screen Shots
    Last edited by hecgroups; 04-30-2012 at 02:18 PM.

  7. #7
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Compare Price List for Duplicate Service Code & Service Description.

    please check attachment

  8. #8
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Compare Price List for Duplicate Service Code & Service Description.

    Sorry for late response actually i am sick and unable to goto office. I will provide you feedback tomorrow.

    Thanks for your valuable help upon my request.

  9. #9
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Compare Price List for Duplicate Service Code & Service Description.

    Hello Mr. Watersev,

    Please check the attachment which showing some issues on my original file. Details are as follows:

    1. Some service codes is not showing properly i.e. It is showing 000, 000, 000 (Check service Lab Test)
    2. Some row numbers is not showing properly i.e. It is showing 000, 000, 000 (Check service Lab Test)

    IF you have time please have a look on these issues and review your script.

    I appreciate is you give me the explanation of your script means if need to change some things i.e. space in between or move complete column front or back i should not ask you and bother you again and again for simple things. This will motivate me to learn something from you.

    Ofcourse if have any doubt i will ask you.

    Copy of file is attached for your easy reference.

  10. #10
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Compare Price List for Duplicate Service Code & Service Description.

    hi there,

    1. The easiest way to clear 000 error is to not use dot or coma as a separator in a string of numbers as those symbols can be interpreted by Excel as numbers. From now on the code uses ";" as a separator (I hope that's acceptable)

    2. I would not provide explanation as the code is not that easy to change. I could explain general algorithm but it would not help either. Even if I do that, I'm 99.99% sure you would ask.

    Please check attachment

  11. #11
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Compare Price List for Duplicate Service Code & Service Description.

    Hai watersev it works thanks for your valuable script it is helping me a lot in my work. Topic closed and reputation added.

  12. #12
    Registered User
    Join Date
    03-27-2016
    Location
    INDIA
    MS-Off Ver
    OFFICE 10
    Posts
    5

    Re: Compare Price List for Duplicate Service Code & Service Description.

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1