All Questions
3,347
questions
0
votes
2
answers
2k
views
Excel formula calculating working hours depending on shift start and shift end
2/6/23 3:00 PM (Start Date and Time)
12/7/23 8:00 PM (End Date and Time)
11:00 AM (Shift Start Time)
8:00 PM (Shift End Time)
with this data i want to calculate the working hours, Start Date and ...
0
votes
1
answer
65
views
Write a formula in a worksheet cell referencing cells in a different workbook
I am working with three Excel workbooks and a template.
I have a master (“Master”) workbook that has references to everything (using named ranges) and the VBA code to open the three other spreadsheets....
0
votes
3
answers
115
views
How to extract date using Excel
In an Excel column, there is a data entry that reads '21 Years 10 Months 019 Days ago.' Given that today is the 1st of November 2023, how can I determine the exact date represented by this entry?
Not ...
- 29
0
votes
1
answer
30
views
unexpected result of Excel formula
i have the following formula; =BYROW(SEQUENCE(30;;0,01;0,01);LAMBDA(n;MOD(n;0,03)))=0.
Excel returns
{FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, ...
- 39
-1
votes
1
answer
72
views
Copying unique numbers from one column to the another [closed]
I have a C column with the various 6-digit numbers "operator ID". Each operator is assigned to number of activities so their number will appear a couple of times in the C column. I need to ...
0
votes
1
answer
61
views
if data matches from list to data range in another column update cell in same row as matching data
I need to update the QTY number in column G "Quantity left in stock" (sheet is called Stock) when the item selected from the list in a different sheet column C (sheet is called Log) matches
...
1
vote
1
answer
57
views
Excel: How to color cells based on condition A = C and the sum of values in B is less than D?
Column A, starting from A1, contains the following values:
sasa
masa
sasa
masa
sasa
sasa
sasa
vasa
vasa
Column B, starting from B1, contains the following values:
2
3
4
5
6
4
1
1
2
Column C, starting ...
1
vote
1
answer
53
views
xlsxwriter: how formulas insert
I'm new to xlsxwriter, so maybe it's a problem of misunderstanding.
I write create a workbook with some worksheet. Al works fine.
Only: I'm not able to insert a correct formula.
My problem, as I ...
- 19
-2
votes
2
answers
221
views
How to find custom unique values in Excel?
I have the following values in Excel: {"Apple", "Orange", "Orange", "Banana", "Apple}.
If I run the Unique formula on this array, then it will return {&...
- 77
0
votes
0
answers
35
views
How do I use Index and Small in excel sheet
I have three sheets in excel one is supplier sheet and other two sheets are customer sheet. I want that when I update the supplier sheet so the data automatically copy to customer sheet as well. For ...
0
votes
0
answers
42
views
Need to get a total number of employees on schedule with 15 min intervals, but only the employees that end their shifts after midnight
I am making a work schedule to know how many agents I have every 15 minutes. I have the formula =SUMPRODUCT(--( E3>=B$3:B$47),--(E3<C$3:C$47)) which works great as my start times are in B3, my ...
- 1
-1
votes
1
answer
49
views
Excel formula look up
I have a list of names in cell C2:C50, some of which occur multiple times. I want to insert a formula in cell C51 which will look in the cells above and pull the name whose last occurance was the ...
1
vote
1
answer
130
views
Asking Excel to retrieve and match large amounts of data for me from another/same sheet
I have a population of animals. I want to calculate the age the mother of each individual had when that individual was born.
In my spreadsheet with data, I have (among other things I want to test) the ...
- 11
0
votes
1
answer
61
views
EXCEL replace values in sheet with value from another column
Im trying to replace values spread across a section of a worksheet with corresponding values in a column across from them.
For example...
A B C D E F G
-----------------------------
D1 ...
0
votes
1
answer
52
views
Paste formula in EXCEL through VBA
I've created the following VBA in EXCEL:
these Formulas convert a field for example 2022072610:22:40 in column J to:
Column K --> 26-07-2022 (dd-mm-yyyy)
Column L --> 10:22:40 ("[$-x-...
- 119