All Questions
391
questions
0
votes
2
answers
71
views
Calculate a moving average in excel where the lookback (window) duration is a variable that changes based on another cell's changing values
I am trying to calculate a moving average of a dataset where the moving window time duration is not fixed, but changes over time based on numbers in a different column. Using the screenshot I have ...
- 15
0
votes
0
answers
66
views
Need Help Migrating A Drop Down List From One Workbook To Another
I need some help migrating a drop down list and the data selected from that list to another workbook.
I have a list of people that need to be contacted each week, with an updated file that is sent to ...
-1
votes
1
answer
315
views
Excel help - extract all unique values from column a in multiple sheets
I have a sheet called output, and a sheet for each month a jan, feb etc.
Without vba, is there a formula I can use to extract all information from column A in the month sheets, into column a in the ...
- 37
0
votes
2
answers
158
views
How to TEXTJOIN/CONCATENATE based on constraints for specific no of rows count
I need to concatenate certain attribute value based on the sequence number for specific material number and a formula to automate the process.
I have columns as listed in the below screen shot and I ...
- 13
1
vote
1
answer
69
views
Coloring cells across multiple excel sheets in an xls file based on a condition
I am new to excel. I have an xls file with 10 sheets. In each sheet I have two tables of size 10 x 10, one starting at position A4 and the other starting at N4. All the entries are numbers.
(Note that ...
- 113
0
votes
1
answer
49
views
Copy data values for another column if matched
Sheet 1 has Month, Day and Year while Sheet 2 has Year and Day. If the data of Year in Sheet 1 and 2 are matched I want to copy the Day values from Sheet 1 to Sheet 2. Is it done by VLookup and how?
- 3
0
votes
2
answers
320
views
How to group a column based on another column. Then write it into another column
How to group the animal name column based on the category column, and put it on the corresponding column (yellow area). For example in the figure, find the animal name (column A) with herbivore (...
- 1
1
vote
1
answer
337
views
Hyperlink does not change along with cell when filtered
I’m having a problem with hyperlink when using filters. So let’s say I have these table rows:
A
B
C
I have a hyperlink to cell C using the usual hyperlink option. But if I change the filter from “A to ...
- 11
0
votes
1
answer
421
views
2 Dates in 1 Cell with Formula in Date Format
I'm working between two tabs in Excel. One tab is for data entry and the other pulls the data using formulas. I'm trying to create a formula where it pulls 2 dates into 1 cell. The formula currently ...
- 3
0
votes
0
answers
35
views
Index/Match function output appears out of sync
I am attempting to use index/match in conjunction with an if/and statement that does the following.
If column C = Secondary
AND if column D = Information/Videos
Take value of column B and output it.
...
- 159
1
vote
2
answers
63
views
Excel formula help - date formula needed
Im hoping someone can help or advise.
I want a formula to count the number of days left in a month from the date of the first of that month. If that month has passed, I would like to it to stop at ...
- 37
0
votes
0
answers
75
views
Creating a technical excel data sheet to display efficient data
I am creating a table in excel that holds milestone achievement data with their respective amount. This table has multiple milestones that have only one amount, meaning that a set of milestone ...
0
votes
1
answer
70
views
Excel Sum Table based of criteria missing from another table
I have 3 tables. Table1 is a list of items w/ a sum attached to them.
Table 2 is a list of "official items" and a category.
Table 3 is a category that needs a sum.
i.e.
Table 1
A.
B
Parrot....
- 1
1
vote
2
answers
1k
views
Excel 2016 - How to count UNIQUE rows that are "assigned" to someone?
I am building a chart that contains the total amount of rows and accounts assigned to a user in Excel 2016. The first issue is easy and I resolved it with a COUNTIF function, however the second part ...
-2
votes
2
answers
12k
views
Conditional Formatting with greater than & less than parameters based on date in cell
Trying to conditionally format a cell based on the date in the cell. My ultimate goal is to try and track warranty expiration dates on some of the product we maintain. Within 30 days of expiration ...
- 1