Recent content by lwarren1968

Can someone review the CheckDigit Calculation portion below? Something is off. Example 02636267000 returned check digit of 6 however it is actually 2 let Source = Excel.Workbook(File.Contents("J:\PRICE\QUERIES\144F\144F.xlsx"), null, true), Sheet1_Sheet =...

Can you attached the spreadsheet you were working with? Also, what happen to the 2nd "General Withdrawal"?

Trying again.

Yes, it is how I get the data. Regardless or maybe not it should not be deleted as it's within the date/time that should not be omitted.

Okay, its modified to show addition records after the end date. Also the time stamp is essential along with the date. Also, there should never be a 3rd "General Withdrawal".

I've edit it spreadsheet highlighting all in red that should be removed. Thank you.

done. All in red should be removed.

all in red should be removed. Thanks. TimeZone Name Type 8/16/2023 6:13 AM PDT JOHN DOE 1 Express Checkout Payment 8/16/2023 7:23 AM PDT JOHN DOE 2 Express Checkout Payment 8/16/2023 9:33 AM PDT JOHN DOE 3 Payment Refund 8/16/2023 11:33 AM PDT JOHN DOE 4 Express Checkout Payment...

I need to delete rows between dates/times using an additional field to determine date/time range. Specifically, using the 1st "General Withdrawal" as the starting point under [Type] deleting all rows equal to or less then that date/time and then if there is a second "General Withdrawal" it...

Absolutely not. All has been helpful. I think I was in my head regarding how it should work vs how it actually works. Taking a second look this morning clarified the process. Thanks you.

Thank you so much. This works perfectly. I didn't think to put the calculation in first.

I honestly have been googling. I'm missing something, hence the reason I'm asking for help.

I'm getting an error "entered to few arguments for the function" =SUMIFS(Sheet1!A2:A1000, Sheet1!C2:C1000,"*01*",Sheet1!D2:166) LOC DATE Drawer CASH 001 03/23/23 00-507 0.00 001 03/23/23 00-768 0.00 001 03/23/23 00-WEB 0.00 001 03/23/23 01-013 719.58 001 03/23/23 01-014 460.90...

I'm not sure how to incorporate the AND(). I'm doing something wrong. Def. not an expert. =SUMIF(AND(Sheet1!A2:A1000,"*001*",Sheet1C2:C1000),Sheet1!D2:1000)

I am trying to include an "&" statement to look at 2 columns within my SUMIF statement, but it's not working. Works fine if I'm only including 1 column. Any advise? =SUMIF(Sheet1!A2:A1000,"*001*",Sheet1!D2:1000) I want to include an IF Sheet1!C2:A1000,*01*.