All Questions
50
questions
1
vote
1
answer
1k
views
Excel column auto-populates in newly inserted rows
Hopefully this makes sense.
In Excel, I have a table with 12 columns. Column A is a file number hyperlink that takes you directly to the specified job folder on our server. When I insert new rows ...
0
votes
1
answer
112
views
Re-order data in a large excel file
I need to re-order data in a large excel file. Please suggest how can I get the required output.
2
votes
1
answer
310
views
How would you count the number of matches between a comma-separated list and a reference column in Excel?
I have a set of numbers separated by commas. Each set represents a series of unique numbers that relate to a project. How can I write a formula to search a reference sheet for any number of the items ...
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. ...
0
votes
1
answer
271
views
"Too many arguments" error message in SUMPRODUCT
I'm somewhat newer at this, so I apologize if this is a dumb question.
I want to count each name I have listed in Column A once while ignoring blank spaces and excluding two different text values ("...
0
votes
0
answers
164
views
How to export excel file to csv file without the semicolon outside the inserted values?
I have inserted values into excel file in "order_status" sheet. These values are shown in below picture:
In this sheet I added data validations like: dynamic drop down list, checking if in cell is ...
0
votes
1
answer
48
views
After changing text in a cell, it fails to evaluate last step of a formula
I'm facing a really odd and annoying issue with formulas that I'm not succeeding in fix it.
It happens the following: I received an Excel .xlsx via Outlook (but I also tried using USB).
When I open ...
0
votes
0
answers
39
views
Copying Data into another sheet when a condition is meet
Does anyone have any idea of a solution or know if what i would like to happen is even possible. I am a complete computer novice and know nothing about ExcelVB, if that's the path to take.
I've a ...
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
1
answer
268
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 ...
0
votes
1
answer
1k
views
Excel - How can I probe all the precedents of a given cell?
I'm a relatively naive excel user who's been dropped in the middle of an ocean of cells. I've been tasked with coding the value of one cell in a workbook into python. Of course, this cell has multiple ...
-2
votes
1
answer
102
views
How to remove duplicated entries, and only keeping one entry per user per course
Needed help here!
Here, for example, the title (the title of a course), required date (the date they required to retake the course), and the completion date (the completion dates that a employee ...
0
votes
1
answer
300
views
How to specify a column range according to a formula in Excel?
I'm trying to calculate a formula based on a column of data, and I want to choose the column based on a number in an adjacent cell. Here's a simplified example of what I want to do:
Say I was trying ...
0
votes
0
answers
58
views
In Excel, how can I get use built in functions and/or write a VBA function to result in a picture being displayed as the formula result?
See this question, which got little attention.
Imagine that I have a workbook with images of all of the playing cards somewhere, like a lookup list. I want to randomly shuffle the deck (...
0
votes
1
answer
227
views
Linking formula and standard cells across columns in a table?
I have a workbook W1 which contains a table W1T1. One column (by entering the letter 'x') signals, that this row W1T1Rx has to be copied into another workbook W2.
W2 contains a table W2T1 that has ...