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.

-3
votes
0answers
7 views

Change add row behavior in excel

Suppose there is a table as below: I have a function which opens a user form, the user fills in data, presses 'submit' and the data appears in a new row below the heading of the table like so: When ...
0
votes
0answers
4 views

Multiple criteria unique values, and list

I have two issues that I am looking for help with. The first, is to create a dynamic list of results for items matching "Horse" in column J on Sheet 2!, "Ball" in column I on Sheet 2!, and that do ...
0
votes
1answer
4 views

Data labels disappear after I reopen worksheet

I have a worksheet with a scatter chart. On the data series, I added some data labels. I defined the data series x and y ranges to some cells. Since I use this worksheet as a template, the x and y ...
-4
votes
0answers
27 views

lame Excel questions about copying rows

I am working with Excel quite a lot at my work, but I still struggle with some quite basic things (IMHO). An example: I have two big spreadsheets and I want to copy and paste let's say 100 rows from ...
0
votes
0answers
11 views

excel convert number ranges to individual numbers [on hold]

I wish to convert ranges of components into individual numbered components. CR4-7 would go to CR4, CR5, CR6, CR7 This stack exchange thread has one of the best answers I have seen thus far: How to ...
0
votes
0answers
17 views

SUMPRODUCT in row with single array doesn't give result

I'm using SUMPRODUCT to give me the best 5 scores from a possible column of 16. It showed me the result as soon as the 5th score was entered using this formula =SUMPRODUCT(LARGE(V6:V21,{1,2,3,4,5})) ...
0
votes
1answer
19 views

Filtering in excel by last two characters that are alphanumeric

So I have a large spread sheet of warehouse locations that I need to sort by the last two digits and I need to filter on the ones that are alpha numeric. Below is the example of what i'm looking at. I ...
-1
votes
2answers
31 views

Writing an IF() formula to use an alternate cell if the primary cell doesn't have a value

I'm trying to write a formula to subtract two cells but only if they have values. If there isn't a value in one of them I want to use a different cell in the subtraction. For example: | A | ...
0
votes
2answers
17 views

Excel auto incremental number in a formula

I need to make a formula that has a number in it which I would like to be auto incremented once I hold and drag the formula along a row. For example my formula (simplified) is: =500 + 1 And if I ...
2
votes
1answer
27 views

Copying a range using Combo Box criteria

I'm trying to copy a range that meets two criteria from two combo boxes on a user form. ComboBox1 contains criteria 1, the Branch. ComboBox2 contains criteria 2, the Quarter. Column A needs to match ...
2
votes
0answers
26 views

Excel 3D Flat Map

I am trying to display some data on the flat version of the 3D map. But unfortunately the map cuts off down the middle of the pacific ocean so half my data is on one end of the map and the rest on the ...
2
votes
1answer
36 views

Convert large data set to rows of comma separated lists

I have a large amount of data (41k+ rows) that is exported by the company's sales management system, assigning each salesperson to a zip code in the United States. It looks like this (every column has ...
-2
votes
0answers
22 views

Sort on columns that look like they have spaces but do not

I need to sort a column to delete all bold cells. My issue is some of the rows look like they have a space or two, or indentation, but when I click in the cell they do not so sorting isn't helping at ...
0
votes
0answers
13 views

Possible to group rows but keep originals in Microsoft Excel pivot tables?

I've created a pivot table with a number of states and their associated data; let's say the 50 US states. I'd like to group together certain of these states, but also have the original states rows ...
0
votes
0answers
20 views

In the same worksheet of Excel, I need to pull data from a cell and have it copied into another cell as I type it in

I will try to explain this as simply but as detailed as possible. Data(data will be letters not numbers) in cell A1 will have corresponding data for cells F1 and G1. There will be more data in A1 ...

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 |