All Questions
50
questions
0
votes
1
answer
349
views
Merging Two Tables Including INDIRECT Function in Excel and Displaying New Table Data
Dynamic Variables Explained
Data is pulled at the end of each month and is stored in the format of YYYY.MM.DD -- Monthly Data Obtained.xlsx and Excel calculated the date range.
=TEXT(EOMONTH((EOMONTH(...
0
votes
0
answers
42
views
Count of Unique Records with criteria from other Column
Good Day,
I have a schedule people populate where they are on tasks. There is a due date and date completed. Some of these tasks are there multiple times as they are done over several days. I'm trying ...
0
votes
2
answers
160
views
Excel- Add sequential names to column based off of named range but skip names if duplicate name exists in adjacent column
I am creating a simple schedule for our engineering rotation. Some background information, our team currently has 6 engineers that must go on a weekly 5 am rotation. There is also a 2nd shift rotation ...
11
votes
4
answers
8k
views
Spurious 0.0000000000001 added to formula result
My wife and I have a spreadsheet to work out our finances at the beginning of each month and this month has a strange figure in cell F9.
The formula in cell F9 is ="+ £"&-'Sue''s ...
0
votes
1
answer
217
views
Get cells from another sheet based on criteria
I'm trying to build a simple helper to control my expenses.
One sheet has a list of all financial movements (income and payments), with these details:
Date
Amount
Reason
02/02/21
-1000.00
Rent
02/...
0
votes
0
answers
2k
views
EXCEL: Can I reference text within a cell, for a file path, in a function?
I have the following VBA module in Excel which allows me to do check if a file exists in a given folder:
Function FileExists(FilePath As String) As Boolean
'Declare variables
Dim FileName As ...
1
vote
2
answers
2k
views
Formulas `A1:A` and `A1:Z` give invalid name error in Excel?
Selecting a range of definite size (e.g. A1:A2) works just fine, but selecting a range to the last row does not. If relevant, I am using Office 365.
0
votes
1
answer
74
views
How to delete a column of one sheet based on value in other sheet by ignoring N/A value?
I am working with an excel file where in Sheet1, I need to compare column C and Column E. If in any row of sheet 1, Column C value> Column E value, then I need to delete certain column in sheet 2.
...
1
vote
1
answer
2k
views
Filter function with IF statement in 1st parameter to perform fill down multiplication OR division
Link to my previous related question for more background if needed: Transpose unique rows to columns while IF statement conditions are met but do not consolidate
My table headers start on row 20 ...
0
votes
0
answers
2k
views
Auto-populate a cell based on text input of one cell and the presence of text in another cell
I'm trying to reduce the amount of manual input on a Drawing Log I'm presently creating.
Basically, I've got 5 columns: Drawing No., Client, Project, Date, and Description (in that order, though Date ...
0
votes
1
answer
229
views
Excel unstacking data into multiple columns
I am struggling with unstacking, there are many easy Power Query and Pivot solutions , however i would like to have the solution in formula's so people understand the power of formulas.
Marketing, PR, ...
5
votes
2
answers
1k
views
Excel - Live filter of list based on another column?
In Excel, I'm looking to get a breakdown of the values in one column (IDs) by the values in another (status).
Input
| ID | Status |
|----|----------|
| 1 | Complete |
| 2 | Active |
| 3 | New ...
0
votes
2
answers
64
views
Excel CF: Matching (2) columns of text that begin the same, end different
Looking for assistance with the following:
A & B are a list of companies. The goal is to highlight in B companies that match A
Conditional Formatting: =MATCH(LEFT(A2,8)&"*", $B$2:$B$...
3
votes
2
answers
4k
views
How to sum non numbers by number value
My question was nearly answered by How do I assign a number value to a non-numerical value in Excel
We use a RAG status (red, amber green), and I'd like to average a group of these values.
EG, if ...
0
votes
1
answer
56
views
Need to make restriction in the VBA function
I want the below function to pick data from Row till Column H, however this function is picking details up to the last used cell.
Below are the VBA code I'm using, help me to fix this.
Function ...