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

**0**

votes

**0**answers

7 views

### Runtime error '9' Subcript out of range

Kept getting runtime error '9' subscript out of range and the codes in ** ** gets highlighted. My worksheet name is Payroll. Please help!!
Private Sub Search_Click()
Dim lastrow As Long
Dim ...

**2**

votes

**1**answer

10 views

### Writing a custom cell format containing a double quote?

I want Excel to format my time values such that "72 minutes and 53 seconds" is displayed as 72'53".
In custom cell format lingo, this is probably close to[m]'ss", but I don't know what to do with ...

**0**

votes

**2**answers

21 views

### How do I ignore Empty Cells in the legend of a Chart or Graph

I am having trouble with a combination graph in excel specifically with the x axis. I have two columns both go to 1000 but currently only have 13 entries the rest will fill in over time.
I have a ...

**0**

votes

**1**answer

24 views

### Excel (If & Randbetween)

I'm trying to generate an IF statement with Randbetween in excel,
=IF(K3:K34=TRUE RANDBETWEEN(L3,L34))
I'm trying to say that If column K3-K34 are true, take the names in the column next to that ...

**-1**

votes

**0**answers

24 views

### How do I hide a row in Excel until I get a specific answer from a drop down?

For example Row 1, Column A shows "have you completed X,Y,Z?". Their options are "Yes" and "No" and in a drop down. If they answer no, I want to have it say "return to X,Y,Z". If they answer yes, I ...

**-1**

votes

**0**answers

20 views

### Conditional if statement not working

Can anyone explain why this expression
=IF(OR(E29=H18, E29>H18),0,150)
... doesn't work when E29-H18?
Thanks.
Patrick.

**0**

votes

**0**answers

34 views

### Formula for multiple choices [on hold]

How to create formula if there's a multiple choices? Like if the amount is 2200 the contribution is .... (need to refer to the table)
Employer amt employee amt
0.01 to 10.00 ...

**0**

votes

**1**answer

34 views

### conditional formating - multicolor text according to different value in same cell

So I am preparing a report of sorts in Excel and was wondering if I can color text in a certain column according to what values are in it using conditional formatting? To be precise there will be two ...

**0**

votes

**0**answers

14 views

### How to maintain Excel-file xlsx -formulae when opening on Chromebook? [on hold]

I have tried now all possible applications:
XLS editor/viewer
Excel Online
But none of those maintain the formulae.
They show only the absolute numerical values.
Opening the file in Windows, I ...

**0**

votes

**0**answers

38 views

### In Excel, how can I center a column, align decimal points, and not show unnecessary decimal places or decimal point? [duplicate]

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 |
This question is not a ...

**1**

vote

**1**answer

24 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

**0**answers

9 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

**0**answers

28 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

**0**answers

29 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

**2**answers

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