Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with pseudocode translated into VBA Code
Hi
I need help with translating this pseudocode into VBA Code. I have a spreadsheet (37000 records) with the following columns: CustomerNo (Column B), ServiceDesc (Column E), OpenDate (Column F) I have to spot the duplicates in the CustomerNo and based on that perform the following: IF CustomerNo IS DUPLICATED THEN IF Within the DUPLICATED CustomerNo Records: ServiceDesc IS DUPLICATED AND OpenDate IS DUPLICATED AND TIME DIFFERENCE BETWEEN DUPLICATED OpenDate records IS GREATER THAN OR EQUAL TO 15 MINS THEN DELETE the DUPLICATE(S) based on CustomerNo END IF END IF I don't have to physically delete the duplicates but mark them as delete whilst keeping any of the duplicate records. Any help will be very much appreciated. If you can just start me off with some basic VBA code that should be enough. I'll amend the code based on trial and error. Thanks. ps. I know this pseudocode is not strictly pseudocode but hope it will help you understand the issue. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with pseudocode translated into VBA Code
On Nov 4, 11:18*am, Zuzeppeddu wrote:
Hi I need help with translating this pseudocode into VBA Code. I have a spreadsheet (37000 records) with the following columns: CustomerNo (Column B), ServiceDesc (Column E), OpenDate (Column F) I have to spot the duplicates in the CustomerNo and based on that perform the following: IF CustomerNo IS DUPLICATED THEN * * IF Within the DUPLICATED CustomerNo Records: ServiceDesc IS DUPLICATED AND OpenDate IS DUPLICATED AND TIME DIFFERENCE BETWEEN DUPLICATED OpenDate records IS GREATER THAN OR EQUAL TO 15 MINS THEN * * * * *DELETE the DUPLICATE(S) based on CustomerNo END IF END IF I don't have to physically delete the duplicates but mark them as delete whilst keeping any of the duplicate records. Any help will be very much appreciated. If you can just start me off with some basic VBA code that should be enough. I'll amend the code based on trial and error. Thanks. ps. I know this pseudocode is not strictly pseudocode but hope it will help you understand the issue. "If desired, send your file to dguillett @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a way to type a number and have it translated into text? | Excel Worksheet Functions | |||
Pseudocode software | Excel Programming | |||
translated menu in excel 2007 | Excel Discussion (Misc queries) | |||
pseudocode help please | Excel Programming | |||
Add comments via a function - please could you ammend my code/ pseudocode to work | Excel Programming |