Column B search that contains duplicate data in rows are not included and I need duplicates counted/included in the search

Ses

New Member
Joined
Mar 14, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
An excel formatted downloaded bank activity file contains duplicated data deposits from my job where the dates in column A are different dates but the company name in column B and the amount in column C and the bank file contains other bank transactions which have duplicates except for the dates. The VBA code sums transactions that consists of debits and deposits which are in column C according to the respective transaction names. For example, grocery debits accumulate in the Food label, medical bills and doctor bills in Medical label, etc.
Excel 365 skips the duplicates. It enters the 1st found and skips the duplicates no matter where they are in the Column B; right below the current found row or several rows down.
I switched to excel 365 because excel 18 working VBA files were acting up like MS wants me to switch to 365!
Thank you.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,147,516
Messages
5,741,623
Members
423,674
Latest member
Charles2dodo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top