About 1,916,717 results (1,554 milliseconds)
How to select every nth cell in a column - Google Docs Editors ...
https://support.google.com/docs/thread/38892305/how-to-select-every-nth-cell-in-a-column?hl=en Apr 9, 2020 ... Filter Column B (select column B ->Data menu -> Create a filter). Then use the below formula. =mod(row(A1),5)=0.
[SOLVED] Copying down formulas that skip rows - Google Docs ...
https://support.google.com/docs/thread/216050474/solved-copying-down-formulas-that-skip-rows?hl=en May 16, 2023 ... how it works for the odd rows. (ROW()-1)/2+4. (5-1)/2+4. (4)/2+4. 2+4. 6. Now copy the range B4:B5, then select the range below B4:B5, and click ...
Formula to add together all even or odd cells in a column. - Google ...
https://support.google.com/docs/thread/56251575/formula-to-add-together-all-even-or-odd-cells-in-a-column?hl=en Jun 29, 2020 ... I am looking for a specific formula I have not been able to create. I need the sum of every number in an odd row in the column, starting in row ...
Alternating colour rows based on cell value - Google Docs Editors ...
https://support.google.com/docs/thread/161495456/alternating-colour-rows-based-on-cell-value?hl=en Apr 27, 2022 ... Custom Formula is... Formula: =ISODD(MATCH($L4, UNIQUE($L$4:$L4),0)). Format: <format of your choice>. That will highlight the first Zone and ...
Import certain columns from one sheet to another. - Google Docs ...
https://support.google.com/docs/thread/9516260/import-certain-columns-from-one-sheet-to-another?hl=en Jul 8, 2019 ... ... formula in all rows. Formula is working. but if you have a fast formula then please guide me. =QUERY({Package!AA2:AB498}, "SELECT Col2 WHERE ...
Alternate Row Colours with Conditional Formatting if cell is not ...
https://support.google.com/docs/thread/88738056/alternate-row-colours-with-conditional-formatting-if-cell-is-not-empty?hl=en Dec 15, 2020 ... I found this question: Alternate Row Color For Non-Empty Rows, answered by mchall which recommends the following formula: =(ISEVEN(ROW ...
Alternating Colours Not Working - Google Docs Editors Community
https://support.google.com/docs/thread/4056108/alternating-colours-not-working?hl=en Apr 12, 2019 ... ... alternating background colors to a range that already has alternating background colors." I've tried only selecting the rows underneath the ...
How would I create alternating color patterns for my spreadsheet ...
https://support.google.com/docs/thread/2533417/how-would-i-create-alternating-color-patterns-for-my-spreadsheet?hl=en Mar 16, 2019 ... Another fun alternative is custom formula. = ... rows with alternating colors. T. Tech Muzz. Jun ... Select Fill color icon on tool bar, at ...
Conditional formatting & alternating colors - Google Docs Editors ...
https://support.google.com/docs/thread/26126878/conditional-formatting-alternating-colors?hl=en Jan 19, 2020 ... Select the range this is to be applied to. Step 2: Select the Custom formula is.... option and enter the following Custome formula. =(mod(row ...
Trying to get formula to repeat every third row with the referenced ...
https://support.google.com/docs/thread/209345958/trying-to-get-formula-to-repeat-every-third-row-with-the-referenced-cell-increasing-once-each-time?hl=en Apr 4, 2023 ... If the data was on a sheet called "Data" then the formula would just be =Data!$A1 for the first row, then 2 empty rows, then =Data!$A2, repeat ...
How to auto-fill with reference changing according to a specific ...
https://support.google.com/docs/thread/169693916/how-to-auto-fill-with-reference-changing-according-to-a-specific-pattern?hl=en Jul 3, 2022 ... ... alternate cells. Thank you in advance. https://docs ... Note that I also used the same approach to copy over the date formulas in Row 1.
A quicker alternative to a query formula - Google Docs Editors ...
https://support.google.com/docs/thread/2248432/a-quicker-alternative-to-a-query-formula?hl=en Mar 11, 2019 ... This kind of query works fine when it's a small amount of data but slows right down with 1000's of rows. Any suggestions for a faster alternative would be much ...
feeding a sheet with query function but only selecting specific ...
https://support.google.com/docs/thread/192163017/feeding-a-sheet-with-query-function-but-only-selecting-specific-columns-and-rows?hl=en Dec 9, 2022 ... feeding a sheet with query function but only selecting specific columns and rows. I'm using this formula =query(importrange(B1,"Nov!A9:H")," ...
Is there a way to delete multiple blank rows all at once without doing ...
https://support.google.com/docs/thread/199083324/is-there-a-way-to-delete-multiple-blank-rows-all-at-once-without-doing-them-in-groups?hl=en Jan 26, 2023 ... Click "Clear" to clear all values, then click (Blanks) so that it is the only item checked; Click OK; Select all empty rows with your mouse, ...
An arrayformula alternative for copying down the filter function ...
https://support.google.com/docs/thread/5300735/an-arrayformula-alternative-for-copying-down-the-filter-function?hl=en May 2, 2019 ... ... ROW(F3:F),"<="&ROW(F3:F))},"Select Col1, max(Col2) where Col1 is not null group by Col1 Pivot Col3"),"Select * offset 1",0),{2,3,4,5},0 ...
Conditional formatting cells (which contain numbers & text) based ...
https://support.google.com/docs/thread/5485364/conditional-formatting-cells-which-contain-numbers-text-based-odd-or-even-numbers?hl=en May 4, 2019 ... Note that I am not looking to alternate row colors. I tried using Conditional formatting > Custom Formula is > with formula ... Select "Get ...
Why does it select all cells in a sheet when I switch to it? - Google ...
https://support.google.com/docs/thread/61476310/why-does-it-select-all-cells-in-a-sheet-when-i-switch-to-it?hl=en Jul 27, 2020 ... ... alternate color range. ... Try implementing the zebra stripes with a conditional formatting rule using a custom formula like =iseven(row()) .
How to set custom view filter columns in Google Sheets? - Google ...
https://support.google.com/docs/thread/2266784/how-to-set-custom-view-filter-columns-in-google-sheets?hl=en Mar 12, 2019 ... ... rows. I have ... If you try to type a value into a cell that contains the output of a formula, you either overwrite or break the formula.
Using the IMPORTRANGE function when cell on one sheet meets ...
https://support.google.com/docs/thread/149650374/using-the-importrange-function-when-cell-on-one-sheet-meets-criteria-of-cell-in-another-sheet?hl=en Feb 6, 2022 ... The formula looks up the sheet name for the given date and inserts it into the Importrange function. The query limits the import range to rows ...
Alternating Colors Don't Work; Neither Does Conditional Formatting ...
https://support.google.com/docs/thread/111796789/alternating-colors-don-t-work-neither-does-conditional-formatting?hl=en May 30, 2021 ... I think you have a merged cell, spanning two rows, in your first column. It seems that your whole row across is perhaps merged cells from two ...