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
1answer
11 views

How to get Excel to graph multiple series where series are “mixed” in a table?

I've got a table that contains multiple data series - and they aren't uniformly distributed either. Example below. As you can see there are multiple series here: Income, Short-Term Capital Gain, and ...
0
votes
1answer
20 views

I need to compare one cell (A1) with Group of Cells (C1:L10) if any one the cell is equal with A1 then It automatically increment the M1 cell

Actually what I am going to do is. " I need to compare one cell (A1) with Group of Cells (C1:L10) if any one the cell is equal with A1 then It automatically increment the M1 cell "
0
votes
0answers
36 views

IF cell is green add date

I am looking to have a cell M4 populate when I change either J4, K4 or L4 to a green fill. For example: If I put the date 12-14 in K4 and change the background fill to Green, I want M4 to populate ...
0
votes
1answer
20 views

Excel - Leave cell blank if no date

I am trying to have the day of week displayed in a cell only if there is a date present. In the day of week (H4) cell I have =TEXT(G4,"ddd") which shows they day of week when the date is inputted ...
0
votes
1answer
11 views

Grouping Date/Time by hour in pivot table not working as expected

I have one Excel table appended to another (over 1.1 million rows so can't fit all of the data on one sheet) via a query in excel. I am using this append query as the source for a pivot table. When ...
1
vote
0answers
14 views

Is there a way to dynamically specify an array in Excel?

Yesterday, I found this example of data and some array formulas: The idea is to use a formula to calculate the number of employees in Departments A and B combined. One solution offered was to use an ...
-4
votes
0answers
22 views

Excel formulas in sheet [on hold]

"A" columns lines Value for Negative & Positives Both together. If B column "DT" means, A columns amount should be reflect in C column converted Positive figures only If B column "CT" means, A ...
0
votes
1answer
17 views

Should I use, COUNTIF, Array or something else in my Excel Sheet?

I have a spreadsheet from which I want to pull certain "count" information. In column R I have a list of hours and in column T I have a list of names (an array created from all the names in the ...
0
votes
0answers
19 views

Excel - Combining multiple columns into one field

I have massively simplified the data and changed the industry so I'm sorry if what I'm talking about sounds a little silly, the prices involved definitely make no sense. The main function of my ...
1
vote
1answer
20 views

Excel - pull data from sheet 1 to sheet 2 but in incremental steps

I need to pull from sheet 1 or LIVE INFO down in steps of 28 on sheet 2. Is there away to do this without Index or manually doing it? ='LIVE INFO'!A2 ='LIVE INFO'!A30 ='LIVE INFO'!A58 ='LIVE INFO'!...
-3
votes
0answers
21 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
1answer
21 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 unique ID numbers for items matching "Horse" in column J on Sheet 2!, "Ball" in column I on Sheet 2!, and ...
0
votes
1answer
6 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 ...
-5
votes
1answer
48 views

lame Excel questions about copying rows [on hold]

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
24 views

excel convert number ranges to individual numbers [on hold]

EDIT:3 the problem I have a spreadsheet in excel that contains about 4000 unique parts, each with a reference designation components that have the same part number. I need a method of being able to ...
0
votes
0answers
21 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
22 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
46 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
22 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
37 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
38 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
41 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
14 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
21 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 [on hold]

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 ...
0
votes
1answer
26 views

Excel formula for sum of income over multiple years adjusted for inflation

I have the income X, and the number of years in the future Y, and the inflation Z. I can calculate the compound interest simply by CI(Y) = X*(1+Z)^Y for any given year, but how can I construct a ...
1
vote
3answers
45 views

Find and move only the email addresses from one column to another

I have a client list that contains name, address, city, state, zip code, but some randomly have an email address instead of a street address. I need to move the email address out of the address ...
7
votes
6answers
502 views

Apply any formula n times without using VBA? [on hold]

I have the following cells: A1: justsometext B1: 3 C1: =DOSOMETHING(A1) I want to apply the formula in C1 n times (n being 3, the value in B1), so in this case it would mean: C1: =DOSOMETHING(...
0
votes
1answer
27 views

Excel: Add multiple tables into a single stacked column graph

I have been asked to make graphs of some evaluation forms, however I don't see how to make readable graphs with the data they gave me: Every group has its own little table with data, the graph they ...
0
votes
2answers
52 views

Pivot table cannot create calculated item

I've encountered a problem with pivot tables in Excel. I want to create calculated item, but it does not allow me, as it says This Pivot report field is grouped But it's not grouped in any way. ...
-1
votes
0answers
29 views

Work related project Excel 2010

I am by far not an expert and am only beginning to see the complexity that is Excel. I am trying to write a formula (if it is even possible) that will allow me to make a condition that if a certain ...
2
votes
1answer
37 views

How to handle excel formula references between workbooks kept on SharePoint?

posted this on SharePoint stackexchange but this seems more appropriate Is there a recommended way to link workbooks that are kept in Sharepoint/Teams? I have a setup where many different projects ...
0
votes
1answer
30 views

Match 2 sets of numbers in 2 cells

I have 2 cells with similar data extracted from 2 different websites. Data in D6 is supposedly shorter version of H6. I want to put "Match" or "No Match" in E6. For "Match" either 2 sets of numbers ...
0
votes
0answers
23 views

Combine multiple rows and create columns where data changes [on hold]

I have a worksheet that contains ID multiple times in column A with multiple rows of data. In Column C the Weld# can go from 1-10. I need to keep the spool# that corresponds with each of those upon ...
0
votes
0answers
24 views

VBA - Excel Stops Responding - Table Applied to Whole Sheet?

I have a button that calls many separate macros. Everything works as expected, but with 1 exception. I need to input a formula in row 2 of four separate columns and have the formulas drag down to the ...
2
votes
1answer
89 views

Find position of first uppercase character in excel string

I need to find the position of the first uppercase character in an Excel string. There are lots of resources on the web that have the same (or effectively the same) solution for this: =MIN(IF(ISERROR(...
-1
votes
0answers
22 views

Powershell Excel Refresh via Sharepoint

When I execute the below PowerShell script it keeps asking for the password. How can I overcome this? Script: $libraryPath = "M:\test-3 \ORI List.xlsx" # To view Excel file open need to set below ...
0
votes
1answer
34 views

A text box which is visible across all the worksheets

I have an Excel workbook with 8 worksheets. I want to create a TextBox with an arrow attached to it and place it at the bottom left Corner, right above the worksheet's names. I want this text box to ...
0
votes
0answers
39 views

Excel formula Function [on hold]

I have to update the below user name one by one in 10 counts wise, after make the filter below mentioned points ( A & B Points ) if any formula or VB please help me. SR.NO User Name 1. ...
2
votes
1answer
39 views

Excel for Mac Version 16.18 is dividing my numbers by 10

Excel has just started dividing my entries by 10. If i type '2' in a cell it writes 0.2 and so on. I have no idea what i changed that caused this to start but would love some help to fix this?
0
votes
2answers
20 views

How to make addresses populate from one spreadsheet to another

I have two excel sheets of store #'s/event details and another one of all the store number addresses. Not every store gets an event so just copying and pasting all the addresses wouldn't be an option. ...
1
vote
3answers
37 views

Excel saying too many arguments for IF/AND/MONTH function

I need it to produce orders that are in Canada or Mexico, over $1,000, and in the month of July. The formula I am trying to use is: =IF(OR(A2="Canada","Mexico", IF(C2>1000, "Ship by Air", IF(...
0
votes
1answer
43 views

How to move values from one column to another based on matching values from other columns

Example of what I'm trying to do: Hopefully the attached image helps you understand what I'm going for. I have 2 massive Excel files, one with names & income in the column next to them and ...
0
votes
2answers
30 views

Is there a way to hold multiple values in clipboard and be able to paste any one of them with a simple shortcut [closed]

Is there a way to copy X, Y, Z values to clipboard and be able to paste either one of them with one shortcut on Windows? We all use CTRL+C for copying one value to clipboard and CTRL+V to paste it ...
0
votes
1answer
28 views

Having trouble comparing multiple columns and rows in different worksheets in excel

I have limited knowledge of formulas in excel and would really appreciate help with this question: I have two worksheets: Worksheet1 and Worksheet2. Worksheet A1 shows a list of all the samples that ...
-2
votes
0answers
15 views

My Excel does not show “Allow users to edit ranges” in toolbar

I am running MS Excel for Mac Version 16.16.4 My "Changes" Group is also not available in my toolbar. Please assist if possible. Thank you.
0
votes
0answers
56 views

How do I get one cell to reference two other cells, so its selections change off those two?

I am making a write up sheet for my company for employees. They want me to make it as simple as possible to stop errors. I need help with the employee name selection. Basically, there is 3 positions (...
1
vote
1answer
22 views

Excel command line switches - positions

I notice that when I enter : excel /r "c:\temp1\test001.xls" I get read only. When I enter excel "c:\temp1\test001.xls" /r I do not get readonly. When I enter excel /s "c:\temp1\test001.xls" ...
0
votes
1answer
25 views

Is there a way to colour rows that have an idetical value?

Is there a way to automatically colour rows the same colour if they have a field (like ID) that is the same? So something like this
8
votes
5answers
3k views

Combining first two letters from first name and first two letters from last name

I have a spreadsheet of usernames. The first and last names are in the same cell of column A. Is there a formula that will concatenate the first two letters of the first name (first word) and the ...