All Questions
50
questions
0
votes
0
answers
130
views
Excel, reference header row instead of column in xlookup formula?
I need to make an Excel spreadsheet template that merges customer data from two other Excel files that are downloaded from a vendor application each morning. The files have a customer ID number for a ...
- 1
0
votes
1
answer
508
views
Creating a VSTACK'd array from a changing list of spilled references
I am working on a project that requires a large 'pool' of data to pull from and sort from. To keep the workbook efficient, the data is kept in sets of SPILL's, as pulling a raw selected range for the ...
0
votes
1
answer
289
views
Dynamic Array Subtotal that changes its column sizes without using VBA or volatile functions
I need to make a dynamic array subtotal that changes its column size by another dynamic array. The example sheet, challenge, conditions, and attempts I've made are below.
[Example Sheet]
Challenge:
...
- 3
0
votes
1
answer
426
views
Dynamically reference table row depending on cell input
I've found a couple of questions that touch on what I want to do, but not quite.
I have a table, say Table1
Segment
tot_bad_1at3
tot_bad_2at6
tot_bad_3at6
tot_bad_4at6
A
10
25
22
15
B
1
11
9
4
C
3
...
- 115
4
votes
1
answer
16k
views
How to change a cells color depending on the value of the cell above it/before it for hundreds of lines
I have hundreds of lines with varying values (currency) and want the cell to change color depending on the value above it eg. Greater than = Green, Less than = Red = Equal to = Yellow. ie:
A1 is $100
...
- 43
2
votes
1
answer
64
views
Proper Syntax for AND OR NOT Excel Formulas
I was practicing some basic formulas in excel. The last 3 I worked on are as follows:
=IF((OR(C4="Hourly",C4="Contract")),"Yes","No")
=IF((AND(B4=&...
- 23
0
votes
1
answer
1k
views
Excel summary page that auto populates from sheets
I have a problem with excel that may not be possible. I have a workbook that contains a list of sheets with various projects e.g. 'project 1' is a tab, 'project 2' is a tab etc. I now need to ...
- 1
2
votes
0
answers
301
views
Excel - Lambda's helper MAP() function not valid
Ever since 2021 I've had acces to the newer lambda's helper functions among which was the MAP() function. All other helpers like BYROW(), BYCOL(), SCAN() and REDUCE() amongst others are working fine. ...
- 2,237
0
votes
0
answers
70
views
How to Insert an autofilter if cell in row range contains value
I'm trying to create a function that inserts a filter within a cell range if a cell contains a value
Here is my code:
Sub FilterFunc()
Dim i As Long, lastCol As Long
Dim rng As Range, cell As ...
0
votes
1
answer
28
views
In excel, how do I fill in a column with a distrubution key when only one value is known? Calculate heating usage for a whole year based on one month
I need to figure out how I can fill a column of twelve know percentages (each month) based on the usage of one month. We have a certain distribution key (january is 19% of the total, february is 14%, ...
- 1
0
votes
1
answer
255
views
How do I find the cell value in workbook sheet1 using a created address in the second sheet
I have an Excel (latest Windows 10 Office 365 version) workbook with 2 sheets.
Sheet "Roster"has a column with last names.
Sheet "CheckStatus" has a column with last names and the ...
0
votes
1
answer
54
views
Excel Degree formula based on a right angle tringle
I have a formula we use at work to calculate degree for our metal, right now we use a calculator to do this but I feel like if we could just plug the numbers into excel and have it do the hard work ...
0
votes
1
answer
407
views
Excel formula to add variable number of lines
I have many large excel files that I need an easy way to combine daily totals for each person (a pivot table is not going to work for me on this one). My example is one of the smaller files, and it ...
- 1
0
votes
1
answer
38
views
Search array formula returns too high a value
I'm trying to count the number of times a certain due date is missed in a summary sheet on my workbook. On the parent sheet when something is overdue we label it as "LT". Something like this:...
0
votes
3
answers
1k
views
How to increment a cell reference by one inside a hyperlink equation to apply to a whole column?
So I have a column in (Sheet1) that I want to lead to the same cell number in another sheet (Sheet2) when I click each cell.
When I tried to use the hyperlink function, I typed the first equation as ...
