# 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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**3**answers

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

**6**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**5**answers

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