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
18 views

IF statement error message in Excel

The following formula is returning a #VALUE! error. =IF(L$3<$H11,4*5,(IF("<0",0,(5-(L$3-$H11))*4))) Why is it returning an error? I know that the error is coming from somewhere in the second ...
0
votes
0answers
4 views

Incorporate Excel formula Names in Word Mail Merge document

I have an Excel document with numerous constants defined in Names. For example: ------------------------------------------- / Edit Name ? X \ ...
-2
votes
1answer
16 views

How can I embed file into an excel spreadsheet cell?

Does anyone know of a way to embed a PDF, JPG, Word file, or Outlook email into an Excel cell? I am entering data into cells and want to link them to specific documents and to save them getting lost. ...
-1
votes
1answer
21 views

Can't insert current date and time into Excel 2013

Ctrl ; is not working to insert the current date and time into Excel 2013. How can I fix that?
-1
votes
0answers
23 views

Setting up Monthly Payments in an Excel Spreadsheet

I made a basic checkbook-type spreadsheet, using three columns for +.-.= but couldn't figure out how to make it so something is added to the - column every month, preferably by itself. If it can't be ...
-1
votes
1answer
29 views

How to “draw” a square grid on excel?

How can I find the relation between width (of the columns) and height (of the lines) in the excel grid? I need to draw a simple diagram and I need to do it on excel
0
votes
1answer
15 views

Comparing data on Excel 2013 and removing excess

I am using Excel 2013. I have one worksheet (called A) with 2150 rows and 10 or so columns. I also have another worksheet (called B) with 1400 rows with 4 columns. In column A, the data is the same ...
0
votes
1answer
14 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
1answer
11 views

How to add up Column B based on whether Column A is a duplicate value?

I have two columns, one with names and the other filled with '1'. Column A has many duplicates in it - this is intended - what I need is a formula to add the 1s in Column B if the corresponding values ...
0
votes
1answer
10 views

How to make a Custom List with sheet cross reference?

At the end of the month i get a excel file with a variable number of sheets. Every sheet has a value in the same cell: A1 I want to create a new sheet and display all the values of A1 on every sheet ...
0
votes
1answer
21 views

Calculate the year-year Growth

Assuming i have a short income statement for the next 12 months. Now I want to create another table, for the first three years, something like this x Year 1 | Year 2 | Year 3 ...
-1
votes
0answers
12 views

Displaying data from another tab

I run a daily report where I need to display errors on a roster of our associates. I have one tab ('Roster') with the complete roster and a formula that checks to make sure that the shifts are correct ...
1
vote
1answer
25 views

COUNTIFS for multiple criteria across multiple sheets

Help guys! I'm trying to come up with a very short formula to compute for multiple data across multiple sheets. I have one workbook wherein I compile error reports I receive from several people. The ...
0
votes
1answer
18 views

Matching and returning values to populate column

I have a workbook (Excel 2007) with two sheets. Sheet1 has more than 8,000 employees and their associated unit numbers, which is a 6-digit ID. I am trying to populate Sheet1!C:C with a corresponding ...
-2
votes
0answers
19 views

Zero points of a chart in Excel [on hold]

I ploted a chart in a specified interval. After that I have to count zero points in this interval. Are there any general solutions, methods for this?
1
vote
1answer
15 views

Excel table not formatting new rows appropriately - where does formatting come from?

I have an excel table and all rows are formatted the same. When I add a new row, the formatting does not match the rows above - so every time I add a row I have to select the above row and copy/paste ...
29
votes
2answers
2k views

What does “A1:A4^{1,2,3}” mean in an Excel formula?

What does the caret operand in Excel do to a range when it is followed by some other numbers in brackets? For example lets say we have the following table: A B C 1 1.5 0 0 2 ...
0
votes
1answer
18 views

Excel Dates Transformation

How do I change the dates in Excel for the below scenario: Existing dates: 2/2/2014 3/12/2014 1/1/2015 2/1/2015 Target converted dates: 3/31/2016 3/31/2016 1/1/2016 2/1/2016 I want all the dates ...
0
votes
0answers
4 views

Excel chart doesn't show 'value' on hover

I have a combination chart on Excel 2013. It has both lines and stacked areas. When I hover over the lines, it shows all relevant information ('series', 'point' and 'value') of the data point. When ...
0
votes
2answers
32 views

How can I resolved Performance issues with Excel 2013?

I'm using a dell E6440 laptop with Core i5 CPU and 64-bit windows 7. I'm running Excel 2013. I do a lot of reporting through Excel and of recent I've noticed reduced performance - choppy mouse ...
0
votes
0answers
11 views

Undesired Locked cells on OSX Excel 2011 (but not in 2010 Win7)

I have an Excel-document where in most of the sheets are locked, and only few cells are available for editing. I don't have the password for the document as I am not supposed to edit anything in the ...
-1
votes
0answers
17 views

Allocating unique number to duplicate values

I have a list of codes in a column that have some repetition. I can remember using an IF statement a few years ago to identify the series of repetition. For example I need a formula that will return ...
0
votes
1answer
16 views

How do I copy a Function to select columns in an entire spreadsheet

I have an inventory report and the rows go by item and the columns go like this: Inventory - Stock Shipped Out - Inventory - Stock Shipped Out ect. I want each items Inventory figure to be the sum of ...
0
votes
1answer
21 views

Format row that is different than the preceding VISIBLE row

I have an Excel sheet as a database, where each row has a category, and are always sorted by category. Category Item 1 AAA jjj 2 AAA kkk 3 AAA lll 4 ...
0
votes
1answer
23 views

“Open as Read-Only” but workbook still opens as writeable

When I press Shift+Right-click when clicking on a workbook's filename, I get the "Open as Read-Only" option in the context menu, but when I click this option and the workbook opens, it's in read/write ...
0
votes
3answers
25 views

Excel function determine if a cell is visible

In conditional formatting I want to detect if the row above the current cell is hidden or visible. How can I detect if a cell is visible or not? The only hack I can think of is: Create a column ...
0
votes
2answers
14 views

Concatenating multiple URLs to create new page URLs in Excel

I pasted the following URLs into a spreadsheet: https://www.kickstarter.com/discover/advanced?google_chrome_workaround&page=1&category_id=9&sort=magic ...
-2
votes
3answers
64 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 ...
0
votes
0answers
10 views

Find a specific name in a column, bring in the value in the corresponding row, in the column I designate in another worksheet

So I have a worksheet that people will go into and put their name down to sign up for a meeting for a specific date. In a separate sheet, I have their names and I manually input the days they signed ...
0
votes
1answer
15 views

Automated Excel Sheet Import from Downloaded Spreadsheet

At work we have a data storage system where we keep information about equipment we've ordered. I want to take select columns from this data and put them in another sheet that is already formatted with ...
0
votes
1answer
21 views

How to have different numbers on separate cells and still have 100% in one cell on Excel? [on hold]

I have 38hrs in B4 and as soon as I put 38 hrs it automatically shows 100% in cell D10. Now I was either cell B12 or B18 to add to cell B4 so it will equals 100% in cell D10. Example: I have 33hrs in ...
2
votes
1answer
18 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. ...
-1
votes
0answers
20 views

Modify Excel data connection without disconnecting the connection file

When I link a data connection file to a workbook, and then edit the SQL query (to include dynamic parameters), Excel says: The connection in this workbook will no longer be identical to the ...
-3
votes
0answers
40 views

Insert data between commas in a cell in CSV [on hold]

Say I have 23 names in Column A, like this: jimmy.jpg,fred.jpg,pam.jpg.brian.jpg. They are in a single cell, with a comma after each name. I need to insert 3 names between fred.jpg and pam.jpg, with ...
1
vote
2answers
27 views

Why is Outlook 2010 Changing my Embedded Spreadsheet to a GIF? [on hold]

Years ago I figured out how to embed a spreadsheet in an Outlook email to automate a task I do regularly. Whenever I want to send a new quote request I open an old email, tell Outlook I want to ...
0
votes
0answers
19 views

How to insert a row into an Excel sheet1 and automatically insert the row into sheet2 [duplicate]

I have the following table in sheet-1 (master table) from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main ...
2
votes
1answer
22 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
0answers
17 views

Formula or function to change part of a text string color not using conditional formating

I have a shape I am using to highlight text. The text is using a formula to get a set of text from the spreadsheet . I need a single word to be a different color than the rest of the text string. ...
0
votes
0answers
8 views

How to combine two columns with associated data?

for my term paper i have to compare several algorithms to compute pi, i wrote scripts that use certain algorithms that i want to test, that give me an excel file as output. The excel file contains ...
0
votes
1answer
38 views

SUM IF FREQUENCY MATCH

I'm trying to add another criteria for the below formula. On the Payroll Data tab I have column H that has hours in it, some of those hours may be negative so I don't it to count those rows with ...
0
votes
1answer
16 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 ...
-1
votes
0answers
13 views

How to match donor data from year to year (ID Number and Associated Data)

I need to compare donor data from year to year and need to align them on a spreadsheet. For example, now I have the following: Column A- shows 2013 Donors ...
0
votes
0answers
12 views

Task Schedule excel file with ODBC/Oracle connection

I am having problem running an excel file with ODBC connection for Oracle to run via Windows-7 Task Scheduler. It will just say running. What the excle file does. After I open the file, it will ...
-2
votes
1answer
34 views

How to multiply rows in Excel based on a variable? [on hold]

last week I found a macro solving my problem, but I seem to have lost the code and cannot find it anywhere anymore. My problem is the following: I have table with names and their variables: Peter ...
1
vote
2answers
33 views

Excel Convert the correct Date type

I'm currently following the date type dd/mm/yyyy i need to have another row showing the month in mmm type. E.g. From 13/09/2014 to SEP My formula is =Text(A2, "mmm") which is the correct formula, ...
2
votes
1answer
140 views

Select all cells in a row

How can I select all cells in a row in Excel / Google Spreadsheet? I know I can select all cells in a column using A:A But how can I select all cells in a row? This doesn't work: 1:1 // select ...
0
votes
1answer
19 views

Plotting data in excel grouped by type

Take a look at: I made this manually. Basically, I plotted a normal bar graph, where all bars were blue color. I want to get all bars of same type to be represented with unique color (Type 1 - ...
0
votes
3answers
26 views

How to lookup a value within a range

I need a formula to calculate values from slab Ranges. for example columnA columnB 1-10 A 11-20 B 21-30 C 31-40 D 41-50 E 51-60 F 61-70 G 71-80 H 81-90 ...
0
votes
1answer
29 views

Macro to copy distinct values from one Excel sheet to another

I have an Excel workbook that has the following sheets, "Main" and "Count": Now the "Main" sheet has the column B with list of IDs. Is it possible to have a macro on "Count" page to copy all ...
0
votes
0answers
10 views

Word mail merge and page breaks

Looking for a way to put a page break after a number of rows in an Excel data source for mail merge in Word - the number of rows before the page break can vary, depending on he number of records that ...