About 1,234,547 results (5,910 milliseconds)
IF formula returns FALSE while comparing to equal numbers ...
https://support.google.com/docs/thread/193901389/if-formula-returns-false-while-comparing-to-equal-numbers?hl=en Dec 22, 2022 ... I have an IF formula, comparing two cells with the same number! and ... You'll need to find a way to round these values, as part of the ...
How do I count up values while excluding duplicates from other ...
https://support.google.com/docs/thread/99182081/how-do-i-count-up-values-while-excluding-duplicates-from-other-ranges?hl=en Feb 22, 2021 ... I know I can use COUNTIF to count the total number of 'Y' for "Returning' in Column C. What I'm looking to do is count the number of unique ...
How to find unique values and tally them? - Google Docs Editors ...
https://support.google.com/docs/thread/41180423/how-to-find-unique-values-and-tally-them?hl=en Apr 19, 2020 ... I would like to find all the unique names, list them, then count how many times they appear in the FormResponses.
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 ... ... duplicate values in order to see what the most common generated numbers are. I can do simple countifs to find which ones are duplicates, but ...
How can I search a column of 16-digit numbers and find ones that ...
https://support.google.com/docs/thread/2201536/how-can-i-search-a-column-of-16-digit-numbers-and-find-ones-that-end-in-0?hl=en Mar 9, 2019 ... ... number; it has to end in zero). For those specific cells I want to copy that number to another column in the same worksheet. I'm assuming ...
Google Sheets: Find and replace/delete many values at once ...
https://support.google.com/docs/thread/125735942/google-sheets-find-and-replace-delete-many-values-at-once?hl=en Sep 13, 2021 ... In Column A I have Names and in Column B I have associated email address(es). Separately, I have a second list of contacts in the same format ( ...
how to find 2nd and 3rd smallest value in a row, ignoring duplicates ...
https://support.google.com/docs/thread/303719208/how-to-find-2nd-and-3rd-smallest-value-in-a-row-ignoring-duplicates?hl=en Oct 24, 2024 ... Make sure that the sample spreadsheet shows a reasonable number of realistic-looking sample data rows, and manually enter the desired ...
My array formula is not recognizing the numbers listed in my ...
https://support.google.com/docs/thread/158253552/my-array-formula-is-not-recognizing-the-numbers-listed-in-my-reference?hl=en Apr 2, 2022 ... ... find it because it considers numbers different from text strings that look the same. The trim() function will convert numbers to text ...
Quartile, Quartile.INC and, Quartile.EXC don't return the value ...
https://support.google.com/docs/thread/77402859/quartile-quartile-inc-and-quartile-exc-don-t-return-the-value-expected-how-can-i-change-this?hl=en Oct 16, 2020 ... Calculating the quartiles for a specific dataset by hand, I get the same values ... Excel) use in red text below your values. You can ...
VLookup is not working - seems to be an issue with number's format ...
https://support.google.com/docs/thread/184867896/vlookup-is-not-working-seems-to-be-an-issue-with-number-s-format?hl=en Oct 20, 2022 ... Do you see any blockers from changing format of numbers from number to plain text? I guess not able to calculate anything but since these are ...
Row Number Array from Multiple Conditions - Google Docs Editors ...
https://support.google.com/docs/thread/46236422/row-number-array-from-multiple-conditions?hl=en May 12, 2020 ... I want to expand upon this and only return the row if multiple conditions are true. I want to find all rows that have the same values from row ...
How can I count the number of unique entries in a filtered list ...
https://support.google.com/docs/thread/198582382/how-can-i-count-the-number-of-unique-entries-in-a-filtered-list?hl=en Jan 23, 2023 ... How can I count the number of unique entries in a filtered list? I can't figure out what formula to use with countunique so that hidden ...
COUNTIF - Google Docs Editors Help
https://support.google.com/docs/answer/3093480?hl=en Returns a conditional count across a range. COUNTIF Function For this same video with audio descriptions ... COUNT : Returns the number of numeric values in a ...
Help with making one column with SAME value have a different ...
https://support.google.com/docs/thread/101987902/help-with-making-one-column-with-same-value-have-a-different-outcome-based-on-another-column-s-value?hl=en Mar 12, 2021 ... I have read through many forums watched many videos and can't seem to find something that works and I am by no means a specialist but need ...
How do I count the number of cells, in a range of cells, whose values ...
https://support.google.com/docs/thread/172551513/how-do-i-count-the-number-of-cells-in-a-range-of-cells-whose-values-fall-within-a-specified-range?hl=en Jul 25, 2022 ... ... figure it out. I have a sheet with a bunch of data, one column of which contains values from 0 to 64 (non-unique), and on another sheet in the ...
How do I enter the same numeric value in an entire column - Google ...
https://support.google.com/docs/thread/149201927/how-do-i-enter-the-same-numeric-value-in-an-entire-column?hl=en Feb 3, 2022 ... I've tried to get the 'single value' option to apply when I paste but the 5 digits are changed by one number ... I didn't find any ...
UNIQUE Function still displaying duplicate values from a list of ...
https://support.google.com/docs/thread/272555264/unique-function-still-displaying-duplicate-values-from-a-list-of-alphanumeric-characters?hl=en May 2, 2024 ... I have a list of part numbers that are alphanumeric characters. I am trying to remove all the duplicates on each row. When using the formula =unique(L2:P2) I ...
A function to aggregate similar phone numbers in google sheet ...
https://support.google.com/docs/thread/281501267/a-function-to-aggregate-similar-phone-numbers-in-google-sheet?hl=en Jun 23, 2024 ... I kindly request assistance in finding a function that can be used within a conditional formatting setup to help identify similar phone numbers.
Value is present, but receiving error "Did not find value "____" in ...
https://support.google.com/docs/thread/44925399/value-is-present-but-receiving-error-did-not-find-value-in-vlookup-evaluation?hl=en May 6, 2020 ... I'm attempting to pull over some information from one sheet to another by matching the same ID number on both sheets I have. However, when I do a VLOOKUP, I'm ...
How to extract repeated values in a cell to different columns and ...
https://support.google.com/docs/thread/89294872/how-to-extract-repeated-values-in-a-cell-to-different-columns-and-rows-accordingly?hl=en Dec 18, 2020 ... TL:DR - When you SPLIT() two cells, they must contain the same number of entries. ... Please find the link here and let me know if it is clear.