Skip to main content
4,612 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-3 votes
2 answers
74 views

is there any formula which will help me split randomly a dynamic list of names into 6 different groups?. I would like each group to have as equal as possible amount of names. Here is a google sheet ...
RyuukuS's user avatar
  • 9
0 votes
1 answer
91 views

I'm using an app called OneUp to schedule social media posts, and trying to set up a google sheet (here's their page on that) to bulk schedule. Right now what I have (simplified for clarity) is ...
Harlan Adobe's user avatar
  • 3
0 votes
1 answer
104 views

I was wondering if there is any way (formulas) that can change a cell's color when we are approaching the date previously entered in a cell. What I am looking for is a way to notify myself of upcoming ...
Nicholas's user avatar
  • 1
3 votes
7 answers
260 views

I want to use a spreadsheet to take a column of rankings and turning into a pairwise matrix. Suppose I had a column like so: Candidate Ranking A 1 B 5 C 3 D 2 E 4 I want to create a 5x5 matrix where ...
James Cleveland-Tran's user avatar
  • 30
0 votes
1 answer
81 views

I have a component which is having a spreadsheet and tinymc: <div> TinyMC control which is used in a library </div> <div> Spreadsheet </div> Both controls are using global ...
Ramesh Rajendran's user avatar
  • 38.9k
0 votes
1 answer
41 views

So i have this Model namely Questionnaire in models.py file of a Django project class Questionnaire(models.Model): title = models.CharField(max_length=200) description = models.TextField(blank=...
raza hussain's user avatar
  • 11
0 votes
1 answer
58 views

I'm looking to export a logbook of mine to paper. The logbook consists of entries of hours based on dates that continue row by row. I need to export these entries through printing with each page ...
Anthony Galushka's user avatar
  • 3
0 votes
1 answer
65 views

I'm trying to create a table with multiple tabs, and I can't find an example on how to add also the columns names. How should the structure of the data look like? Here is an example of the data ...
user2976237's user avatar
  • 5
-4 votes
2 answers
88 views

I am using Nextcloud Forms to have students write comments. They use the same form every week, and it all gets put into one big spreadsheet. (There are 101 students.) Because of the simple nature of ...
Rachel T's user avatar
  • 7
1 vote
1 answer
102 views

I am trying to create a Return on investment formula down to the month, the tricky part about this is that my data is done in terms of years Here is a sample data, Yearly yield decreases by 0.4% every ...
Jake quin's user avatar
  • 752
0 votes
3 answers
147 views

I need to total multiple criterion amongst separate columns in a spreadsheet. I attempted the following syntax... COUNTIFS(criteria_range1, criterion1, criteria_range2, criterion2, ...) as such... ...
ZachyPooNappy91's user avatar
  • 1
0 votes
1 answer
385 views

I'm trying to pull price data from a 'Pricing' tab into my 'Inventory' tab using VLOOKUP. I want to match product IDs and return their prices, but I’m not sure how to structure the formula when the ...
Drew Ashley's user avatar
  • 1
0 votes
0 answers
20 views

I have an excel file with multiple sheets and macros to pull data from various weblinks and csv files and compile it into a worksheet. What i want to is edit the end of the macro so that it selects a ...
Benjamin Calvert's user avatar
  • 11
0 votes
2 answers
123 views

In my workbook, I have three possible sheets which can start my code (Site1, Site2, Site3). They all have the following code to kick off the process. Option Explicit ' Script intended to run upon ...
mkcoehoorn's user avatar
  • 25
0 votes
0 answers
35 views

I tried using the left and right function to extract the date and time from the timestamp column below but keep getting a format not related to a date or time. I tried changing the format but same ...
Nneka's user avatar
  • 1
1 vote
1 answer
98 views

I have here 2 sheets. 1 sheet is for the main data. The other sheet is for the Teams of the Name entries. Sheet1 (Blanks are on purpose - to see outcome as well if there are blanks) A B C Name Date ...
Shiela's user avatar
  • 785
-1 votes
1 answer
72 views

MOTIVATION I am trying to fetch sheetnames of an excel file with vba ERROR Compile Error: Type mismatch RELATED LINKS REF1: Return array from function in VBA REF2: Excel VBA - Creating array of ...
Tugalsan Karabacak's user avatar
  • 753
0 votes
2 answers
87 views

PORTION NETO PROPORTION db 05;db 34 34140 0,6;0,4 db 05 10000 1 db 03;db 04;db 05 10000 0,7;0,1;0,2 db 04;db 05 5000 0,4;0,6 I have a sample file like the above table. I need a =SUMPRODUCT(A2:A="...
Fernando Arns Derg's user avatar
  • 3
-3 votes
1 answer
822 views

so this is just a steps for this project. I will explain the full project first, and maybe you can suggest another solution. Basically, I have a template sheet for my job (Staffing Sheet). The sheet ...
I C's user avatar
  • 1
-1 votes
3 answers
95 views

I have an Excel sheet that lists all the documents that have been received. Loan number Last Name Doc Type 354 Smith Title 354 Smith Deed 354 Smith Mortgage 765 Wilson Mortgage 765 Wilson Deed I'm ...
Smoak's user avatar
  • 25
1 vote
2 answers
188 views

TL;DR: I am looking for the equivalent of Excel's SHEET() function for finding out the numerical index of the current sheet in Google Sheets. If the sheet is the first in the list of sheets, then a ...
Brian's user avatar
  • 150
1 vote
1 answer
73 views

This equation works as expected to sum values from row 3 based on their relationship to a series of dates listed in row 1: =SUMIFS(I3:DV3, I$1:DV$1,">="&today()-86, I$1:DV$1,"<...
user2107656's user avatar
  • 33
2 votes
2 answers
93 views

Can someone please help me to turn this formula: =ROUND(if($B7="","",sumifs(Expenses!$B:$B,Expenses!$E:$E,$B7))) into an array with this column title Total (12 months)? Basically, ...
dgDG's user avatar
  • 31
0 votes
0 answers
166 views

Premise: I am a programmer, but not with Python. I worked only two times with Odoo. A client of mine uses Odoo (a choice I didn't recommend, because I don't understand it :) ), and asked me to try ...
Dulmax's user avatar
  • 21
0 votes
0 answers
48 views

I am trying integrating the Spreadsheet component of Vaadin Pro into our web app. The project is based on SpringBoot 3.2.2 and Vaadin 24.2.0. The idea is, to load out a number entries from database, ...
Vincent's user avatar
  • 125
1 vote
1 answer
127 views

The overall goal of my project is to allow the user to add the "CATEGORY" (column B) and the "SUB-CATEGORY" (column C) to the "DESCRIPTION" (column A) for each row with ...
dgDG's user avatar
  • 31
0 votes
0 answers
54 views

I am using OpenOffice Calc. I have a text which is address range, indirectly used for my calculations. My text is "C5:K5". It may vary at times. I use ROW("C5:K5") and COLUMN("...
Chalam S Chetti's user avatar
  • 51
-4 votes
1 answer
107 views

I am trying to query a table in Google Sheets with a pivot to achieve what is in the screenshots below. My formula just keeps returning errors, and I have tried various combinations without success. =...
E_T's user avatar
  • 1
0 votes
2 answers
94 views

I am trying to make a weekly workbook for my team to see work coverage 3-4 weeks in advance. I would like the name of the new tab to be for the week ending on Saturday. It would copy from the tab made ...
638 sleepers's user avatar
  • 1
0 votes
1 answer
296 views

I want to create an auto-number for each row in my google sheet following the logic below: it takes the sheet number from A1 e.g. 8 generates sequential table header numbers from that sheet number ...
E_T's user avatar
  • 1
0 votes
0 answers
24 views

I'm using spreadsheet feature from tabulator.js. I'd like to align data as in real spreadsheet (numbers to the right, text and dates to the left). Is there any way to do it with that library? My code ...
Kornelia Kobiela's user avatar
  • 487
0 votes
2 answers
123 views

Here is a link (editable) to a detailed example of what I am stuck with: there is the input, the expected result and comments on the reasoning. Basically, let's say I have in a column range a list of ...
Dreamk33's user avatar
  • 247
0 votes
2 answers
103 views

how to import data from one google sheet to another google sheet without appscript hello Thank you for your complete guidance. I have two separate google sheets, the first sheet records data from the ...
Sajjad Jokar's user avatar
  • 3
0 votes
1 answer
68 views

Not an excel expert here. I want to get all of the Hours for each person and add them up. Just like the image.J4 suppose to get all Jane adjacent hours then add them up and so on. I saw index and ...
murphychoo's user avatar
  • 21
0 votes
1 answer
123 views

I have a LibreOffice Spreadsheet and I want to create a sum over values in a different tab. So the following content does work and gives me as result the number 176: =SUM(Time2025.V4:V34) However, ...
Alex's user avatar
  • 45.1k
0 votes
0 answers
44 views

I am trying to automate a sheet I will get twice a month. Basically, it is sorted by a category, which is a singular letter. I have it able to sort the first table of data into separate sheets based ...
Anastasia's user avatar
  • 1
1 vote
0 answers
71 views

I have an Excel spreadsheet called "my_data". I can recreate the spreadsheet in R as follows: library(tibble); library(readxl) tibble(x = c(1L, 2L, 3L), y = c("A", "B", &...
luciano's user avatar
  • 14k
1 vote
3 answers
155 views

I have data related to Product Name, Tool Name, and ID Tool with the following data example: Product Name Tool Name ID Tool (Standard) ID Tool (Alternative 1) ID Tool (Alternative 2) Product A Tool A1 ...
Anna's user avatar
  • 71
-1 votes
1 answer
66 views

I have a public Google spreadsheet. I would like to convert it to JSON by any means possible. I have tried the following and several more, but they all fail. I am open to any means to convert a Google ...
5260452's user avatar
  • 11.7k
-1 votes
2 answers
164 views

I have two sheets in the same spreadsheet: A "database" with a list of events, each row containing infos like the date, event name & assignee A "view" where I want to display ...
Mickäel A.'s user avatar
  • 9,485
2 votes
1 answer
29 views

Hi everybody, I'm new to Google Spreadsheets and I found a lot of tips online but some things won't work at all. Every person to the left (A9:A23) has a particular race schedule and this sheet is a ...
Maxim Duquesne's user avatar
  • 21
0 votes
2 answers
115 views

I have two columns in a google sheets tab, a group column and an item column. Each entry in the item column is unique and only occurs in one group. GROUP ITEM A X A Y A Z B I B J B K C P C Q C R I ...
sjh3192's user avatar
  • 3
0 votes
0 answers
71 views

We have an ODS file with two spreadsheets. (Picture 1) We are able to use ‘Find All’ to locate cells containing the string ‘Steve’. (Picture 2) However, we are unable to copy them. Because they are on ...
Denix's user avatar
  • 522
0 votes
1 answer
184 views

I have a spreadsheet with some calculations in it, and I want to make a plot of what happens to one cell's value as another changes (from 0 to 100). I have been searching for about 45 minutes and cant ...
yuuuu's user avatar
  • 758
0 votes
1 answer
76 views

Let me elaborate. I made a post before asking something similar. In that question, I asked how to delete duplicates if they matches on both sheets in excel. However, now I need to figure out how to ...
DriveShaft1234's user avatar
  • 13
0 votes
1 answer
87 views

I have data related to product code, product name, and item name with the following data example: Product Code Product Name Item Name 01 A001 Primary - Primary Book Primary Fruit Primary - 01 A002 ...
Anna's user avatar
  • 71
0 votes
1 answer
110 views

I'm trying to unnest data in one column separated by " | ". The rest of the columns should "follow" the unnested logic from that column. I've made a sample spreadsheet to summarise ...
Damien 's user avatar
  • 403
-1 votes
1 answer
60 views

I'm currently using google sheets to extract biographies from instagram usernames and I'm doing it for around 2500-3000 profiles a day and it takes around 18-20 hours which is a lot of time. When I ...
Carlo Locatelli's user avatar
  • 15
0 votes
1 answer
63 views

I have a cell in a Google Sheet containing a single word. Let's say that word is TRILLION. I want to obtain the set of letters in the word, in order of first appearance. For that word, the answer ...
Peter Hosey's user avatar
  • 96.5k
1 vote
1 answer
98 views

I want to write the keys and values of a dictionary to cells in an Excel worksheet called dash. However, when I run the code below, it only writes nome1 in column 20 without its corresponding value. ...
João Paulo's user avatar
  • 11

1
2 3 4 5
…
93