About 1,639,977 results (5,518 milliseconds)
Retrieve value from last row based on multiple criteria - Google ...
https://support.google.com/docs/thread/8972210/retrieve-value-from-last-row-based-on-multiple-criteria?hl=en Jun 29, 2019 ... There are multiple columns and rows on the first tab. My issue is that I would like to retrieve a value based on two conditions and I'm not ...
How to Display data based on multiple Criteria - Google Docs ...
https://support.google.com/docs/thread/68461262/how-to-display-data-based-on-multiple-criteria?hl=en Sep 2, 2020 ... I would only like to copy the Columns A and B to Sheet 2. What is the best way to do this? If i wanted to take this data and import the data to ...
MAXIFS with multiple criteria for one column? - Google Docs Editors ...
https://support.google.com/docs/thread/49530597/maxifs-with-multiple-criteria-for-one-column?hl=en May 27, 2020 ... I am running into an issue with the MAXIFs formula. I am attempting to figure out the largest value in a range based on multiple criteria.
How to sum a total of one column based on multiple criteria in ...
https://support.google.com/docs/thread/29640311/how-to-sum-a-total-of-one-column-based-on-multiple-criteria-in-separate-column?hl=en Feb 24, 2020 ... Actual row count: 1, column count: 1. =sumif(filter('Member List'!A6 ... Value('Member List'!F6:F,">0")). Can anyone help? Thanks! Susan.
How to Conditionally Lock Cells based on a Drop Down List in ...
https://support.google.com/docs/thread/155241758/how-to-conditionally-lock-cells-based-on-a-drop-down-list-in-another-column?hl=en Mar 16, 2022 ... ... based on multiple criteria. The formula worked, so I tried to apply ... If you set the value in column G to either Chevy or Toyota, the ...
How do I get multiple criteria to work in one custom formula ...
https://support.google.com/docs/thread/238316853/how-do-i-get-multiple-criteria-to-work-in-one-custom-formula?hl=en Oct 8, 2023 ... I need to format a column based on data in two other columns. When I do it based on one criteria, it works fine. But when I try to add a second criteria, ...
How to conditional format based on two conditions of another cell ...
https://support.google.com/docs/thread/34905276/how-to-conditional-format-based-on-two-conditions-of-another-cell?hl=en Mar 22, 2020 ... The only thing a CF rule can do is evaluate the current values in the cells and determine if a rule evaluates to true or not true. Sequence of ...
Staff Timetable - Counting Shifts based on multiple criteria across ...
https://support.google.com/docs/thread/93221076/staff-timetable-counting-shifts-based-on-multiple-criteria-across-multiple-ranges?hl=en Jan 12, 2021 ... ... cell it is searching is only a partial match with "Day". I have created a simplified copy to demonstrate what i have tried so far: https ...
How do I use a formula to group and sort data based on multiple ...
https://support.google.com/docs/thread/56623356/how-do-i-use-a-formula-to-group-and-sort-data-based-on-multiple-criteria?hl=en Jul 1, 2020 ... ... based on multiple criteria? I ... I want to use a formula to group this data: If A and C match on multiple rows, each row is one entry.
Check one column for criteria, then move on to another and check ...
https://support.google.com/docs/thread/222128362/check-one-column-for-criteria-then-move-on-to-another-and-check-that-one-based-on-priority?hl=en Jun 23, 2023 ... I need the formula to stop once it finds a matching value in a column, based on priority assigned to columns. It's basically an IFS formula ...
How to create a conditional median formula - Google Docs Editors ...
https://support.google.com/docs/thread/32535008/how-to-create-a-conditional-median-formula?hl=en Mar 6, 2020 ... I'm trying to calculate the median of some data points based on multiple conditions. ... column A = NORAM and B = Client expectations of value not ...
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 ... ... based on two separate columns without having the formula check the column in between. ... depending on things like whether the same value ...
Index Match Multiple Criteria W/ Partial String Match & Value Match ...
https://support.google.com/docs/thread/145364829/index-match-multiple-criteria-w-partial-string-match-value-match?hl=en Jan 12, 2022 ... ... match an exact value -- eg: CELL=COLUMN. I have tried to following formula (on sheet below -- cell I2 --> =ArrayFormula(index(C:C,match ...
SUMIFS for multiple criteria across a table - Google Docs Editors ...
https://support.google.com/docs/thread/154071657/sumifs-for-multiple-criteria-across-a-table?hl=en Mar 9, 2022 ... I'm trying to make a formula to sum individual's finances based on multiple criteria. ... Excel to figure this out. Thank you for your help ...
Calculate Average Across Sheets Based on Condition of Another Cell
https://support.google.com/docs/thread/66647812/calculate-average-across-sheets-based-on-condition-of-another-cell?hl=en Aug 23, 2020 ... I am trying to calculate the average across multiple sheets, based on if another column meets a certain criteria. ... value in cell D1 (the P1 ...
Index Match based on criteria in two rows and one column - Google ...
https://support.google.com/docs/thread/230518206/index-match-based-on-criteria-in-two-rows-and-one-column?hl=en Aug 15, 2023 ... My expected return would than be any of the cell values that fall into the selection criteria. My index/match formula comes back with a #N/A ...
Complex VLookup using multiple criteria and between two dates ...
https://support.google.com/docs/thread/126929914/complex-vlookup-using-multiple-criteria-and-between-two-dates?hl=en Sep 20, 2021 ... ... row to a specific person based on the: PLACE. TYPE. GREATER THAN A ... match each other, and the TYPE is listed in the TYPE LIST, then ...
How to QUERY/INDEX+MATCH multiple rows of text from a merged ...
https://support.google.com/docs/thread/11089976/how-to-query-index-match-multiple-rows-of-text-from-a-merged-cell?hl=en Aug 1, 2019 ... ... depending on who I select from the Data Validated cell in column A. I've gotten it to work for the first row, as it changes accordingly based ...
MINIFS but will NOT return zeros if conditions are not met - Google ...
https://support.google.com/docs/thread/95153070/minifs-but-will-not-return-zeros-if-conditions-are-not-met?hl=en Jan 25, 2021 ... I'm looking for a way to get the min value in one column based on multiple criteria however I need it to NOT return 0 if one of criterias is not met.
Trying to get a true/false based on multiple variables in a sheet ...
https://support.google.com/docs/thread/18861523/trying-to-get-a-true-false-based-on-multiple-variables-in-a-sheet?hl=en Nov 7, 2019 ... I believe it would be an array function which I dont have much experience with. Pretty much I want: Where "Jeff" (column H) has true in (column ...