# 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

17 views

### Excel formula Function

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

**0**answers

13 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

**1**answer

11 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

20 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

16 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

23 views

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

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

25 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

12 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

42 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

14 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

24 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

**6**

votes

**4**answers

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

**0**

votes

**2**answers

26 views

### Finding the difference in quantity of matching items from two sheets

I have two different sheets in Excel with two columns in each sheet. The first column contains the name of the item and the second column the quantity.
How do I get the difference in the quantities?
...

**0**

votes

**0**answers

30 views

### Excel 2016 Power Query “Get Data From Web” getting wrong data from skyscanner.com

I am trying to get a table data from skyscanner using MS Excel 2016 Power query.
I am trying to get the following data table form this link
Skyscanner.com link
https://www.skyscanner.net/transport/...

**0**

votes

**0**answers

11 views

### Automatically update a Power Query after data was changed in source(another sheet in same workbook)

I have two sheets in a workbook. 1st sheet is data source for my Power Query. I created this Power Query by selecting my predefined table then Data >> From Table/Range and then I load this query into ...

**2**

votes

**0**answers

18 views

### Prevent MS Word Linked Tables from using Sharepoint Link

When I shift+F9 on a table in a word document I've linked to a local excel document, it seems to prefer to use the sharepoint web address rather a local or relative address. How do I force MS word to ...

**0**

votes

**0**answers

31 views

### Comparing two excel files and highlight the difference [on hold]

I have limited working knowledge of Excel and I hope someone will be able to help me with my problem.
I have two files (say F1 and F2)
F_old
Clint_Naem | Address | Postcode
clint01 ...

**0**

votes

**1**answer

35 views

### Identify gaps in a sequence in one cell - Excel

I have a list of items in my Excel sheet that are numbered, together with a total number, in the following way:
Example:
| Column A (available) | Column B (missing) | Column C (total)
___|...

**1**

vote

**2**answers

30 views

### File Association .tsv to excel

Im sorry i know this question gets asked alot but i have tried many diffrent things and nothing seems to work. But i am trying to get .tsv files to open with Microsoft Excel. I created a .tsv file on ...

**0**

votes

**0**answers

38 views

### EXCEL: SUMIF In Array Formula Causing Errors (Bug?)

I have noticed that SUMIF does not play nice with array formulas.
To save on convoluted explanations of my motivation, here is a sample that demonstrates the issue:
=SUMIF(ROW(INDIRECT("1:10")),"<...

**0**

votes

**0**answers

29 views

### Excel Resizing axis label area

How do I resize the axis label area and make the long labels wrap?
The textbox formatting options are grayed out.

**1**

vote

**2**answers

37 views

### Comparison of strings containing inequalities in excel countif() function

I'm analyzing some survey data in which the responses are in the form of a string containing inequalities, e.g.
a) < 5
b) 5-10
c) 11-15
d) > 15
I'm attempting to tabulate responses using the ...

**0**

votes

**2**answers

25 views

### Microsoft Excel 365 column totals

Creating a spreadsheet to track quotes.
I have multiple columns of information.
One has the item name, Next is the quantity required for that item, next column has the price of each part.
Each ...

**0**

votes

**0**answers

15 views

### Excel - Embedded PDF - “Change Icon” file name

Weird one. I am running a Win10Pro system with Office 2013 and Adobe Reader DC.
Whenever I embed a PDF object into Excel, the 'first' part works fine - I get a normal icon.
However, when I try to ...

**-1**

votes

**2**answers

24 views

### Excel: In which month, has my web page generated the most traffic (from 3-year data)?

In column A, I have a list of months in the format of YY-MM.
In column B, I have a list of unique users that visited a site page during each month
(Nov 2016- Nov 2018)
I'd like to know, on average,...

**1**

vote

**1**answer

32 views

### Is the 64kb size limit to modules corrupting macros for excel 365?

I'm having random macro corruptions where I can't open the workbook.
I would have to disable all macro without notifications then open the workbook and recompile the macros, save close. Then enabled ...

**2**

votes

**1**answer

26 views

### Delete all rows not containing xxxx

I found and modified the below code to remove all rows that don't contain "NHO_Global" in column F, but it deletes everything (it does leave the header row, though).
What did I do wrong and how can I ...

**0**

votes

**3**answers

62 views

### Sum rows based on criteria in columns

I'm stuck with a problem,
I have two sets of data like below:
How can I find if the sums of column "a" based on ID in Table 1 are equal to column "b" based on ID?
I'm assuming i need a Sumif and ...

**0**

votes

**1**answer

21 views

### Counting duplicate values in a sequence - for football scores

I currently have a column of values like the one below, listing the outcomes of football matches.
Lost
Lost
Lost
Won
Drew
Drew
Won
Won
Using this formula, I've been able to calculate where a ...

**0**

votes

**1**answer

33 views

### Regular Crashing in Excel - Possible cause referencing entire column

I've been using Excel from Office 365 for the last 2 years on Windows 10 and get crashes almost daily. I need to have several workbooks open at any one time but don't see why this should be an issue ...

**0**

votes

**1**answer

21 views

### Splitting data in the same category to a new workbook

I need to split data for each country into a new workbook with the headers as well. as the countries have different number of rows, how can I split according to the country. Also, sometimes there are ...

**-1**

votes

**1**answer

43 views

### What is Excel #N/A error abbreviation, looking for?

In MS-Excel we have below functions return errors:
#N/A #REF! #NAME? #DIV/0! #NULL! #VALUE! #NUM!
I think about what is the complete error massage, which each one are represents?
Of ...

**0**

votes

**1**answer

35 views

### Excel - Search for a string then add some values (Entered to many arguments)

I have 5 sheets with country data, I want to lookup the country name on 4 separate sheets within 4 separate ranges then take a value from the row and add all those values.
I was getting #NA as a ...

**0**

votes

**1**answer

29 views

### text to appear in a cell upon input of yes in a cell

Hi I need a fix to this please help with a formula.
Please refer above picture.
on input of yes in I 8709 i want the word "printed" in J8709

**2**

votes

**2**answers

69 views

### Excel - forecast future date based on average number of days between a variable number of dates in the past

I have anywhere from two to six dates for events in the past and based on the average spread from each one to the other, I need to predict when the next event will occur.
From the screenshot, I ...

**0**

votes

**1**answer

16 views

### Excel, See if Sheet A is referenced elsewhere in Workbook

I have a fairly large workbook. Is there a way to check if a certain sheet is referenced by any other sheets ie via formulas?
For example I have a large dataset in Sheet A, but all the other sheets ...

**0**

votes

**1**answer

21 views

### Extract Unique Substring from Range of Excel

I have cell values with names that are fairly close to each other. I would like to extract a common sub-string.
Here is an example.
1100_250_Jump_12HR_100MD_S_run1
1100_250_Jump_12HR_100MD_S_run2
...

**0**

votes

**1**answer

21 views

### Excel file, want to keep ID cell when filtering columns

I would like to filter column D , But need to keep the id from Column C to show. The easy way would to just have the column C list the code for each row, but that gets confusing when trying to get a ...

**0**

votes

**1**answer

32 views

### Copying values from multiple sheets

I have an excel document with lots of sheets named city1, city2 etc. The data for each city has the same cell. Population is in city1!B3, city2!B3 etc. I have 10 other variables on each sheet that I ...

**-1**

votes

**0**answers

16 views

### Leader board rank system in excel [on hold]

Can anyone tell me how to build a formula in Excel, that will allow to me to take team points and rank from first to last?

**0**

votes

**1**answer

15 views

### Create a rights/responsibilities Matrix in Excel

I want to create a nice overview of responsibilities in a system, and I have received an output of responsibilities entries in the system in the format of rows of username, responsibility description ...

**0**

votes

**2**answers

46 views

### Filtering By Values in Excel Pivot Table

I have a spreadsheet containing columns for Timestamp, Company, UserID. Each row in the spreadsheet indicates that a given user from a particular company has performed an action.
I've created a Pivot ...

**-1**

votes

**0**answers

36 views

### Uninstall Unlicensed Microsoft Office on New Dell PC [on hold]

I have a new PC with Windows 10, and I have installed Office 2010. Every time I dbl-click on an .xlsx file, it launches an unlicensed copy of Excel with limited capabilities - looks like 365 or 2016. ...

**0**

votes

**0**answers

23 views

### Using Excel Data a Single time

I have multiple task I want to assign to multiple people that are only available on specific days. These task have variable work to be completed, and specific date time frame they need to be ...

**0**

votes

**2**answers

34 views

### Can somebody say what is wrong with my nested IF function for excel?

I have the following function:
=IF(B4<5, "Excellent", IF(OR(B4>5, B4<7), "Good", IF(B4>=7, "Satisfactory")))
I want to to give excellent if the cell value is less than 5%, given Good if it is ...

**1**

vote

**1**answer

35 views

### How do I use Excel to produce a table showing what plant species are likely to be present based on location and habitat?

I'm a botanist and I am trying to produce an Excel table that filters a very long list of species based on location and basic habitat.
I have created a master table with 200 rows for each species ...

**0**

votes

**2**answers

30 views

### Excel check if combination of data exists in a certain range

See question 1337631
Check if a specific range of values in one dataset exists in another dataset
This solution works great, but what if you want to check WITHIN the same range?
Want to use this for ...

**0**

votes

**0**answers

19 views

### Is it possible to change/save default “Web Query Options” in Excel

Does anyone know is it possible to save or change the "Web Query Options" default settings. I want that "Disable date recognition" is always checked.
Any solution is welcome, even if it should be ...

**0**

votes

**0**answers

16 views

### Excel: Is it possible to set some cells on a different z-index? [closed]

In order to ease a task, I would require to set a portion of an excel sheet onto a different "z-index" (took from CSS z-index logic).
Basically, my requirement, in order to be satisfied, is to being ...

**1**

vote

**1**answer

20 views

### How to use the function keys in Excel on a Mac?

I have just transferred from Microsoft to Mac.
On my MacBook Pro I cannot use the F# keys in Excel. I used to use F4 to repeat the last action and F9to recalculate.
I have found that CMD+Y does ...