The 2013 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

2 views

### Pivot Table and hiding 0 values in columns

Have a pivot table that counts resources from different locations by month summary such as:
February March April May...
Toronto 10 10 11 11
Montreal 0 0 ...

**1**

vote

**1**answer

35 views

### Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...

**0**

votes

**0**answers

24 views

### How do I stop excel duplicating values in VBA?

I run a code that groups same products together and total quantities of those products. However It only works if all items are filled in if not it duplicates. For example:
Instead of
Product 1 ...

**-1**

votes

**1**answer

9 views

### Conditional formatting (alternating between only two colours) of rows depending on cell values

How do i get conditional formatting done depending on values of cells.
I need to get the cells (and their rows) formatted in only two colours
Say,A1 has Colour1
if A2=A1, then A2 should get ...

**0**

votes

**1**answer

19 views

### How to get latest date (most recent date) in Excel?

I have two dates in one column.
I want get last date (large date or the most recent date)
so when I use =MAX(A1:A10) it returns a value (42343) like this or similar.
How to get the latest date by ...

**1**

vote

**1**answer

27 views

### Excel 2013 - Creating 2-data series chart with column width is dynamic (depend on variable)

Using Office 2013 suite (Excel 2013), how to I create x/y graph, we additional dependencies where X columns widths dependant on additional value?
For example, from values such as:
Height Width
...

**0**

votes

**1**answer

19 views

### How to return the name of uniquely named sheet

So I've searched high and low and cannot seem to find an answer to this question. Spent almost two days trying every thing I could find on line, but none were specific enough to my situation. Without ...

**1**

vote

**0**answers

12 views

### Refresh data in depth trough multiple closed workbooks

Situation
I have 3 Workbooks in the format .xlsx, Source, Manipulation and Result.
Result has a link to a cell in Manipulation wich again, has a link to a cell in Source.
As the data is manipulated ...

**1**

vote

**2**answers

39 views

### Excel formula to convert date formats

Assuming I have cells that have text values mentioned as:
02/23/15 to 03/01/15
Can I use excel functions to convert this to something like
23-Feb-15 to 1-Mar-15
So far I have looked at formula ...

**0**

votes

**0**answers

6 views

### Why does re-applying filter in Excel 2013 takes the cursor to the start of the document?

I have a sheet with columns through A to J, running into thousands of rows. When i try to reapply a filter, first by removing the filter and re-applying it again, excel changes the view of the ...

**0**

votes

**0**answers

14 views

### Excel Template Show Associated Tasks

I found a template in excel 2013 called "Weekly Time Planner". It has a mechanism that filters another table when clicking upon a certain item. For example, I select one project in the project ...

**0**

votes

**2**answers

25 views

### Excel Equation: How to skip cell value if row header contains certain text

So I have a workbook for tracking my inventory in real time. It's a really bad bandaid for a problem I cannot have addressed at the moment, so bare with me.
The issue is, I want to have my inventory ...

**0**

votes

**1**answer

39 views

### Search cells in excel [on hold]

I have an Excel workbook with multiple worksheets. I'm using Excel 2013. First worksheet contains the list of items.
The other worksheets contains the same items but in scattered fashion (with lot of ...

**-1**

votes

**2**answers

36 views

### Excel addins for office 2013 [closed]

We have on hand some custom-made Excel add-ins that were designed to work with Excel 2003. We would like to upgrade to Office 2013, but the add-ins do not function properly in the new version. Is it ...

**1**

vote

**2**answers

45 views

### How to avoid opening a workbook referenced in vlookup between 3 workbooks

Situation:
I have three excel workbooks of which Workbook1 and Workbook2 contain my data. In Workbook3 there is a VLOOKUP which references to the data in Workbook1 and Workbook2.
All of that works ...

**0**

votes

**0**answers

11 views

### how to use =TEXTREVERSE() of morefunc add-in in Excel 2013?

I recently installed morefunc add-in in Excel 2013 but I don't know how to use it.
I saw tutorial to use it in Excel 2003/2007 but I can't find the way to use morefunc in Excel 2013.
how to use ...

**1**

vote

**1**answer

20 views

### Alternative to cell highlighting using conditional formatting in Excel without causing freeze/crash

In column A, I have a value and I want to highlight if it doesn't match the same value in column B.
I'm using the formula below in conditional formatting which works great.
...

**1**

vote

**0**answers

22 views

### How to extract only missing records from two given spreadsheets? [closed]

I have been provided with two spreadsheets, the first spreadsheet contains information about the member and the other contains the attendance on a particular day. Both have a common unique field which ...

**4**

votes

**3**answers

31 views

### Excel 2013 - Is there a way to turn off a chart series without removing it

This past year i finally switched to Excel2013 from Lotus123, the only task i miss from lotus (that i can't figure out how to do in Excel) is; when formating charts and creating copies of charts it ...

**0**

votes

**0**answers

11 views

### Excel CSV/Text data from clipboard [duplicate]

How can I insert CSV data from clipboard into Excel 2013?
In OOo Calc I can just use Ctrl+V, and Calc automatically opens an Import wizard with a ton of options and a preview screen.

**0**

votes

**1**answer

35 views

### What am i missing? You've entered too many arguments for this function - nested IF statement

I am running into the 'you've entered too many arguments for this function' error and cannot figure out why. I've got my nested IF statements and the AND statements for the necessary scenarios I ...

**-1**

votes

**0**answers

12 views

### Is it possible to Hide columns in Excel from some users with a password?

I have some columns which should not be seen by some users of this Excel spreadsheet. Is it possible to hide them with a password?

**0**

votes

**1**answer

45 views

### Excel: How to search multiple workbooks for Cell information

Good Afternoon
Currently we receive e-forms filled out with excel from our customers, so I have a folder filled with workbooks.
Each workbook has multiple sheets.
I need to search through each of ...

**0**

votes

**1**answer

19 views

### Use AVERAGEIF across multiple cell ranges in a worksheet

I am using AVERAGEIF using the following to return the answer
=AVERAGEIF('Sheet 2'!H3:K10,I9,'Sheet 2'!K3:K10)
This works well if I have all the information in one sheet, however I have the ...

**0**

votes

**1**answer

25 views

### Why doesn't this array formula work when cell reference contains a formual?

I have created an array formula (first formula below) to return the nth value in Data!B:B based on the date value in B4. The formulas appear to work when I have the date in B4 but if I use the second ...

**0**

votes

**1**answer

32 views

### Excel VBA Insert Rows above Cells with specific Formatting [closed]

I am not very good in VBA but I already looked for an answer online for hours. Hope you can help me.
I would like to insert rows above cells that are filled with a specific color (two different ...

**0**

votes

**1**answer

35 views

### Format range that is dynamically based on other cell values

Take the following excel spreadsheet into consideration:
I would like to format the cells in row1:2 according to the values in cells A4:B7. If I change the values, the cells in row1:2 should be ...

**0**

votes

**1**answer

26 views

### Why are filters in an excel sheet showing unmatched rows?

I've an excel sheet with around 1000+ rows. I've applied filter on the first column with value "GS1 - Indian History". It is just supposed to show 16 rows, but it is showing rows containing other ...

**0**

votes

**1**answer

38 views

### Macro in Excel to add the date in ISO-8601 format

For some reason, Excel forces me to use my region for footers when I insert the date. However, it also doesn't auto update when the worksheet opens. Without the formatting this is a rather trivial ...

**0**

votes

**3**answers

21 views

### Quickly delete all floating picture in Excel sheet

I have a lot of photos in my Excel sheet.
I want to delete them all - currently Ctrl-A just select all cells.
How can I select all photo objects?

**-1**

votes

**0**answers

11 views

### How to click on a linked cell without opening the target URL in Excel?

My spreedsheet has lots of cells containing linked URL - when clicked, the web browser will be opened.
This is annoying since I just want to click on the cell to copy the values.
How can I click on ...

**-2**

votes

**3**answers

87 views

### How to fix the #DIV/0! error in an Excel document as a whole?

I've seen instructions on how to get rid of the #DIV/0! error on a single cell, but I'm looking for the easiest way to deal with all errors at once in the whole document.
The reason for that is the ...

**2**

votes

**1**answer

27 views

### Excel Filter and join between multiple tables

I'm reasonable user of Excel (definitely not very skilled though) - I'm using Excel 2013.
I'd like some assistance on how to achieve what I need on table controls. I've created three tables.
...

**2**

votes

**1**answer

26 views

### Tricky cross table excel function

I'm trying to set up a table column in excel to check for matching names between the name columns of both tables, then return the total from the second table.
Currently this works, but I can't sort ...

**0**

votes

**1**answer

25 views

### IF AND conditional formatting not working - Excel 2013

Okay so I’m trying to format cells that are blank and meet the logical test. Here’s the formula:
=IF(AND($B2="Y", ISBLANK($C$2:$F$172)), TRUE, FALSE)
If both tests are true (B column = Y and there ...

**0**

votes

**1**answer

33 views

### Highlight Data Points in a line graph on excel 2010 or 2013

I have a line chart (two series of data) and I need to highlight a specific point in the data. Is it similar to the bar chart where you can just change the color or is there something different?
...

**0**

votes

**0**answers

36 views

### Prevent Excel from changing formula of last row of table when adding a new row

I have a table with columns named "date", "cost" and "daily". "Date" is a date, "cost" is a number and "daily" is a formula calculating the total cost of each day. The formula looks like this:
...

**0**

votes

**1**answer

32 views

### Excel Macros 2013: Is it possible to create a Macro that, with the shortcut key, formats an input value between Whole int and 2 decimal places

I am attempting to create an Excel spreadsheet which holds information of students data, currently I have rounded all data to the nearest whole int.
What I wish to know is whether there is a way to ...

**1**

vote

**0**answers

33 views

### Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may ...

**0**

votes

**1**answer

11 views

### What is Excel formation expression to manually format number values?

Since using comma button on the ribbon to format numbers will stop left-aligning the cell, as discussed here, I need to know the formation expression to enter it manually to the custom box.
I guess ...

**0**

votes

**3**answers

51 views

### What combination of keys do I need to enter complex formula in a cell?

I've created a conditional SUM formula:
=SUM(IF($G$14:$G$5002="Liz S Salary",IF($Q$14:$Q$5000>=Summary!$F$6,IF($Q$14:$Q$5000<=Summary!$F$7,$R$14:$R$5000,0),0),0))
The formula needs to be ...

**0**

votes

**1**answer

20 views

### How to get Excel format left-aligned for numbers?

I love to format thousands by using comma by hitting the comma button on the ribbon.
And that will right aligning my numbers.
How can I left align those?

**0**

votes

**1**answer

24 views

### Worksheet function to check if cell contains only characters as defined in a constant string

I have this string constant: abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890' -
Now for each cell in column A I want to check, in column B, with a worksheet function, not a Macro, if ...

**-1**

votes

**0**answers

13 views

### Is there a way to refer to cells “one worksheet to the left” in Excel?

As opposed to in a specifically named worksheet, can you have a reference to "the sheet to the left of this one" ?

**1**

vote

**1**answer

24 views

### how to find partial text in excel

I have two columns "A" & "B". Column "A" contains Complete Text (1000 line items) & Column "B" contains partial text (250 line items). How I can find & place all Partial text(Column B) ...

**0**

votes

**1**answer

76 views

### Excel auto format cell's font size based on number value?

I want to make cell's number values to be smaller, in font size, with small values i.e. the bigger the cell value is, the bigger is the font size.
I can only find Data Bars in Conditional ...

**0**

votes

**2**answers

29 views

### How could I set a Text Highlight Color—not cell shading—for a specific text within an Excel cell?

How could I set a Text Highlight Color—not cell shading—for a specific text within an Excel cell?
Illustrative Example:
This is a screenshot from OneNote of what I need to do on Excel also: link
...

**0**

votes

**1**answer

24 views

### How to summarise costs for one week, given an irregular range of dates and costs?

I have a table of all the money I've spent on given dates, from receipts etc. The dates aren't regular, so the table may look something like:
A B
╔════════════╦════════╗
1║ Date ║ ...

**0**

votes

**1**answer

29 views

### Can I use VLOOKUP to return a table name that is then used in an INDEX formula?

I have an INDEX formula like this:
=INDEX(Data3,MATCH(G4,Sheet2!$A$14:$A$17,0),VLOOKUP(F4,Threshold,2,TRUE))
However, I want to apply this to data where the table I want the INDEX formula to ...

**0**

votes

**0**answers

14 views

### Change default properties of shape objects

When you insert a shape object in an Excel workbook, by default it will be set to "Move and size with cells" and "Print object" will be selected (Format Shape -> PROPERTIES).
Is there a way (without ...