Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit 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.

1
vote
0answers
13 views

In Excel, how can I center a column, align decimal points, and not show decimal places with zeros to the right?

In Excel, how can I center a column, align decimal points, and not show unnecessary decimal places or decimal point? Example: | 0.12 | | 122 | | -12.2835 |
0
votes
1answer
12 views

How can I center a column in Excel, have the decimal points aligned, and show only the necessary decimal places for each number, but at least one?

How can I center a column in Excel, have the decimal points aligned, and show only the necessary decimal places (i.e. not use unnecessary zeros to the right of the decimal point) for each number, but ...
0
votes
0answers
5 views

Excel: Problems with the calculated field option in pivot tables

I would like to use the calculated fields option for pivot. But it doesn'calculate the columns, I would need. In the first screenshot you can see the pivot table Summe = Sum => It sums up the values, ...
0
votes
0answers
14 views

How do I match a specific word in a cell with that word in an array?

The first column is for the ITEM TITLES of random items and the third and fourth columns are for the CATEGORY ID and CATEGORY NAMES, respectively, that the item could fit into. The second column, ITEM ...
0
votes
0answers
15 views

Flip the legend horizontally in Microsoft excel chart

I am using Microsoft excel with Arabic language, I would like to flip the legend horizontally, the color on the left and label on the right (figure).
0
votes
2answers
35 views

Comparing two columns, if similar return values from third column to another column

In excel I have 2 different sheets, sheet 1 and sheet 2. If in sheet 1 column A and B matches sheet 2 column A and B, I would like to copy the value for column C and D in Sheet 2 back to column C and ...
0
votes
1answer
23 views

Adding an item to a drop down list for data validation when the initial list is a named range

I have a table that contains the list of values that I want to use in my named range - A, B, and C. Fairly simple to have them be the named range - =Indirect("Table1[Column1]") However, I would like ...
0
votes
1answer
15 views

Excel: check multiple cells for specified values, name the ones that do not match

Ok, so I've tried writing my own formula to make this doable but am drawing a blank. I want to check multiple columns in a row to see if they contain a specifief value, let's say "V". Then in the ...
0
votes
1answer
34 views

Excel: Conditional formatting if cell is not equal to one of multiple values

Using Excel, I would like to conditionally highlight a cell, if the value of the cell itself is not one of several values. The cell should be contain of the following percentages – 0%, 6%, 12% - or ...
0
votes
1answer
22 views

Not using a cell as variable, whilst inserting a (excel-)formula in several cells

I'm facing a small, basic little problem, for which I can't find the solution: I'd like to insert the same formula in several cells at once. Quickly googling this problem provides a solution: Either ...
0
votes
1answer
25 views

Excel: How to generate dynamic tables, based on values of another table

In Excel, I would like to generate a dynamic table, based on the values in some other cell. I have never done this before, so I don't know the terminology or the techniques involved. I'm also not ...
0
votes
0answers
20 views

Pivot Table, Subtotal Date Formatting, Format Cells does not work

In pivot table A I have the date like so 10/10/2018 when I subtotal it goes to, 10/10/2018 Total which is what I want. The "format cells" in these subtotal cells are _(* #,##0.00_);_(* (#,##0.00);_(*...
0
votes
2answers
23 views

Looking for formula to update dates in other cells when I update a cell

I want to change just Mondays date and have the rest of the cells change sequentially.
2
votes
1answer
26 views

Excel Data, Why does formula change dd/mm/yyyy to #####

I have the date 10/10/2018 in cell A2. In B2 I have =A2&" Total" which comes as 43383 Total. But for my vlookup I need it in 10/10/2018 format. How can I format this to stay at dd/mm/yyyy? I ...
1
vote
0answers
12 views

Excel filter vanishes after change in sheet

I have a excel-file with multiple sheets. Sheet1 (Lagerliste) holds a bunch of logistics-data. Mainly: WHAT is WHERE In a seperate sheet I want to filter all lines containing a certain value (...

15 30 50 per page