About 1,957,354 results (1,974 milliseconds)
Identify duplicates between two columns in Google Sheets - Google ...
https://support.google.com/docs/thread/152011014/identify-duplicates-between-two-columns-in-google-sheets?hl=en Feb 23, 2022 ... I am looking to have column A(entire column) cells highlight if there is a match in Column B(Entire column) I thought it would be simple but the formula I ...
Compare two lists and return only those values that are missing from ...
https://support.google.com/docs/thread/7345105/compare-two-lists-and-return-only-those-values-that-are-missing-from-one-list?hl=en Jun 3, 2019 ... I have two queries pulling in data to form two lists. I need to compare the names in List 2 with the names in List 1 and create a 3rd list for those that are ...
Combine multiple lists of names while not duplicating duplicates ...
https://support.google.com/docs/thread/27677360/combine-multiple-lists-of-names-while-not-duplicating-duplicates-about-25-of-names-are-duplicates?hl=en Feb 4, 2020 ... ... duplicates (about 25% of names are duplicates). Hello - I was hoping someone in the community can help me find a solution for the simple problem ...
Highlight Duplicates based on two separate columns - Google Docs ...
https://support.google.com/docs/thread/154350325/highlight-duplicates-based-on-two-separate-columns?hl=en Mar 10, 2022 ... I am working on a sheet where I need to highlight duplicates based on two separate columns without having the formula check the column in between.
Compare columns in Sheets - Google Docs Editors Community
https://support.google.com/docs/thread/234860840/compare-columns-in-sheets?hl=en Sep 14, 2023 ... On a spread sheet I have two columns, old data in column A and new data in column B. I'd like to compare the two columns to see if there are any matches.
Struggling to compare two arrays. - Google Docs Editors Community
https://support.google.com/docs/thread/172805354/struggling-to-compare-two-arrays?hl=en Jul 27, 2022 ... I am trying to compare two sets of data. I want to get A:G, search I:J for a name that matches B:C, and if it matches I don't want to see the entry at all.
How can I compare values in two columns? - Google Docs Editors ...
https://support.google.com/docs/thread/85389378/how-can-i-compare-values-in-two-columns?hl=en Nov 26, 2020 ... I have two columns of ID's that come from two different sheets. I load these columns through =unique() formula. These ID's are used to connect data from the ...
How to compare two columns, find matches, create a third column ...
https://support.google.com/docs/thread/170996175/how-to-compare-two-columns-find-matches-create-a-third-column-showing-the-matches?hl=en Jul 13, 2022 ... I often need to compare two long lists of items and figure out what items appear in both lists. I need help with a formula that can do this for me.
How to delete duplicate and original between two columns in ...
https://support.google.com/docs/thread/138713270/how-to-delete-duplicate-and-original-between-two-columns-in-google-sheets?hl=en Dec 4, 2021 ... I am looking for a formula that will compare Column A with Column B, look for duplicate data between A and B, and delete both the duplicate data and the ...
Simple Comparing Two Sheets For Duplicates and NON duplicates ...
https://support.google.com/docs/thread/188024328/simple-comparing-two-sheets-for-duplicates-and-non-duplicates?hl=en Nov 10, 2022 ... I think the link to the file should help. I had a hard time finding information on comparing rows to columns. My fingers are crossed that it can ...
Highlight duplicate names when last name, first name are in two ...
https://support.google.com/docs/thread/41751435/highlight-duplicate-names-when-last-name-first-name-are-in-two-separate-columns?hl=en Apr 22, 2020 ... Highlight duplicate names when last name, first name are in two separate columns. I would like to highlight duplicate names in a spreadsheet ...
Is it possible for a formula to search from a dynamic list against a ...
https://support.google.com/docs/thread/109240086/is-it-possible-for-a-formula-to-search-from-a-dynamic-list-against-a-static-list?hl=en May 9, 2021 ... I'm trying to get the sheet to compare a dynamic list against a static list and return a value if the match is made.
Multiple people working on 1 sheet resulting in entries in wrong cells ...
https://support.google.com/docs/thread/2128157/multiple-people-working-on-1-sheet-resulting-in-entries-in-wrong-cells-and-mixed-up-filters?hl=en Mar 7, 2019 ... This could either be a list on a separate tab, or it could be Condition Formatting (highlight dupes). You could then delete the duplicate rows.
Compare 2 columns, find duplicates, copy/paste related row data ...
https://support.google.com/docs/thread/23231938/compare-2-columns-find-duplicates-copy-paste-related-row-data?hl=en Dec 18, 2019 ... Hi BGW,. I created a new sheet in your file called AdamHelp that has a possible solution for you. It uses the formula: =ARRAYFORMULA(IF(A1:A ...
Query based on duplicates in 2 columns but with different data for ...
https://support.google.com/docs/thread/118080322/query-based-on-duplicates-in-2-columns-but-with-different-data-for-the-duplicate-information?hl=en Jul 21, 2021 ... This is an example spreadsheet: https://docs ... (Note we could also list the ones that just occur once, by removing the outer query.).
How do I match up values in two columns and sum up the matches ...
https://support.google.com/docs/thread/34775548/how-do-i-match-up-values-in-two-columns-and-sum-up-the-matches?hl=en Mar 21, 2020 ... I've been attempting to do is compare Sheet1, Column G with Sheets 2, Column A and when there is a match sum up the corresponding values in Sheet2, Column B.
Formula to compare lists on multiple tabs and to add any names not ...
https://support.google.com/docs/thread/207852228/formula-to-compare-lists-on-multiple-tabs-and-to-add-any-names-not-match-to-another-tab?hl=en Mar 25, 2023 ... I originally wanted to just use a Match or Index formula to compare multiple lists on multiple tabs with another master list and have it tell me which names ...
Compare two sheets for changes by column names instead of ...
https://support.google.com/docs/thread/113700259/compare-two-sheets-for-changes-by-column-names-instead-of-hardcoded-ranges?hl=en Jun 15, 2021 ... In the "IMPORT" sheet, I am importing data from an external source that sometimes have more columns or existing columns are arranged each time ...
How to create a formula listing duplicate values in a new column ...
https://support.google.com/docs/thread/4456931/how-to-create-a-formula-listing-duplicate-values-in-a-new-column?hl=en Apr 18, 2019 ... I can do simple countifs to find which ones are duplicates, but am failing to create a list of duplicates. ... list in different columns in my ...
Compare two columns and generate a true or false result - Google ...
https://support.google.com/docs/thread/116865323/compare-two-columns-and-generate-a-true-or-false-result?hl=en Jul 12, 2021 ... I am almost at the finishing of my project. Now i am stuck at a point ,where i am not sure how to go forward. i need to compare two columns and ...