The 2013 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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