All Questions
23
questions with no upvoted or accepted answers
3
votes
0
answers
49
views
Changes to User Defined Functions in Office 365 Subscription based
I've seen issues a couple of times when using User Defined Functions with Excel from subscription-based Office 365.
When a workbook is opened with these formulas, they are automatically updated. ...
2
votes
0
answers
305
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. ...
1
vote
0
answers
44
views
Last filled row Function behaves strangely based on column it's in
Function is acting very strange depending on column it's in.
Data start at row 7 (headers in row 6)
Column A has item name B Max Qty. C and D have simple functions and everything afterwards is the ...
1
vote
0
answers
70
views
How to have Excel return column and row headings based on / alongside an ordered list of values?
A measurement of ion transport numbers went wrong when an unorthodox concentration was accidentally used. An analysis of what could have happened yielded the following table. The values have been ...
0
votes
0
answers
135
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 ...
0
votes
1
answer
440
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
...
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 ...
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%, ...
0
votes
1
answer
260
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
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
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 ...
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, ...