All Questions
391
questions
1
vote
4
answers
13k
views
How to combine SUBTOTAL and SUMIFS in Excel?
I am struggling to combine my SUMIFS formula with SUBTOTAL. As you can see in the picture, my SUMIFS formula (highlighted in yellow, formulate pasted as text below it) sums up Column C when values in ...
CommunityBot
- 1
0
votes
1
answer
43
views
Fillup cell depending on value of another cell
So I want to fill up certain cells with certain values. I want to use the IF function. I have the following data:
4271423/421424/4237168/4246332=D917/F222
4271423/421424/4237168/4253485=D917/F222/J008
...
- 43.2k
-1
votes
2
answers
63
views
IF+AND function
I have to check if the value in C2 is in the column F, IF it is AND the last digit of C2 is "1", I want it to return as "Incorrect Variant" or blank.
How do I write the correct ...
- 43.2k
0
votes
2
answers
1k
views
Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?
Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?
For every cell in the “Sales Sheet” that is blank, the corresponding ...
- 43.2k
7
votes
3
answers
1k
views
Excel IFBLANK equivalent for IFERROR
IFERROR works great because it shortened the formula significantly by having a default behavior, returning the results if condition is not met (no error).
I'm looking for the IFBLANK version of this ...
- 43.2k
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 ...
- 1,000
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
vote
1
answer
4k
views
How do you make a dynamic link to another workbook?
I have numerous workbooks titled in the format "Year Detailed", e.g. "2000 Detailed.xlsx", "2001 Detailed.xlsx", ... "2018 Detailed.xlsx".
I am trying to make a summary sheet in another workbook, ...
CommunityBot
- 1
0
votes
1
answer
230
views
Excel - Vlookup within Vlookup dependent on drop-down
Please bear with my explanation here - I want to be as clear as possible. I have about 8 different tables (different categories), which contain ranges that correspond to point values. I have been ...
8
votes
1
answer
25k
views
How can I stack all non-blank cells from a column?
I am looking for a formula that will take all non-blank values in one column and stack them in another column.
Please see example below. Essentially I am trying to go from column A to B using a ...
- 1
-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 ...
- 9,504
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 ...
- 2,320
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 ...
- 2,320
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?
- 16
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 ...
- 3,174