All Questions
693
questions
1
vote
1
answer
1k
views
Why are my columns disappearing after I refresh the data?
The table below is connected to a query. When I refresh the table below, the last two columns' data, S and T, disappear. All the cells in these two columns contain a vlookup. How can I get the vlookup ...
- 23
0
votes
0
answers
1k
views
I am trying have data appear in the "Values" field in a pivot table, but the pivot table keeps summing the values that have the same date
In the pivot table, when there are two or more values assigned to a date, they sum.
I don't want the values to sum. I want each value listed, even if the date is same for the values. I've tried going ...
- 23
0
votes
2
answers
64
views
Excel - Formula Based Individual Durations and Total Duration Calculation from Slash-Separated Time-Strings
I am trying to calculate (using worksheet formula based solution only) individual time-durations and total time duration from the slash '/' separated time-texts in two cells (each value of first cell ...
-2
votes
2
answers
12k
views
Conditional Formatting with greater than & less than parameters based on date in cell
Trying to conditionally format a cell based on the date in the cell. My ultimate goal is to try and track warranty expiration dates on some of the product we maintain. Within 30 days of expiration ...
- 1
0
votes
1
answer
27
views
Is it possible to seperate cells like based on a variable?
Here I have 2 pages one named Input and The other Output
in Input I have In cell C2 the number of lanes which is 6 in this example and the D2 the number of Heats which is currently 4 :
if this ...
- 3
0
votes
1
answer
156
views
Creating Exception in Excel Sum to Avoid error Value
this is the formula:
=DATE(YEAR(Q14),MONTH(Q14),DAY(Q14)+(R14))
I'm using to add date how do I make exception that it keep the answer blank until I enter the date in Q column
- 1
0
votes
1
answer
483
views
Can anyone please tell me how can I convert 1M, 1B, 1K to number format in excel? [duplicate]
Can anyone please tell me how can I convert 1M, 1B, 1K to number format (like 1K = 1000) using formula in excel.
Advance thanks for help.
0
votes
2
answers
4k
views
#VALUE! Error when trying to use the Filter function to filter on mutiple criteria
original_name
match_name_0
score_0
match_index_0
match_name_1
score_1
match_index_1
AGI Partners, LLC
agi partners llc
100
5273
agi partners llc
100
5273
AXA Investment Managers S.A.
axa investment ...
- 123
0
votes
0
answers
24
views
Have problems sharing an Excel Sheets
I am working on an Excel Book and I want to share it with some people.
All the Sheets are linked to another Excel Files, so I need some help with sharing this Excel without any #REF or ERROR in the ...
- 1
0
votes
2
answers
673
views
Splitting a column in excel into two columns keeping the leading zeros
Trying to find a faster way to change this format from one column (A) split into 2 columns (B and C) as in the example below:
A
B
C
978-BD71151-001-0
978-BD71151-001
0
978-BD71151-002-1
978-...
- 1
0
votes
1
answer
441
views
How to put DATEDIF and IFISBLANK together?
I have 3 total cells I'm working with. One houses today's date (A1), the second has the date the request was made (B1) and the third has the date of the event (C1). My team had previously used DATEDIF ...
- 1
0
votes
0
answers
66
views
SUMPRODUCT Query
I'm trying to use SUMPRODUCT or any other formula to get an end calculation of how many occurences "Louise" appears in column F and then how many Sessions she had in the MONTH of September ...
0
votes
0
answers
161
views
Call a sheet using a variable name
I have this code in wich I add a sheet with a certain name and then I need to call this sheet to get a cell value but it doesn't assume.
Dim nome1 As String
Dim tableName As ListObject
Dim addedRow As ...
0
votes
1
answer
730
views
Drag down formula from multiple sheets on one sheet
I have 19 Sheets on each sheet in cell B17 I have a result.
On my first sheet I have cell numbers from 1-19.
In my first sheet I type in cell one the Formula ='sheet 1'!$B$17. I have the number in ...
- 1
0
votes
0
answers
122
views
How do you generate a list on excel based on complex criteria when the data set is not unique?
I am trying to build a excel sheet that automatically generates the list based on the 3 criteria (each criteria has a dropdown). Below is the template I created.
Criteria list:
Purpose, loan type and ...
- 1