Apr 19, 2020 ... I now have a spreadsheet with hundreds of names scattered in columns C-L. So... how many votes did everyone get? I would like to find all ...

Functions can be used to create formulas that manipulate data and calculate strings and numbers. Here's a list of all the functions available in each category.

Jul 5, 2021 ... This is a column that lists all my Sundays, but for multiple years at a time. My goal is to be able to get a list of dates I'm taking off in "X" ...

May 27, 2020 ... I have managed to use Conditional formatting to check which cell ... cell accordingly, but this is only in excel. Ive played around with ...

May 19, 2019 ... I've got a list of email addresses. I want to build a rule to highlight an email address if it's from known providers (gmail, btconect, aol etc).

Apr 18, 2019 ... I can do simple countifs to find which ones are duplicates, but am failing to create a list of duplicates. I tried to use the formulas in this ...

Apr 29, 2020 ... A way to create a formula that uses reference lists on the 2nd tab as the "if this, than that" criteria. That way, it's easier to find and change what I need.

Oct 9, 2022 ... I've created a simple list using data validation with items in a cell. I've repeated this list over multiple rows in the same column.

Mar 9, 2021 ... I want to find all the names in one column where the appear in another, together with their corresponding scores, limited to 4.

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 ...

May 2, 2022 ... I need to have a specific cell checked for occurances of any of the words in the list and then return the matching words found.

Aug 8, 2022 ... Invalid data then doesn't get rejected but the cell is flagged with a red triangle in the top right hand corner. I want to detect the red flag ( ...

Apr 5, 2020 ... In Excel, I can create a list (for example, the days of the week ... find where they go in the list and add a new row. Which is getting ...

Jan 20, 2020 ... Hi Georg,. What you need to use is the SUMIF function. You can check it here : https://support.google.com/docs/answer/ ...

Sep 6, 2022 ... I am attempting to build a Google Sheet that would have the same functionality as Excel for "if cell contains text from list." You can find the ...

Sep 24, 2022 ... I stopped with just two cells because I knew if I could get it to list correctly, I'd be able to go ahead and make the formula check all the ...

Jul 13, 2021 ... The function I am looking for would find each instance of a course that matches a given list and counts the value in the credits cell, located two cells below ...

Jun 27, 2023 ... I have been messing with some formulas to find any matching data with the column of the expired computer names and any cell at all that has that same name in ...

Jul 28, 2020 ... I want to find all larger list instances of the names in the secondary list and then display the full contact details for each of those names.

Aug 9, 2019 ... I have a cell in a google sheets spreadsheet which contains many words. I need to pick out the last one. Using cell formulae I can find ...