Formula to check if rows that have the same value in one column have matching values in another column

Rob Patchell

To elaborate; I have an excel with ~4k lines. Lets say column B has numbers. Multiple rows will have the same number in that column (usually like 2-6 will match). Column C has words that will sometimes match with other cells in the same column of the rows that had matching values in column B.

So I want to create a formula that, for each each "chunk" of rows with matching values in column B, will look to see if that chunk also has matching values in column C (but only for that specific group of rows of matching B columns).

Basically I'm trying to narrow down this list and get rid of a big chunk of manual work since if they match I'm not worried about them so I was thinking of just making an =IF(Test, "Y","N") and putting that in a column and deleting all the Y's after.

Brian

This will count the matching column B & column C values. Then eliminate all rows with result greater than 1 to find unique values.

=COUNTIFS(B:B,B1,C:C,C1)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-04-8

Comments

0 comments

For each value of a column divide that value by the number of rows that have the same sequence in another column (counting multimapped reads with R)

Fill Pandas dataframe rows, whose value is a 0 or NaN, with a formula that have to be calculated on specific rows of another column

find pairs of rows that have same column value

Filling null values within a Pandas DataFrame with values from the same column that have a matching value in another column

How to filter values by Column Name and then extract the rows that have the same value to another CSV file? Python/Pandas

How to extract all rows that have the same value in a column as one of the rows?

sql: select rows which have the same column value in another column with a single query

is it possible for two rows of a column (primary key) of the table to have same character/value with same foreign key(another column)

Selecting rows from Pandas Dataframe with same values in one column that have only missing in another

Getting all values of various rows which have the same value in one column with awk

How to update the value in a column based on another value in the same column where both rows have the same value in another column?

Select Rows With the Greatest Value In One Column When Another Column Has matching Values

Pandas - filter rows with same value in one column and multiple values in another column based on the existence of a value in the latter column

TOP Ranking

Article

Formula to check if rows that have the same value in one column have matching values in another column

Formula to check if rows that have the same value in one column have matching values in another column

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Inner Loop design for webscrapping

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)

Removed zsh, but forgot to change shell back to bash, and now Ubuntu crashes (wsl)

ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

How to run blender on webserver?

Resetting Value of <input type="time"> in Firefox

Converting a class method to a property with a backing field

Ambiguous use of 'init' with CFStringTransform and Swift 3

Execute ./script.sh with a crontab

How to set tab order for array of cluster,where cluster elements have different data types in LabVIEW?

How to pass data to the ng2-bs3-modal?

Retrieve Element Tag Value XML Using Bash

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

SQL Server : need add a dot before two last character

Making Array From Page Elements in jQuery

Laravel's ORM sync with timestamps doesn't update timestamps

Do animations stop css changes after animation completion?