Check the date which is more than one time. if it is more that one time have to sum the debit amount of that dates

Hi All,
I have excel as below in that i have to check the date which is more than one time. if it is more that one time i have to sum the debit amount of that dates, please can any one help me regarding this.
Thanks And Regards,
Santhoshi
12.xlsx (9.5 KB)

@ryava_santhoshi What do you mean by “which is more than one time?”

  1. Create a new variable of type Decimal - we’ll call it dec1
  2. Open the excel and read the entire sheet and save to a datatable - we’ll call dt1
  3. For each row in dt1:
    If CDate(row.item(“Date”).tostring) > YourDateTime
    Assign dec1 = dec1 + cdec(row.item(“Debit”).Tostring)
    End If
    Next row

If you don’t have the datetime saved already as YourDateTime, you can instead use the following:

If CDate(row.item(“Date”).ToString > (new datetime(2019,6,25)). Replace the digits inside with the year as a 4 digit integer, month as a 1 or 2 digit integer, and day as a 1 or 2 digit integer

@Kyle in the excel in date column if date is more than one time present then i have to find the sum of debit of those dates…sorry for late reply

please check this workflow…
test.zip (9.6 KB)

1 Like

The perfect solution @pathrudu thank you so much.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.