All Questions
391
questions
0
votes
2
answers
85
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
68
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
328
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
163
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
70
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
60
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
323
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
349
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
476
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
79
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
0
votes
0
answers
228
views
Excel - Using VLOOKUP on grouped table records
I have an xlsx report from a finance tool which provides raw numbers but none of the formatting or formulae I wish to use to better read and analyse the numbers.
The report is structured like so:
...
- 279
-2
votes
1
answer
131
views
How to match and merge lookup results in Excel?
I'm a total newbie with Excel and I'm stuck at doing this. I'm guessing there must be some work around "lookup" functions but I don't know which one and how to start.
Let's say I have a ...
1
vote
1
answer
209
views
Drag to fill duplicates values
I want to create a sequence of dates that populate a column.
A
2023-12-31
2023-12-30
2023-12-29
...
Format Cell is set to Date.
Calculation Options is set to Automatic
Enable fill handle and ...
- 393
0
votes
1
answer
595
views
Is there a way to drag a SUMIF/(S) formula down vertically but pull information horizontally, and vice versa?
Essentially, I am trying to fill information into Sheet A (SA) using =SUMIFS but the information that it is pulling into the actual formula comes from Sheet B (SB) and is organised in horizontal form.
...
- 1
2
votes
4
answers
9k
views
How to paste only the formatted value not the actual value
As the title says, I want to copy and paste cells into the format that they are shown in.
Original value (actual value):
25
59,05
90,1
Formatted value (what is shown):
25,000
59,050
90,100
The ...
- 121
0
votes
2
answers
556
views
Transpose Group of Rows to Single Row | MS EXCEL
I need to Transform Some Uneven Group of multiple rows to single row
I Tried to Extract the Required data from multiple row to multiple Column. But all data placed under different Rows (same as input ...
- 115
0
votes
0
answers
39
views
need advice two excel formulas
#SOLVED -
=IF(AND(COUNTIF(b3:e3,"Yes")>=1,i3="Yes"),"Remove Online Module",IF(AND(COUNTIF(b3:e3,"No")=4,OR(i3={"Yes"})),"Complete Online ...
- 37
0
votes
0
answers
161
views
Call a sheet using a variable name
I have this code in wich I add a sheet with a certain name and then I need to call this sheet to get a cell value but it doesn't assume.
Dim nome1 As String
Dim tableName As ListObject
Dim addedRow As ...
1
vote
0
answers
257
views
How to make an excel sheet dynamically reference another sheet
I am trying to make an excel sheet that generates material costs for construction. My plan is to have one sheet where I can enter the material and its quantity, and another that stores the prices of ...
- 11
0
votes
1
answer
113
views
Microsoft Excel Conditional Formatting for Dates and Prices
I'm looking to conditionally format a table following this general idea; I have short dates in one column and years in the headers for several other columns, Id like to highlight the cell when the ...
- 1
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
0
votes
1
answer
68
views
Format of Excel drop down list
When choosing from a drop down list in Excel, is it possible for the cells to change the format when you choose a specific subject?
Each subject has a different format for the cells.
- 1
4
votes
2
answers
936
views
Create a formula that sums up values between equally spaced cells
I am trying to make my cells follow a continuous incremental pattern so that I can drag it down and it applies to all cells. I am creating the calculation in one sheet, but the data is in other sheet.
...
- 41
0
votes
1
answer
20k
views
Color another cell based on (if blank) by two different cells
I had this working at one point
Column A: Names
Column B: Date
Column C: Date
IF Column B cell is filled, Color Fill ColumnA-Cell GREEN
IF Column C is filled, Color Fill ColumnA-Cell is RED
...
0
votes
1
answer
419
views
Running several sets of assumptions through a model in Excel
Hello and thank you in advance for your help! This question is for excel.
I have created a dynamic model which outputs estimated annual interest revenue, and it depends on 5 inputs (average term ...
