Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
23 views

Formula for COUNTIFS excluding another column

I'm trying but failing to work out a formula in Excel 2007. I have an large area of data that isn't in a table format. The main columns I care about are: chapter title (text), number of tasks ...
0
votes
1answer
18 views

Nested If Statements Without Invoking Circular Reference Error [closed]

I have a formula that calculates perfectly, except in one case near the end where it becomes negative. I was wondering if it would be possible to have the cell containing the formula say "If this ...
1
vote
1answer
18 views

Get conditional formatting to analyze rows separately

I have a calendar and I am trying to fill the background of the cells based on dates on another sheet. I have gotten it to work by entering the dates in a columns, naming the range (lets says ...
-2
votes
0answers
25 views

Excel to Powerpoint [closed]

Im an intern at a ecommerce company, and every day i have have to produce 80 Powerpoints from data that i recieve in an excel file. So i have an powerpoint template, where i need to change 10 fields, ...
1
vote
1answer
39 views

How can I stop Excel from opening a second blank window when opening a file from Explorer?

When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does! This seems to be a common issue: ...
0
votes
1answer
29 views

What's more efficient, array formulas or individual formulas? [closed]

Simple question: When adding, multiplying, or otherwise doing simple operations on two ranges is it better to use array formulas or individual formulas? =A1+B1 =A2+B2 =A3+B3 vs {A1:A3 + B1:B3} ...
0
votes
1answer
24 views

Combining Excel Formulas

I'm trying to do something on Excel which isn't working. I've managed 2 separate formulas that work separately but can't figure out how to combine them. Separate formulas are: =IF(K3>I3,"","Yes") ...
0
votes
2answers
24 views

How to parse file datetime in Excel

I am trying to convert a text string like this - Dec 15 21:44 into a date/time format in excel (Polish version). I tried =DATEVALUE function but without success.
0
votes
1answer
20 views

Trying to do a vlookup on 3 worksheets in the same workbook

I have 3 worksheets in an excel 2007 workbook. I am trying to use a vlookup to see if there are any duplicates in all 3 worksheets - same column. I just need it to to tell me what the duplicates are, ...
0
votes
0answers
35 views

Open Excel links in other than default browser

I have many hyperlinks to web pages in an Excel file and I want to open those links either in IE or Chrome depending on the link. Most of my links I use I have no issues with opening the default ...
0
votes
1answer
10 views

Excel Pivot tables - car type and average speed - counting data according to filters

I have two columns of data: Car type and average speed (mph). I am looking to arrange data in terms of car type and average speed. However, the average speed needs to the grouped into bins. For ...
0
votes
0answers
31 views

Why Excel sometimes changes cell formats after reopening file? [duplicate]

My System: MS Office Excel 2013 on Win7 64bit. I have an excel xlsx-file with different cell formats like General, Currency_USD, Currency_EUR, Number (no decimal places), Number (2 decimal places). ...
1
vote
1answer
35 views

Excel - if cell is empty AND if cell is empty - Colour Row

I'm a complete novice when it comes to conditional formatting. I've found a similar question that allowed me to change the colour of the cell, but not the row. Here's a snipped of what my sheet will ...
0
votes
2answers
30 views

Create Excel chart showing % change (multiple industries) over time

I'd like to create a chart that shows changes in percentage for several industries over a number of years, similar to this example: I've attempted to arrange my data to make it easier to chart, ...
0
votes
1answer
22 views

Unable to do an arithmetic calculation in MS Excel

probably not relevant. my laptop is win8.1, lenovo yoga11s. the excel version is excel 2010 I am doing this chem lab report and I need to do some simple arithmetic calculation. I need to subtract the ...
0
votes
1answer
40 views

How to plot IP address frequency distribution chart on Excel or Calc?

I have one column of data: IP Address 1.2.1.2 1.2.1.2 1.3.4.1 1.3.4.1 1.3.4.1 1.3.4.1 1.3.4.1 1.10.0.5 1.10.0.5 1.10.0.5 2.1.2.1 2.1.2.1 12.1.2.3 12.1.2.3 12.1.2.3 12.1.2.3 12.1.2.3 12.1.2.3 12.1.2.3 ...
0
votes
0answers
34 views

copy and paste according to a order in a column

I want a macro that will fetch data from Series B and Automatically paste it according to the serial of Serial A. ASeries B and Series A data are same but Series B is not ordered. So i'm looking for ...
1
vote
1answer
12 views

What's the difference between “Edit Links” and “Update Links” in Excel?

I have several large, complex Excel files with lots of embedded graphs that I have added to over time. When I open the files, I get a window with options to edit, update, or ignore links. The ...
-1
votes
1answer
23 views

Is it possible to format a cell using a formula?

Example: I want to type a number in a cell and have it subtract a fraction and display the result, all within the same cell.
0
votes
2answers
32 views

combination of min and if for dates

its my first question here.............. Que.:- I have 100s of dates in column A. I want to record next Sunday on 1st day of any month. in cell B1 I putted a formula ...
0
votes
1answer
21 views

How to make a custom selection on excel?

Is it possible to make a custom selection on a spreadsheet and in particular on excel ? If yes, how to do it ? (for example, I would like to select one cell on 3 among a column or select only the ...
1
vote
1answer
13 views

Is it possible to add a hint onto an encrypted Microsoft Excel document?

I have an encrypted Excel document and I don't want to forget the password. Is it possible to put a hint on the password, to help me remember it. I'm looking for something like the Windows log-in ...
0
votes
1answer
19 views

Excel 2010 - Pasting as picture without gridlines without having to turn off gridlines setting every time

I am trying to paste part of a worksheet as a picture into word without gridlines showing. I know that you can uncheck the grid lines check box in the view tab, but I dont want to have to do this ...
-3
votes
3answers
33 views

How to Change any quantity greater than 0 to Yes in excel

How would I change any cell in a work sheet with a quantity greater than 0 to the word "YES"
2
votes
1answer
45 views

Why is my formula pulling the result CELL NAME and not the value of that cell?

I am creating a worksheet that compares two sets of data pulled on different dates. The column that everything pulls off of is created by an array formula comprised of combined unique values from the ...
1
vote
2answers
59 views

Need an Excel Macro to sum a variable length range

I am trying to create a Macro that is able to recognize how many rows have values above it and only sum that range. If you look at the attached image, I need to be able to click in cells B4, B10, and ...
-1
votes
1answer
37 views

How can I translate SQL to Excel formulas?

I have an excel sheet with raw data and I want make a custom view on it in another table for reporting purposes. How can I translate the following pseudo code to Excel? select ColA, ColB, ColC from ...
3
votes
1answer
39 views

Excel - How to create a stacked radar chart?

I am trying to create a stacked radar chart in Excel similar to this: . I have to fill color in the space between the red and blue lines. I have tried every which way I can think of but to no ...
0
votes
1answer
24 views

Microsoft Excel Query - Formatting Columns

I have got an excel sheet data that looks like this: Order Id Rate Item Quantity XXX 4 Ball 100 XXX 4 Hockey 500 XXX 4 Hockey 500 AAA ...
1
vote
1answer
42 views

Is it possible to hide #VALUE! in a cell?

In A1, I input 1,2,3,4 and so on. B1 remains blank because this is where I will enter a number (qty). C1's content is: =IF(ISNA(VLOOKUP(A1,'Item ID'!$A$4:$E$11166,3,FALSE)),"",(VLOOKUP(A1,'Item ...
0
votes
1answer
23 views

If statement in excel 2007

I have a if statement in a cell that looks for the value in two different cells depending on which one is >0. Both target cells have a formula that selects a value based upon the value of the cell as ...
0
votes
1answer
41 views

How to set an excel cell's value programmatically without using VBA

I want to be able to change the value of a cell using a test conducted in a different cell. For instance, something like the following. A B 1 do =IF(EXACT(A1,"do"), set(P5="it was ...
0
votes
0answers
16 views

Referencing a pivot table that will be updated continuously on a Mac

Suppose I have the following pivot table: Percentage 1 and Percentage 2 are growth percentages from one month to the next. What I need to figure out is how to reference the average of these values ...
0
votes
1answer
22 views

Excel: Find and Replace - Adjacent Columns

In excel, after I search and click "find all", I want to see the matching adjacent column values in the results list (so I can compare them). Is there a way for me to archive something like this? Or ...
2
votes
0answers
37 views

Tracking & Synchronization of Multiple Sheets with a Master Sheet

I often run into situations where information on a spreadsheet needs to be broken up and distributed to separate organizational units, but at the same time I need to be able to comprehensively track ...
0
votes
4answers
46 views

How to get current document path to clipboard in Microsoft Office applications?

How I can get full path of current document into clipboard when working with Microsoft Office applications? I'm mostly interested in Word and Excel. Example: I have open the following file in Excel: ...
0
votes
1answer
20 views

How do I insert another segment into the radar pie chart that is shown on this site?

I came across this tutorial for creating a radar pie chart, and let me say it is fantastic! The problem I'm having is that I need the chart to contain 10 or even 12 segments, but I cannot figure out ...
1
vote
0answers
23 views

Excel VBA that calls Powershell ActiveDirectory cmdlet, but Module won't load?

I have a powershell script I use to dump user and computer lists to csv files; it works great and I don't want to touch it much. It uses the ActiveDirectory cmdlet, and the Get-ADComputer and ...
0
votes
1answer
45 views

Combine duplicates in Excel based on values from 2 columns, produce the sum and and % from others, remove dups

I have been struggling with my Excel report trying to roll up duplicate rows based on 2 column values. Also need to calculate the sum of the 3rd and 4th column and calculate the percentage. Here is ...
1
vote
1answer
17 views

How do I keep Excel from changing my date format?

Pretty basic question for a more advanced user than me but I can't seem to find an option. I am working on an order form for my clients to fill out by plugging data into a preformatted spreadsheet. ...
0
votes
1answer
25 views

Excel IF Statement identify when cell has contents [duplicate]

How do I tell MS Excel to use the contents from one cell if data exists (this data can be positive negative or zero). If the data does not exist in said cell, use contents from another cell?
0
votes
0answers
8 views

Hide Some Data Labels but Not Others

I've created an excel graph that has colored bars based on their values. There are 6 series: 5 4 3 2 1 NA. I have figured out how to hide the zeroes when they show up in the 1 2 3 4 5 series but can't ...
0
votes
1answer
16 views

Combine GoogleSheets functions

I'm trying to combine multiple functions into one formula in GoogleSheets spreadsheet. I've tried learning more from Google's Help center and through YouTube but didn't came to satisfactory result. ...
0
votes
1answer
12 views

Excel 2013 time enter function

I want to enter hhmm and for it to appear as a time for example; 1233 12:33. and 2245 as 22:45 Then I will need to plot these times on the x axis of a graph. Any ideas?
0
votes
0answers
59 views

Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version. They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content. ...
1
vote
2answers
30 views

How to create a product list with ONE owner, from a list of multiple owners?

I have a list of products in A2:A21 (A1:M1 is the titlebar). Behind these products are the names of 12 owners (B2:M21) who can repair these products. BUT... not all owners can repair every product. ...
0
votes
1answer
32 views

Convert text string in Tuesday, January 27, 2015 - 1:00 AM format to mm/dd/yyyy hh:mm format

I have a text string like "Tuesday, January 27, 2015 - 1:00 AM " and need help to convert this to a time stamp in excel. I have tried to do text to columns and able to get the date piece, but having ...
0
votes
2answers
36 views

How to remove rows that match?

I have a csv file with list of people (first name, last name, email) and then later on I will get a list of people in another csv file that unsubscribed ( only one column with email). Q: How can I ...
0
votes
1answer
20 views

Why is sharepoint (onedrive) giving the error “Links to external workbooks are not supported and have been disabled” when there are no external links?

I have tried everything I can think of, and everything the internet has to offer: Find function Go-To Special, Objects - manually inspect each An add-in for finding external links Manually searching ...
0
votes
2answers
29 views

In Excel, how do I get a list of cells to display based on an if function?

I have a list of quantities with a description column. It's counting doors based on size. I'd like to output a list (preferably separated by commas) of the description numbers with applicable numbers. ...