google sheets

In excel, I can create a table and find the first and last row of said table with functions like =min(row(table1)), =max(row(table1)). I'm trying to emulate the functionality in google sheets and I thought a named range would be the appropriate way for this. For first row, this works...

I am trying to use MATCH and INDEX to improve performance on a google sheet that has way too many XLOOKUP functions. I have a helper column (DH) that lists the matching ROW I need from the Visibility sheet. This formula returns the expected result from column 9 on the Visibility sheet, where...

How to return the "Ship From" in Cell B2 based from the data in another tab with a substring criteria in Col A (currently listed in Col E/F)

Hello, What should be the formula to use in C3 in order to look up for the last non-blank above A3? In Col D is the desired result

Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...

This question is for Google Sheets. I'm asking two questions in one post, both are related to the same thing. Is there a way we can use formulas like in the picture below, to achieve the results, instead of hardcoding the ranges in the charts setup? It is also crossposted here, no answers so...

Hi all, I'm trying to work on this last bit of my Weekly Meal Planner. I have multiple sheets within this one document and it would be easiest if I gave the link to the document itself rather than posting an image. Weekly Meal Planner In the sheet labeled Grocery List, in the fourth column I...

I have a Macro that is activated by a button in my Sheets. It does exactly what I want it to do separated, but when I tried to combine both functions (Autofill & Sort), it doesn't finish the sort. My guess is that it is doing it all simultaneously so it's sorting before the autofill calculation...

I'm trying to assist my daughter who has asked me how to get raw data categorized by category and month. Here's a sample. Given: Given a long list of data with about 35 categories in columns A-C, how do I get a monthly table like on the right side? Thanks in advance.

Hi, I am working with a spreadsheet that is heavily formula driven and I have a feeling that what I am about to ask is impossible. So currently we are working with GSheets on this. So the formula that I really would like resolved is multi layered. In this example I will use 5 sheets (however...

I have an Excel file. In which I put some VBA. But I need to do the same in the google sheets. But I need to convert the VBA to appscipt. The Excel file link is below. What will be the appscript code? Please help me. Excel File

Hi, The following formula works in excel but not in Google Sheets. How do I modify to work in Google Sheets: =LOOKUP(REPT("z",255),CHOOSE({1,2,3},"", LOOKUP(999999999999999,SEARCH(abbreviations!$A$1:$JZ$1,'Invoice Insert'!F110),abbreviations!$A$3:$JZ$3))) I basically want to search a range...

Hi, I have a list of bookings from accounts and would like to select a month, year, and account name (B2, B3, B4) and see the total revenue from that account for the selected month/year in D2. What is the best way to go about this? Sample spreadsheet link: Test Spreadsheet

Using Google Sheets. Column A contains a list of products. That list is imported from outside Google Sheets (Shopify). The list constantly changes as new products get added or removed. When products are added they don't necessarily get added to the bottom, they get added anywhere on the list so...

Hello everyone, I am sharing this shared sheet with you in order to find a function/script to add as follow: Whenever a user makes a change in the column J, his email/name will be written in relative column K. here's the google sheet MySheet

Hello, We have a list of data that has multiple entries, but many of them have the same member ID. The data in every row is different; only the member ID is common. We have created different Google Sheets for members, and when we add the data with the member ID to the main sheet, it should...

I have a problem with Google Sheets Highlighting custom function and could use your help. I have 2 sheets - ORIGINAL & RESULTS RESULTS - contain the long list of company names in column A ORIGINAL - contains list of PEOPLE who work for companies ORIGINAL - has conditional formatting for all...

Hi all, I saw a YT video () that explains how to sync Excel with Google Sheets so that when a Cell value is changed, it will update on Google Sheets to do the same. Firstly, I followed the video but it doesn't seem to work for me where a 'test' is done that they type something in to A1, for...

Hii, I am really at a loss right now q.q I'm super new to Excel and (in this case) Google Sheets so I don't have any clue about macros and how to program them. Here's my problem: I want to add a command button that, when clicked, adds a calue to the cell BELOW it. Thing is, I can't for the...

Sub RectangleRoundedCorners2_Click() Dim myRow As ListRow Dim cell As Range, DataEntry As Range Dim i As Long Sheets("Sales MTD").Unprotect Password:="password" With ThisWorkbook.Worksheets("Sales MTD").ListObjects("Submitted_Sales") Set myRow =...