matching values

Hi all, Hoping you can help. I'm in need of a formula to search if a cell's value is a duplicate, triplicate, etc within a column. If multiples are found, I want to sum the values from another column in those rows - excluding the first occurence. In my example below, I'm trying to find a...

Hi there So, I have the following situation on my hands (link to image) I have 2 sheets, one for registered IDs and one for transactions IDs. Both IDs are unique customers identifications. Example: John registered on the platform and was given the 890 ID. If john makes a transaction, that...

Hi everyone, I am having an issue using conditional formatting. I am trying to find cell values in one column that match cell values in a second column. once found the matching value is highlighted In the example; 1 and 2 in the first column would become highlighted. A B 1 0 2...

Hi there, I have 34 workbooks each with a column of numbers in, some numbers are the same & some are different (& other columns with different info in them) . I would like to find any numbers that appear in ALL the workbooks, and get a list of those numbers. (see below example - this would be...

Not sure I can articulate this correctly. I have two columns (on different worksheets) that have names. In this example below, all the lines would be a match because at least one 4-letter string in each row matches. (Having any name match is enough, do not need to match all names.) What I"m...

I'm trying to pull data into a template from a source tab matching by account number. However, having trouble when the account numbers in the source tab are not in the template. If its just one account number, or they are separated by good account numbers, the code below works, but if 2 or more...