About 1,384,505 results (1,901 milliseconds)
Too many rows displaying on spreadsheet
https://groups.google.com/g/microsoft.public.mac.office.excel/c/vNOEt-EJbmw Apr 20, 2010 ... To really "empty" that cell, you need to use Edit>Clear>All... 2) Excel maintains a "Last used cell" range in each worksheet. ... To Find the Last ...
C#: get last used column in row
https://groups.google.com/g/exceldna/c/E1fe5Qi8gGg Apr 13, 2016 ... I'm new to Excel-Dna and want to create a UDF using the C API that returns the number of the last used column in the row selected by the user.
What's the correct way to indicate an "endless" range? - Google ...
https://support.google.com/docs/thread/118059590/what-s-the-correct-way-to-indicate-an-endless-range?hl=en Jul 21, 2021 ... ... bottom of column B, no matter how many rows get added. And C5:5 includes all of row 5, starting in column C, no matter how many columns get ...
How to select a range, from the first non-blank cell to last non-blank ...
https://support.google.com/docs/thread/62014428/how-to-select-a-range-from-the-first-non-blank-cell-to-last-non-blank-cell?hl=en Jul 30, 2020 ... I know that this is possible using VBA on Excel, but is there any ... Will return all the cells in column A that are not blank. You can ...
I'm getting #ref when deleting rows. Is there a way to avoid this ...
https://support.google.com/docs/thread/84417645/i-m-getting-ref-when-deleting-rows-is-there-a-way-to-avoid-this?hl=en Nov 21, 2020 ... There is 2 tabs at the bottom, one for the schedule and one for formulas & calculations. If my Manager deletes a row on the schedule tab, it ...
Move Row to Bottom based on Status of cell - Google Docs Editors ...
https://support.google.com/docs/thread/146722062/move-row-to-bottom-based-on-status-of-cell?hl=en Jan 19, 2022 ... You cannot get a permanent timestamp with a spreadsheet formula, even with iterative calculation or a custom function, because formula results ...
Google sheet macro - complete status moves row to another tab and ...
https://support.google.com/docs/thread/28381517/google-sheet-macro-complete-status-moves-row-to-another-tab-and-clears-certain-cells-in-current?hl=en Feb 11, 2020 ... I cannot find enough help or get anything to work when trying to change my excel VBA code to be java script language - like I say very new to ...
How to get last row using Excel DNA and C#
https://groups.google.com/g/exceldna/c/Pm9DDkceVIc May 5, 2017 ... I have a VBA code that I am moving to C#. For one of my scenario I have to identify last row number for column E , so that I can run loop for each row and read ...
excel macro VBA that sums between a known cell ... - Google Answers
http://answers.google.com/answers/threadview/id/750698.html Jul 29, 2006 ... I then have the macro sort the data by column P which will always sends the "Z" to the bottom where I want the sum formula placed. Lastly, I use ...
Help with Google Sheets Macro to Insert Row based on Value ...
https://support.google.com/docs/thread/176518794/help-with-google-sheets-macro-to-insert-row-based-on-value?hl=en Aug 24, 2022 ... It is sorted so that all the Yes's are on the top and No's on the bottom. I want to write a script to find the First Row on Column I that ...
Create new row with functions from previous row - Google Docs ...
https://support.google.com/docs/thread/108645504/create-new-row-with-functions-from-previous-row?hl=en May 4, 2021 ... That way, there is always a blank row above the highest row (row 5) you might select to "insert 1 above". Also, you cleaned up the merged cells, ...
Always Use row 2 to enter data, once enter is pressed on column D ...
https://support.google.com/docs/thread/153347658/always-use-row-2-to-enter-data-once-enter-is-pressed-on-column-d-data-moves-to-row-3?hl=en Mar 3, 2022 ... Could not find any way of doing this in google sheets, I have the VB for excel and cannot convert. Anyone have a suggestion on how to ...
Using a drop down list to change values in the cell next to it - Google ...
https://support.google.com/docs/thread/221341359/using-a-drop-down-list-to-change-values-in-the-cell-next-to-it?hl=en Jun 17, 2023 ... ... row. A more typical application than used for you, would be to find the Sum of the values on each row, something that was difficult before ...
Get range updated according to last row - Google Docs Editors ...
https://support.google.com/docs/thread/204747736/get-range-updated-according-to-last-row?hl=en Mar 5, 2023 ... I think about of setting a formula in script for cell B1 - Sheet1 that takes data from column A - Sheet Data. However, the difficulty is that I ...
Selecting cell range while having a filter on? - Google Docs Editors ...
https://support.google.com/docs/thread/95171533/selecting-cell-range-while-having-a-filter-on?hl=en Jan 27, 2021 ... ... used a filter to quickly access some problematic values. ... I changed it in bulk by dragging a cell range to a neighboring column and filling the ...
Getting color codes of font or background color from cell in google ...
https://support.google.com/docs/thread/147420647/getting-color-codes-of-font-or-background-color-from-cell-in-google-sheets?hl=en Jan 24, 2022 ... I managed to implement my own little function in excel where I could get the font color code from a cell. ... I used an old Excel4 macro function, ...
Vlookup, trying to look up from bottom to top. (to return the most ...
https://support.google.com/docs/thread/184302266/vlookup-trying-to-look-up-from-bottom-to-top-to-return-the-most-recent-entered-values?hl=en Oct 16, 2022 ... VLOOKUP will give you the results of the first match found from top to bottom. In order to get the "lower" values of your results, you will need to use SORT.
how to lock or protect cells after data entry or input - Google Docs ...
https://support.google.com/docs/thread/66826933/how-to-lock-or-protect-cells-after-data-entry-or-input?hl=en Aug 24, 2020 ... I saw that there may be a script that may help to deal with this. I know that it's possible in Excel, but I need to have these spreadsheets ...
Index Function Not Working. Returning Blanks - Google Docs ...
https://support.google.com/docs/thread/36106992/index-function-not-working-returning-blanks?hl=en Mar 27, 2020 ... There are many ways to find the last non-blank number in a cell ... ... The max of these results is then used for the indexing of the latest ...
Easy way to insert current date+time into a Sheets cell * on Android ...
https://support.google.com/docs/thread/178172581/easy-way-to-insert-current-date-time-into-a-sheets-cell-on-android-phone?hl=en Sep 6, 2022 ... ... Excel, and instantly have the current date or time entered. I don ... step 2, select the date and time in the bottom of screen, and copy it.