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.

0
votes
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
2answers
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 ...

15 30 50 per page
 Microsoft office activator |  windows activation crack |  windows product key |  windows 10 product key |  windows 7 ultimate product key |  windows 7 keygen |  activate office 2010 |  office Project keys |  project professional product key |  office 365 office 2016 office 2013 key |  office 2016 office 2013 key |  windows 7 professional product key |  windows 8 professional product key |  windows 10 professional product key |  office 2016 professional product key |