Questions tagged [microsoft-excel]
A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
25,934
questions
1
vote
1
answer
887
views
IF Function accross a range of cells
This is probably really easy but I need some guidance of getting it right as the sheet is very important.
What I am trying to do is check a range of cells to see if they contain either Yes or No and ...
1
vote
0
answers
43
views
Need expanding chart where values per custom user text are counted
Sorry if my question is not clear but I'll explain in more detail here.
I have a worksheet that calculates what percentage of a specific users events are mistakes. It figures this out by taking ...
0
votes
1
answer
68
views
Excel: Product function for selected entries
I am trying to get the PRODUCT function work for the certain entries only from a range. In the picture attached, the desired outcome would be to calculate only the entries of column B that have ...
0
votes
1
answer
51
views
Where can I find this kind of line graph?
I have this data gave to me in excel spreadsheet
2017 2018
Month Sales TC TA Month Sales TC TA
Jan -0.08 -0.08 0 Jan 0.02 0 0.02
Feb -0....
0
votes
1
answer
3k
views
Excel - Combining two cell formulas into one cell
Is there any easier way to combine formulas into one cell other than just copy and paste the formula text?
I have a long complicated formula that I split into two distinct formulas and then combined ...
0
votes
0
answers
458
views
Excel 2013 side-by-side sheet view
In Excel 2013, if I want to view different sheets from the same workbook side-by-side I first have to click View->New window otherwise the side-by-side option is greyed out.
After I click both New ...
0
votes
0
answers
2k
views
Excel stacked bar chart not starting at zero
I'm trying to create a stacked-bar chart in Excel 2013 that will appear as a Gantt chart, with multiple events on each row, much like the picture below.
However my problem is that in order to plot a ...
1
vote
1
answer
1k
views
Cant find if my office version is up to date
I'm having some trouble determining exactly which version of office is installed on a Windows server 2016.
For exemple in "Account" here
here
nothing is chown
But when i go in "about word" i have ...
-1
votes
1
answer
40
views
Need assistance Excel formula
I want to write a formula on excel. Please assist with a formula to calculate the actual output, if target heads produce target out put, what formula do i need to get the actual output
Target Heads ...
0
votes
0
answers
45
views
Using stored numbers in a formula?
Here's the piece of code that's giving me trouble:
Dim lastRow As Long
With Worksheets("Rent Roll")
lastRow = Worksheets("Summary").Range("NUM_UNITS").Value
.Range("A1:A" & lastRow + 25)....
0
votes
2
answers
1k
views
Sum max consecutive cells if negative
Hi, i have a little problem, i have column A(2:11) with random positive and negative numbers and i need a formula for finding the highest sum of consecutive negative numbers, in this case A7, A8, A9 ...
0
votes
2
answers
1k
views
VBA Code to Hide Rows in a Table (More complicated than it sounds)
LAST POST WAS DELETED - "BEEN ASKED BEFORE" - PLEASE READ WHOLE THING :)
Basically I have a large table (500 rows) and I need to only show the amount of rows based on the value in a certain ...
4
votes
1
answer
1k
views
Unexpected Results with Copy Command and Excel Files
I noticed something strange when executing the Copy command from a Windows batch file and was wondering if anyone has encountered this before and can explain the cause.
I have a line in a batch file ...
1
vote
3
answers
358
views
Averaging values in Excel with < symbol
I have columns of laboratory analytical data in Excel. Some cells contain the < symbol and some do not. I need a formula that tells Excel to average the columns, but to use 1/2 the value for the ...
-2
votes
1
answer
477
views
How to increment a list of values with a button
I am trying to manage a list of students in an excel database. I am trying to create a button that will increment the semester column by 1 when clicked. I have tried using an active-x button and a ...
2
votes
2
answers
24k
views
How to plot horizontal lines in scatter plot in Excel
I would like to plot a time series with two horizontal lines (depicting limits in my case).
How do I do this?
Example of what I'm trying to achieve (horizontal lines drawn in Paint):
1
vote
1
answer
953
views
Concatenate all cells that match criteria (Excel)
I have a spreadsheet like the following:
The expected outcome is all cells starting with specific text concatenated in order with their number of appearance.
The formatting like in the image is not ...
0
votes
0
answers
36
views
Open a worksheet in multiple windows and remember them the next time. How to do?
I would like to set it so multiple windows will be opened automatically every time I open that worksheet.
It should remember the locations of the windows, which area the windows show, zoom levels etc....
0
votes
1
answer
411
views
How to I drag automatically copy/drag formula Horizontally with Vertical Data?
How to I drag automatically copy/drag formula Horizontally with Vertical Data?
I have attached a pic below for explanation.
Is it possible to do so when i drag or copy formular
picture for clearer ...
0
votes
1
answer
2k
views
When value changes in a cell in excel, add the new value to a table [closed]
I'm looking for presumably a VBA script. Basically the situation is this: I have a sheet that automatically fetches values from an API so whenever I update the sheet the values change. What I want to ...
0
votes
2
answers
3k
views
Excel: Multiply a number by a sequence of numbers
In Excel I want to create a sequence of numbers that goes like
435
870
1305
...
I tried typing the first few instances and then dragging the select thing that's supposed to apply a formula to a ...
0
votes
0
answers
71
views
Moving filtered data into variant variable array
I am currently trying to automate a manual task. I have filtered my data and this works fine if I copy and paste the visible range into another sheet. I am trying to write the visible data into a ...
1
vote
1
answer
2k
views
Disable automatic scrolling while allowing typing in cells without macros (Excel)
I am using Excel 2016. When I type into cells at the bottom of the screen and press Enter, Excel moves the view down so that I can see what I just typed. Is it possible to disable this 'feature'? I am ...
1
vote
2
answers
484
views
Count appearances of two-adjacent-cell value in range (Excel)
I am working on a sports analytics tracker in Excel, and for one part I need to count (I know there are other questions that just need to find them) how many appearances there are of a two-cell value ...
1
vote
1
answer
231
views
Excel2013 - Leaving cell blank when there is no time value
I am summing time values (seconds and minutes) but I am having trouble in finding the right formula to leave a cell blank if there is no time in a cell, meaning: Don't do any sum just leave the cell ...
1
vote
1
answer
41
views
How to consolidate data within multiple cells?
How to consolidate data within two or more cells without merging? Does anybody have a solution or idea for that:
Example:
1
vote
3
answers
2k
views
How To Repeat Cell Value X Times In Excel One Cell
I have a sheet like this
Can you please let me know how I can loop on column A based on column B and create comma separated with -0 , -01` .... to column C
1
vote
1
answer
77
views
Why not getting proper sorted name list
The Array Formula I've used in H104 is,
{=INDEX($E$104:$E$111, MATCH(SMALL(IF(COUNTIF($F$104:$F$111, $F$104:$F$111)=1, COUNTIF($E$104:$E$111, "<"&$E$104:$E$111), ""), ROWS($H$103:H103)), IF(...
0
votes
1
answer
191
views
Combining Excel Formulas That Work Separately But Not Together
I've managed to give myself a headache in Excel. I've made 2 separate formulas that work separately but can't figure out how to combine them. Separate formulas are:
IF($N$19=" "," ",IF(AND($N$19>=(...
1
vote
1
answer
177
views
Speed up Excel Index Match - First Instance
I'm using the below formula to look up the first instance of a name appearing in an email (Column L). I have around 40,000 rows and the formula is getting slower and slower as new rows (emails) come ...
0
votes
1
answer
154
views
Excel 365 VBA macro
i'd like to populate a spreadsheet Nr 1 based on the entries I made in a different spreadsheet.
Here's a description of my workflow:
Based on a due date, I generate a calenderweek for specific Task ...
0
votes
1
answer
46
views
Lookup Value from two sheets by dates
I am trying to lookup ID values from two sheets which have dates ..I am trying to lookup value by date....Can you please help me ,,I have attached sample excel sheet and highlighted the sample below ...
0
votes
2
answers
2k
views
Random Sample in Excel with Conditional Statement?
I have a list of names with data associated with each name (there are multiple items listed for each name). I am trying to randomly select data for each person to audit. Right now, the spreadsheet ...
0
votes
1
answer
105
views
Making a cell mandatory based on conditional formatting of other cells part 2
I am looking to achieve the following:
Column C has been conditionally formatted based on data entry that if data is out of range, cell background will turn red.
I am wanting to force data entry at ...
2
votes
1
answer
71
views
Create many hyperlinked cells with readable text content instead of literal URL
Generally speaking, I'm trying to create an MS Excel spreadsheet with hundreds of rows of related URLs. Column A should contain human-readable text, but the cell text is hyperlinked to an HTTP URL. ...
1
vote
2
answers
263
views
Conditional Concatenate inserting or not inserting underscores depending on cell value
I'm a beginner on excel and I'm trying to get the following result:
Col1 Col2 Col3 Col4
John Jim Tom Sarah
Ann Betty blank blank
Lee Sue George blank
What I ...
2
votes
2
answers
40
views
MS Excel : Issue in consolidating data from multiple tabs
I have 12 tabs (sheets) in an Excel workbook ( they are 'Jan' 'Feb' 'Mar' and so on). On each of the tabs I have same structure/table.
Say in each tab I have the earning value on the cell B2 and ...
1
vote
0
answers
415
views
Making a cell Mandatory based on conditional formatting of another cell
I am looking to achieve the following:
Column C has been conditionally formatted based on data entry: if the entered data is out of range, cell background will turn red.
I want to force a data entry ...
1
vote
2
answers
3k
views
How to join/merge 2 worksheet tables from time-series in Excel?
How do you join two datasets in excel from time-series, but the observations have been made at different times. How would you combine the observations in one table with the second?
Example:
table 1:
...
0
votes
2
answers
3k
views
How To Alter Microsoft Excel Templates
I'm Creating a Gantt chart and I found this Microsoft excel template,
I would like to make some edits to the colors and formulas behind the template to suit my needs,
Can this be done?
Gantt Chart to ...
1
vote
2
answers
231
views
Getting Top 3 rows where cell value is greater than
Struggling with obtaining a row of data based on the value within the row. I have my data structured like this:
ID Name Score Owner
1 Item1 94% MD
2 Item2 24% OM
3 Item3 55% TM
...
0
votes
1
answer
83
views
How to define a graph, based on automatically changing data?
I have an Excel sheet (called Sheet1), where I regularly add some data. By pushing a button, a summary of that data gets written on a next page (called Evolution), and on that next page, there's also ...
0
votes
0
answers
46
views
Fetching Data entries from several sheets but ignoring duplicates (without losing count that is)
I am trying to make a detailed article count list, consisting of several sheets, each sheet representing a different category. Some articles however can exist in multiple categories.
How do I fetch ...
0
votes
1
answer
53
views
Not sure how to remove duplicates
I'm not quite sure how to do this. I'm adding a screenshot (below) to make it clear. Each row is a specific week of data, with the month being in column A. Sometimes there may be 1 week of data in ...
0
votes
1
answer
87
views
EXCEL: STDEV of a subset of data generated by mean
I have five values
643.8,
644.7,
632.4,
630.8,
627.9
of which the mean is 635.9
I would like to get the three closest values to the mean, how do I do this with an excel formula?
-1
votes
2
answers
63
views
Get the name against data
Have data in below format
Code Name
C-123456 XYS Contracting
31-Mar-17 CNC/SIV45678/CNC/SI-45678
21-Dec-17 CNC/SIV7894/CNC/SI-7894
21-Dec-17 CNC/SIV12348/CNC/SI-12348
31-May-18 CNC/...
4
votes
1
answer
236
views
Excel 2013/2016 not updating values while workbook is minimized
I have the following setup:
1 Workbook named Workbook1 with the value 123 in A1
1 Workbook named Workbook2 with value =[Workbook1.xlsx]Sheet1!$A$1 in A1
Now, when I go and change the value of ...
0
votes
1
answer
36
views
Data Validation that check 4 fields, but depending on results in 3 of them it is different with last field
I have a field, where I only want to allow something in that field, if 3 other fields value is 10 or higher, if they are that, then I can enter in that field.
Then at same time if 1 of these 3 fields ...
1
vote
1
answer
602
views
Excel bar chart widths displaying incorrectly
Using the following data to create a bar chart displays incorrect bar widths.
Yes No
a 7 0
b 7 0
c 6 1
Shows
As you can see, the widths for c are incorrect. The 'No' column is ...
1
vote
2
answers
852
views
How to automatically delete blank row/cells when export to other worksheet?
I have a few raw data files which some row/cell does not have data. How do I automatically delete those empty row/cells when I move/export the data to other work sheet. what formula should I use to do ...