**0**

votes

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

40 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

**0**answers

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

**1**answer

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

**0**answers

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

**4**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

31 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

**2**answers

35 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

**1**answer

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

**2**answers

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

**0**

votes

**0**answers

28 views

### Transpose 1 of 2 label columns

I have a table that has 2 label columns and then a series of data columns formatted as such. And I have nearly 20,000 rows, 900+ Accounts and 16 Quarters, so serious amounts of data. Not something I ...