About 1,475,731 results (3,802 milliseconds)
Index a column from Multiple Sheets - Google Docs Editors ...
https://support.google.com/docs/thread/273782408/index-a-column-from-multiple-sheets?hl=en May 10, 2024 ... I would just like to INDEX Column A from all 3 sheets into the MAIN sheet column A. For some reason i can manage to get data in there with UNIQUE or INDEX and ...
Using Index and Match function across multiple tabs in one sheet ...
https://support.google.com/docs/thread/68675547/using-index-and-match-function-across-multiple-tabs-in-one-sheet?hl=en Sep 2, 2020 ... I am trying to combine data from multiple tabs on a spreadsheet and have it match to one master tab based on same student id #.
Adding rows to multiple sheets - Google Docs Editors Community
https://support.google.com/docs/thread/247237250/adding-rows-to-multiple-sheets?hl=en Dec 6, 2023 ... In Excel, you can select multiple sheets/tabs to add a row in the ... const chSheets = Browser.inputBox("index #s to change, comma separated; 0= ...
help for MATCH-INDEX or VLOOKUP for multiple tabs/sheets ...
https://support.google.com/docs/thread/5845562/help-for-match-index-or-vlookup-for-multiple-tabs-sheets?hl=en May 10, 2019 ... each of the 7 other sheets uses an index-match formula to scan the MasterSheet for their employee name and then auto-fill its rows/columns with ...
Need the Sheet and Cell Address for the max value across multiple ...
https://support.google.com/docs/thread/9331320/need-the-sheet-and-cell-address-for-the-max-value-across-multiple-sheets-help?hl=en Jul 5, 2019 ... T7, I'd like it to tell me that. I have played with Address, Match, Cell, Index, and muchhhhh Googling. Closest I've come is an Excel discussion ...
Sort Multiple Sheets of Data at Once - Google Docs Editors Community
https://support.google.com/docs/thread/96514281/sort-multiple-sheets-of-data-at-once?hl=en Feb 3, 2021 ... Solving the Dynamic / Static Data Alignment challenge using Alignment Index Numbers · Post back if and when you have questions. Post back if it ...
I need to create a master sheet from multiple other sheets which ...
https://support.google.com/docs/thread/234782371/i-need-to-create-a-master-sheet-from-multiple-other-sheets-which-then-have-multiple-tabs?hl=en Sep 13, 2023 ... I need to create a master sheet that pulls the most recent entry from multiple tabs sheets within multiple spreadsheets to create one unified view.
How to use index of getCharts() with multiple charts in different ...
https://support.google.com/docs/thread/31611891/how-to-use-index-of-getcharts-with-multiple-charts-in-different-sheets?hl=en Feb 27, 2020 ... I have a form response spreadsheet with multiple sheets: in every sheet answers are organized by query following a specific parameter, and in every sheet there ...
Quick way to find data across multiple sheets? - Google Docs ...
https://support.google.com/docs/thread/222965229/quick-way-to-find-data-across-multiple-sheets?hl=en Jun 27, 2023 ... C2 is the Computer Names. Responses!A2-Z177 are all of the cells from the survey responses. Not sure if the index is correct, I also tried ...
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 ... Basically, I have a database on the first sheet labelled "Units" that has all the base information for each character, and I'd like for that ...
INDEX MATCH MATCH - getting data from another spreadsheet ...
https://support.google.com/docs/thread/91909667/index-match-match-getting-data-from-another-spreadsheet?hl=en Jan 4, 2021 ... I want to write a function that will look it up in the Clients sheet and return the Date value. ( and then do the same for Client and Charge column).
Multiple Links in One Google Sheets Cell - Google Workspace ...
https://support.google.com/a/thread/45130142/multiple-links-in-one-google-sheets-cell?hl=en May 8, 2020 ... I've tried "vlookup" and "index-match" and these don't work either. Can someone help me? If I can get this to work, it will be a game changer.
Countifs across multiple workbooks - Google Docs Editors Community
https://support.google.com/docs/thread/235659792/countifs-across-multiple-workbooks?hl=en Sep 19, 2023 ... Can I do a countifs with multiple criteria across multiple workbooks? ... "&ra),l,max(index(row(r)*iferror(r<>""))),d,filter(r,row(r)<=l),r_ ...
Count text use in column from multiple sheets - Google Docs Editors ...
https://support.google.com/docs/thread/109705217/count-text-use-in-column-from-multiple-sheets?hl=en May 13, 2021 ... If I can't get it to work, I can get the formula to work in Excel and will just have to switch to sharing an excel sheet vs the google drive.
how do I populate a cell from another sheet if a drop down menu ...
https://support.google.com/docs/thread/93511424/how-do-i-populate-a-cell-from-another-sheet-if-a-drop-down-menu-selection-is-made-on-that-sheet?hl=en Jan 14, 2021 ... I would think it would be a if/match/index ... I'm not sure if some of what I recommend will work properly in all cases if you are using an Excel ...
How to hide columns on multiple sheets in a workbook - Google ...
https://support.google.com/docs/thread/119851005/how-to-hide-columns-on-multiple-sheets-in-a-workbook?hl=en Aug 3, 2021 ... See a youtube link to how it is done on Excel but not sure how it is done with Script editor. ... if (!index || value !== 1 + numbers[index - 1]) ...
Pick which rows or columns INDEX returns from an array/range ...
https://support.google.com/docs/thread/152638312/pick-which-rows-or-columns-index-returns-from-an-array-range?hl=en Feb 28, 2022 ... Ideally I'd love to find a way of doing it that doesn't break if I have to create a version for Excel / outside of Google Sheets, so if anybody ...
I need the excel having multiple sheets but it was not done help me ...
https://groups.google.com/g/django-users/c/JTTbBEbHkqg Apr 5, 2025 ... # Use ExcelWriter to combine multiple sheets into a single Excel file ... df_contractor.to_excel(writer, sheet_name='Contractor Template', index= ...
Importrange in a index/match function - Google Docs Editors ...
https://support.google.com/docs/thread/12657560/importrange-in-a-index-match-function?hl=en Aug 23, 2019 ... Is there a formula so that I can scan multiple sheets from the other imported doc? ... spreadsheet and then use index/match on that table.
Lookup Matching Value Across Multiple Worksheets And Return ...
https://support.google.com/docs/thread/43383714/lookup-matching-value-across-multiple-worksheets-and-return-sheet-name?hl=en Apr 29, 2020 ... ... worksheet, column F) is also found in one of the other worksheets. I found a solution that is partially working: =ArrayFormula(INDEX ...