All Questions
58
questions
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 ...
- 1
0
votes
1
answer
511
views
Want the same cell to either display the value based on a formula or else allow user input, depending on the radio button chosen
I have cell (C17) whose value should depend on the choices made via radio buttons. One button is called 'defaults' and other button is 'custom'. The thing is, when I select the 'custom' button, I want ...
- 1
0
votes
1
answer
6k
views
Extract multiple columns with single dynamic array formula
In Excel 365, how can I select non-contiguous columns from a range using a single dynamic array formula? Consider data in columns A:E as follows:
Entering =XLOOKUP(G1,A1:E1,A2:E11) into cell G2 ...
- 133
1
vote
1
answer
232
views
formulas in another column that reference spill range not updating when sheet is recalculated
I have a a column that is a spill range that uses the filter and sort_by formulas. This spill range is dynamic and I have an IF statement that references the spill range but upon recalculation of the ...
- 11
1
vote
0
answers
64
views
Excel - Select range depending on cell
I want to select a row range, which I've been doing manually until now. However as data grows, I've tried to select the row according to the relative worksheet, but don't know how to. Here's an ...
- 111
0
votes
1
answer
38
views
Microsoft Excel - Formula to calculate age for a series of rows with different start and end dates?
I have a spreadsheet of individuals with a year every time contact was made with them. Each individual has a unique alphanumeric identifier. Each individual has a variable number of entries (rows) ...
- 1
0
votes
2
answers
1k
views
Excel workday function to skip custom array of holidays
I am trying to use the Excel "workday" function to assist with handling a large list of public and organisational holidays when scheduling education courses in a multi-state country (Australia). ...
- 3
1
vote
2
answers
2k
views
Excel: Split a string on a delimiter and determine the length of the resulting array
I have an Excel sheet including columns like this:
| 143 | 423 | | | 423;234 | 134;234;143 | =SOME_FORMULA() |
The data have the following characteristics:
Although numeric, they should be ...
- 705
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 ...
- 11
1
vote
1
answer
213
views
Name the first item from a list that is not in another list
I am working with a list of articles in one spreadsheet files as the data source. The data is split into a source reference code in columns A to E, the title of the article in column F and the author ...
- 113
0
votes
0
answers
61
views
Unlock Sheets via VBA
I have an excel with a lot of formulas running and it goes to an executive team. Naturally I have locked the two summary pages to prevent formulas from being deleted accidentally but on some systems ...
- 87
0
votes
3
answers
101
views
Finding highest numerical value from a range of hybrid data in Excel
I have a row of 6 alpha-numeric values as in the picture. I need a formula that will determine the three highest numerical values across each row, and then display the letters associated with those ...
- 1
1
vote
1
answer
269
views
autofill a reference of a column to a row in steps
I have the formula =IF(Jan!$L6="w",Jan!$L6,"") in the cell A2.
in the cell right next (B2) to it I'd like to have the formula 3 rows further down so
=IF(Jan!$L9="w",Jan!$L9,"") and then in C2 ...
- 115