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