All Questions
3,348
questions
-2
votes
4
answers
248
views
How to convert text string (d h m s) to time format in excel
I have a column of data with the below format and need to convert it to a time format by hours to use in calculations and filtering like hh:mm for the first entry, no need for seconds
1d 8h 8m 23sm, ...
0
votes
1
answer
131
views
Excel sum formula but with Criteria from multiple tables and columns
I have 3 Sheets / Tables in my Excel...
Table 1 (Master Stock):
Table 2 (SubLocation Rules):
Table 3 (Product Stock Summarize):
The goal in table 3 is To sum the Product Stock on Table 1 but with ...
0
votes
0
answers
33
views
xlookup to differentiate value "x" and value "x o" and return max date
I've an excel spread sheet that is looking through a list of names. Many repeat.
But to differentiate what a person has done, a " o" is added after there name at points.
I need the max date ...
0
votes
2
answers
54
views
IF Function 2 outcomes
I have a meeting reading sheet with opening and closing readings where I have a simple formula subtracting the closing from the opening to give a consumption reading. I need to add a purchases column ...
0
votes
1
answer
126
views
Excel Dynamic Search Formula
I am attempting to create a search function without using VBA and just using formulas for a contacts list. Any clarification on the breakdown of the formula would also help as I am new to using excel ...
1
vote
1
answer
165
views
WORKDAY.INTL not skipping holidays
There's clearly a mistake that I've made that I can't seem to fix. I'm making a table to outline dates for product information (as per screenshot)
My current formula im working with is
=TEXT(WORKDAY....
0
votes
1
answer
1k
views
Formula2 vs Formula in vba [duplicate]
I am using vba to edit the value of cells in excel. When i use the macro recorder, I see that excel is populating using this:
range("E10").select
activecell.formula2R1C1("my formula&...
0
votes
0
answers
35
views
Not hidden apostrophe in Excel cell on NPOI generated xlsx
I'm using C# and NPOI library for generating excel files. Currently I'm trying to prevent formula injection adding apostrophe in the beginning of each cell starting with =, +, -, @, etc.
The issue is ...
0
votes
0
answers
34
views
Excel VBA Adding Parentheses around Column Name in formulas [duplicate]
I have this very basic code in VBA:
Activecell..Formula2 = "=XLOOKUP(RC[-100],'[" & wbState.Name & "]" & wsState.Name & "'!B:B,'[" & wbState.Name &...
0
votes
2
answers
37
views
Linking data in two Excel tables where row number does not align
Table1 data starts at row 11 onwards and Table1 is called eSpace
Table2 data starts at row 18 onwards and column B heading is called Level
Entering =eSpace[Level] in Table2 row 18 retrieves the data ...
0
votes
1
answer
92
views
Dynamically import data from one work book to another with progressive pages
I have two excel workbooks. 1st workbook has all the information I need that are sorted by machines and 3 number inputs following the machines, the inputs for this workbook is created in this format;
...
0
votes
0
answers
30
views
Excel Inbuilt Pivot Calculated Fields
I would like to create an excel pivot table with inbuilt excel formulas please. I have a spreadsheet with Client A - D and the dates and items they have purchased.
I want to show the above in date ...
-1
votes
1
answer
45
views
Assistance combining two if statements
I need to combine two if statements together in one cell, i have so far come up with the following,
=IF(ISBLANK(F2),"",F2-D2)
=IF(ISBLANK(G2),"",G2-D2)
I need both of these to be ...
0
votes
1
answer
42
views
I have an IF statement but its not working as i intended it too
I have a need for an IF statement to add time if a cell shows as No.
So in Cell F2 i need the IF statement to look in Cell E2, if the cell shows No, i need it to then add 10 minutes to Cell D2 and ...
0
votes
2
answers
463
views
Percentile formula in Excel
I have a range of numbers I am trying to summarize using percentiles; 10th and 90th to weed out the outliers and then 25th, 50th, and 75th to demonstrate the distribution within the range. The range ($...