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
0answers
2 views

Using arrayformula in google sheets to copy down

I have read all the other questions that show this being used and I ether get errors when I plug this in, or it copies everything from the first row all the way down. =(split(split(D1,"SMS from ...
0
votes
0answers
15 views

How to count number of distinct values containing specific text

I'm not sure if I've phrased that question well so I'll elaborate. I have 160 lines of file numbers, many of which are duplicates. In each file number there is a value that determines the year the ...
0
votes
1answer
9 views

how do I create a formula to find percentile of data in different ranges and worksheets

I have 3 worksheets with data in column Q and I want to calculate the 90th percentile of all the data. The number of rows of data in each worksheet is different. It's probably easier to create a ...
0
votes
1answer
7 views

Microsoft Excel, copying Format of a cell

Like copy and pasting cell content with format to another cell or multiple cells, is there a way to copy a particular cell's FORMAT alone and paste using Ctrl+V to another/multiple cells? Thanks in ...
0
votes
1answer
15 views

IF function that will calculate the annual total

I can not figure this out and would greatly appreciate if someone could help me! In cell 5, enter an IF function that will calculate the annual total. If the client has a locker (D5) is "YES" then ...
0
votes
1answer
14 views

I need a formula to find the last xday of the month

I am trying to write a formula to find the last Wednesday of each month of the year. I also need the last Friday as well. I am finding ways to get the first Wednesday of a month and tried to modify ...
-1
votes
0answers
5 views

linking validation to pivot tables to create dashboard

Please can you advise why this scribt is not working on my excel 2007 but is working on another excel 2007 computer Private Sub Worksheet_Change(ByVal Target As Range) 'disable events and screen ...
0
votes
1answer
25 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
10 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
18 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
23 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
25 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
33 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
16 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
12 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
11 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
15 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
36 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
20 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 ...
32
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
24 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
26 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
16 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
19 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
21 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
41 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
28 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
23 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
18 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
9 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
39 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
18 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
14 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
13 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 ...