4,652 questions
0
votes
2
answers
108
views
Only show one sheet
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 ...
- 15
0
votes
0
answers
21
views
How to format date and time when using the left and right function [duplicate]
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 ...
- 1
1
vote
1
answer
73
views
How to sort data of Sheet1 using a Combobox with values from Sheet2?
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 ...
- 749
0
votes
1
answer
53
views
VBA - Fetch Sheet Names and Return as Array - Compile Error: Type mismatch [closed]
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 ...
0
votes
2
answers
80
views
Googlesheets SUMPRODUCT with position
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="...
-3
votes
1
answer
60
views
(Google Sheets) How should I pull data from a sheet into another sheet automatically
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 ...
- 1
-1
votes
3
answers
79
views
display 'Received" if a row contains referenced loan number and doc type
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 ...
- 25
2
votes
2
answers
121
views
How to get the sheet index in Google Sheets (i.e. Excel's `SHEET()` function)
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 ...
- 160
1
vote
1
answer
48
views
In Google Sheet parse cell input with asterisks to include values in a SUMIFS equation
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,"<...
- 33
2
votes
2
answers
75
views
Need to turn a sumifs formula into an array
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, ...
- 31
0
votes
0
answers
70
views
Custom date filter in Odoo Dashboard module
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 ...
- 21
0
votes
0
answers
33
views
Vaadin Spreadsheet: performance problem with SpreadsheetFilterTable
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, ...
- 105
1
vote
1
answer
95
views
Can I use an Array with a LONG formula that has "IFNA, TRANSPOSE, & FILTER" in it?
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 ...
- 31
0
votes
0
answers
28
views
Is there a formula to get row and column of range end in openoffice calc?
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("...
-4
votes
1
answer
84
views
Query using Pivot table in google sheets
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.
=...
- 1