-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
excel to google sheets
-
N
Google Sheets Formula Help
I need some assistance with a formula for Google Sheets. The following formula works in Excel, but not in Google Sheets. I don’t believe the “Take” formula is in sheets. Any ideas on how to find what I’m looking for based on the example below? =TAKE(SORT(FILTER(C3:D10,B3:B10=G5),2),-1)- nrc0710
- Thread
- excel to google sheets formula help google sheets
- Replies: 3
- Forum: General Discussion & Other Applications
-
Log. Need to work on g.sheets
Hello everyone! I implore your help. I have a diet log for an office and looks like below. Now there's conditional Formatting to change the colors of the cells according to min and max values i had in column T. (calories, protein, sleep, water, steps, etc) Now the problem is that they need it...- Agnarr
- Thread
- conditional formatting excel to google sheets macro? vba?
- Replies: 0
- Forum: General Discussion & Other Applications
-
E
Form in Excel to add a row on another Sheet in Workbook as well as adding a row on on Google Sheets
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 =...- Excel_User_10k
- Thread
- excel to google sheets exceltogooglesheets google google sheets googlesheets vba
- Replies: 1
- Forum: Excel Questions
