Super User Stack Exchange
Super User Stack Exchange

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.

Microsoft Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and macOS. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications).

Microsoft Excel 2010

Features and usage

The latest version is Excel 2021 for Windows and macOS. Features include calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). A new user-interface design, dubbed the "ribbon", was introduced with Excel 2007 for Windows. A similar UI was introduced to Excel 2011 for OS X.

Excel is the among most widely used spreadsheet programs, especially in business environments. The first version was introduced in 1993, and new versions have been released every 2–3 years since then.

Recent versions

Subscription based license/version

Windows (stand-alone license/version)

Mac (stand-alone license/version)

Other tags

More specific tags include for scripting, for formulas and for pivot tables.

More information

Samples and Tips

25293 questions
4
votes
1 answer

How to use fx autocomplete in Excel w/o mouse

When you type a formula into Excel 2007, it brings up hints for functions. For example, type =L into the fx field and a bunch of functions will appear in a drop down menu (Large, LCM, Left, etc). Using the up and down keys, you can select a…
Matt
  • 55
  • 1
  • 4
4
votes
3 answers

Average of cells that match criteria and removing duplicates in Excel

I have an Excel spreadsheet where I want to remove the duplicate names and take an average for each person's score. I have a list of the following type: Al 1 Bob 1 Bob 2 Bob 1 Joe 4 Joe 2 Kevin 1 Kevin 8 Sally 5 For instance,…
Robert A. Fettikowski
  • 43
  • 1
  • 1
  • 3
4
votes
2 answers

Excel conditional formatting based on a formula

I would like to use Excel's conditinal formatting of a particular column based on values in two other columns. I have values in columns A, B, C and D. column A has text values (any value user enters) column B has a numeric value (any value user…
Robert Koritnik
  • 2,016
  • 6
  • 28
  • 43
4
votes
2 answers

Summing a column in the same column without a circular reference

In Excel you can sum a whole column with =SUM(B:B). But of course you can't use that formula in the column you want to sum, because you'll get a circular reference. Is there an easy way of summing all the values in the column below the current…
therefromhere
  • 8,412
  • 10
  • 42
  • 43
4
votes
2 answers

Excel if column partially contains string and on match the same row contains a different value

I need some help calculating the TRUE/FALSE section, I have filled it in manually to show what results I want to achieve. Essentially, I need an IF() statement that will be TRUE on sheet 2 if the header and ItemName match on Sheet 1. Sheet 1 -…
Chris
  • 41
  • 1
4
votes
1 answer

How to stop Excel from combining Conditional Formatting rules into 1 broken rule

I understand that Conditional Formatting is a horrendous tool, much like Excel itself, but it's the only realistic option so I'm stuck with using it. However, I'm unable to grasp how painfully stupid this bug is, so hopefully someone can help. I…
JoeP
  • 144
  • 9
4
votes
1 answer

Why this apparent orthogonality in Excel's INDEX() syntax?

TL;DR In Excel 365: Why doesn't a 0 in the second argument of INDEX(A1#,0,{1,3}) return all rows, when it does in each of INDEX(A1#,0,1) and INDEX(A1#,0,3)? And is there a canonical way of getting it to do so? DETAILS Assume I have a dynamic array…
tkp
  • 420
  • 3
  • 13
4
votes
2 answers

Excel 2019 always opens file from local network drive as write protected

Problem I've run into the following issue when opening an Excel file from a local area network drive (provided by my Synology NAS) - whenever I open the file, it is opened as write protected (schreibgeschützt in German). Attributes Looking at the…
Gorgsenegger
  • 181
  • 7
4
votes
2 answers

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. For example: I would like one cell to be: =…
dgtlbnny
  • 41
  • 1
4
votes
4 answers

Lookup over matrix with non-numerical data

I have several minitables (title, content) organized in a matrix, like the following example: I want to do a lookup such that I put the "title" value in a cell, and return the content. So, I put a letter in yellow cell and return the content, as in…
luchonacho
  • 159
  • 13
4
votes
2 answers

Excel - Lookup exact match in one column and exact or next higher match in another column

The problem I have a three-column lookup table in Excel, like this: Figure 1. The lookup table. Given a first input lookup value, typed in cell F1, which can be any alphanumeric string of characters and must be exactly equal to any of the values in…
alejnavab
  • 147
  • 6
4
votes
4 answers

How to evaluate multiple OR'd conditions in COUNTIFS (or similar) row-by-row?

Consider the following sample data. A B 1 2 8 4 2 1 3 7 4 8 Separately, the count of A that is less than 5 is =COUNTIF(A1:A5, "<5") -> 4, and that for B is =COUNTIF(B1:B5, "<5") -> 3. I know if I want the count of rows where A…
Drake
  • 95
  • 7
4
votes
3 answers

Excel 2007 Sharing Violation error on a standalone PC

On my home PC, why do I get the Excel Sharing Violation error while performing a Save operation in MS Excel 2007? The exact error message is: Your changes could not be saved to 'filename.xls' because of a sharing violation. Try saving to a…
kamleshrao
  • 813
  • 4
  • 14
  • 20
4
votes
1 answer

Issue with IF statement in Libreoffice Calc

Here is the statement =IF(L7>7,"$500",IF(L7>11,"$1200",IF(L7>15,"$2000",$0))) I simply need this to resolve a value based on the set conditions. I've tried numerous variations but can't seem to get the second or third results. Unsure if there is…
Val
  • 43
  • 3
4
votes
2 answers

Excel: Pie Chart of a Question with Limited Possible Responses

I distributed a survey online and received the answers in an Excel spreadsheet. I would like to make a pie chart out of some of the closed option answers. For example, one of the questions was gender. Is there a way I can create a pie chart that…
Ryan
  • 1,518
  • 1
  • 15
  • 24
1 2 3
…
99
100