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

Add rows to insert dates from a “from” and “to” column

I want to breakdown an Excel sheet by having it in a specific format. Right now, the sheet is like this FROM TO TOTAL 01/27/12 01/27/12 1 03/09/12 03/09/12 1 04/11/12 ...
0
votes
1answer
5k views

How to customize Paste Value Excel Short Cut

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code. I would like to set the keyboard shortcut to Ctrl d but Excel pops up an ...
0
votes
1answer
468 views

Prevent Excel from converting text to columns

When I'm using Excel to parse multiple documents, and I need to control the import (Text, not General, on column import settings being the most notable example), how can I prevent Excel from ...
0
votes
1answer
825 views

Create a pivot table by joining two tables

I have two tables, each on its own worksheet, that are linked to Sharepoint lists, where one table has a foreign key that maps to the other's primary key. E.g.: sheet: flavors ...
0
votes
1answer
909 views

Data Source not found in Excel (Data/From other sources/From MS Query) connecting to PostgreSQL

I set up an ODBC connection to a datamart with c:\windows\SysWOW64\odbcad32.exe. I set up my Data Sources in the System DSN tab using the PostgreSQL ANSI driver. When I go into Excel bring in the ...
0
votes
1answer
145 views

Populate a table based on various inputs

I have three simple inputs for a quotation we're preparing, and I would like to automatically calculate all the possible combinations. For example: We need to produce Small, Medium, Large and XL ...
0
votes
1answer
2k views

Combine duplicates in Excel, sum some columns and weighted average the others

This question refers to an existing subjexct on our site. I need a variation on this solution. I have a spreadsheet with 8 data columns. The number of records can vary from a few hundred to about ...
0
votes
1answer
68 views

Keep data in first downloaded XLS from second sheet

I download data from a source with my software and store it in an .xls sheet. Such downloads are performed on regular bases and always stored in a new .xls sheet. The data looks like this: Shri Ram ...
0
votes
1answer
59 views

Formating my Excel Cell Formulas

What formula can I format my cells to so that when I input a number it will have a u after it (I have it set to ###,###u now) and if it is blank it will have "N/A" in the cell? Thank you in advance.
0
votes
1answer
1k views

How to group count by week date in PowerPivot

I have a table of data in PowerPivot connected to a sharepoint list. Each row has a date that I need to group by week and count the rows in that week. Is there a DAX formula or other approach to ...
0
votes
1answer
258 views

At exporting table to excel, double numbers are changed as date type

I have in table column, his type is decimal and in him is stored numbers like this 2.3 2.0 3.3 4.2 I want export this table in excel, I export table as csv file. But when open csv file in excel, ...
0
votes
1answer
144 views

How do I find data and replace it with data from another column?

Listed below is just one of many stores that are listed in my spreadsheet. Column A1 | Column B1 ---------- | --------- Mays Dept Store 551 | Mays Dept Store How do I have ...
0
votes
1answer
506 views

Merge rows and join matching values

I have two sets of data on the first set there is one column that has a list of IDs like below. I have another set which could have several rows matching that same ID like below I am trying to ...
0
votes
1answer
267 views

Excel cell formatting to fill color

I'm doing some excel formatting, with below formula being used: =IF(OR(ISBLANK(E23),ISBLANK(E24),ISBLANK(E25)),"Section Incomplete","Section Complete") Basically, When the cells E23, E24 and E25 ...
0
votes
1answer
250 views

Split a file with macro in excel

I know there are 2 similar questions. I have a very large Excel file separated in sections by 3 blanks lines. I was wondering if there was a way to split the spreadsheet into other every time there is ...
0
votes
1answer
24 views

Excel 2007 removing entries which have data in two columns which may not match exactly

I have an Excel spreadsheet with over 10,000 entries. This spreadsheet contains two columns of dates, and I need to select only those entries where the dates do NOT match in the two columns. The ...
0
votes
1answer
2k views

Sharepoint Document's macros

I'm trying to upload an excel document with a few macros to a 2013 SharePoint, I don't know if I can use the macros via "View in Web Browser" option. I cant get them working, although if I download ...
0
votes
1answer
202 views

visio excel link

I was wondering if is there any chance that I could connect visio with excel in dual link? ill try to be more specific. I already linked visio with excel, I mean, I edit properties in excel and when I ...
0
votes
1answer
296 views

Getting more than 100 data points to only represent part of 100%

I am trying to graph stance phase of gait, which in only about 60% of the entire gait cycle (heel strike of one foot to heel strike of the same foot) But in the data out put there are 140 cells or ...
0
votes
1answer
77 views

Excel table / chart issue when updating the select data to a smaller amount

I believe I have a simple fix but cannot find the answer anywhere online. I have a table that looks something like: date / total1 / total2 / total3 mon / xxx / xxxx / xxxxx tue / xxx / ...
0
votes
1answer
1k views

Compare two excel sheets with almost identical data and come out with matched and mismatched data

There are two excel sheets with almost similar data. One sheet is huge with around 1800 rows. and the second one is a small with around 100 rows. And these 100 rows may be present or not , if present ...
0
votes
1answer
52 views

Search for words against Excel and PDF file

I am looking for an application or service which will allow me to check a list of words (client names) against an Excel or PDF file. Is there a way to do this? My preferred OS is Mac, but have access ...
0
votes
1answer
1k views

Excel/OOCalc: finding rows that have matching values in one field but different values in another

I have a large table (20-30 cols, 10-15K rows). What I need to do is to find the number of rows that match identically in one (or two) particular field(s), but not in another specific field (rest of ...
0
votes
1answer
908 views

Single source worksheet, and multiple pivot tables using filtered data

How does one create a workbook, where one worksheet is the master source data, but multiple pivot tables need to be created with the same set of "row labels" and "summed values", but different filters ...
0
votes
1answer
85 views

if a condition is met start a multiple condition formula otherwise return (blank “”)

I would like to create a formula on excel 2007 as follows: if (A1)="Overnight tour" I want the following calculation to take place (B1>15,1),(B1>31,2),(B1>47,3),(B1>63,4) and so on .. or maybe the ...
0
votes
1answer
602 views

IE8: Pressing 'Open' in Download Dialog saves file to a temporary, non-writable location

I have a specific problem with IE8. Our users download excel files via IE8. Those excel files contain macros which create pivot tables. In order to do that, excel 2007, needs the file to be writable ...
0
votes
1answer
233 views

How to change cell colour in Excel 2010 based on certain criteria?

I would like a cell's colour to change when its value is less than that of another cell. How can I accomplish this?
0
votes
1answer
311 views

MS Works Spreadsheet formula required

I am creating an MS Works - Version 8.5 - Spreadsheet into which is entered the Date of the month, the Month and the Year. The year is calculated to be either a Non-Leap Year or a Leap Year according ...
0
votes
1answer
3k views

How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...
0
votes
1answer
226 views

monthly totals comparing two date columns, Excel 2010

How can I calculate a monthly total of the courses completed for the month ONLY when they were due for that same month (sometimes students are late and sometimes early)? The spreadsheet has a column ...
0
votes
1answer
2k views

Excel scatter graph fill inside shape

I would like to fill the area between two graphs. My data is in the following format: x y 0 0 1 1 2 4 .... 0 0 As you can see they start and end at the same point. For my data it draws a chart ...
0
votes
1answer
84 views

Excel Changing Cell Value

I'm struggling to solve a problem with my Excel document so I'm hoping that someone more experienced can help? I have a cell that updates my account balance after each trade is recorded. I then have ...
0
votes
1answer
716 views

Adding Subsequent Cell Values For Each Row in Excel

I'm new to excel so this might be a simple question. I have around 100 rows with 7 columns. Out of those, 4 column needs to have the value computed by 3rd and 2nd columns' value of the same row. I ...
0
votes
1answer
907 views

Pivot table column grand total as percent of all grand totals

I have a pivot table that shows A/R by the week it was calculated and the age of the claim. The column labels are the Week label (Current, Week 2, Week 3) and then the age of the claim 0-30 Days, ...
0
votes
1answer
356 views

IF formula with multiple variations

I've built a system for managing our hotel's reservations. I'm a self-taught excel user and know only what I've figured out over the past months digging through the internet. I've hit a problem. Each ...
0
votes
1answer
167 views

Publish XLS document that has visual basic code to a web site

I have a requirement that was asked of me. We have an Excel document that has visual basic code attached to it and it does some computing. The user wants to publish this document onto an intranet ...
0
votes
1answer
217 views

Missing shortcut options in Excel 2007

I've noticed that I'm no longer able to use shortcuts like Alt-IR and Alt-IC to insert rows and columns. I'm sure I used to be able to on this machine but recently it doesn't work any more. How do I ...
0
votes
1answer
1k views

How to search a string in many workbooks and copy row if true

I need to run a report for a customer. I have approximately 50 files (Excel 2007 workbooks) in a folder. Each workbook has about a hundred rows and ten colums. I need to search a string (in a known ...
0
votes
1answer
617 views

Google spreadsheets drop down not compatible with MS Excel

I've created a drop down list on a google docs spreadsheet but when I download the spreadsheet and open it up under excel, the drop down functionality is lost and only the first item is shown. I have ...
0
votes
1answer
929 views

Calculating a CAGR in Excel 2007 Pivot Table

I'm trying to calculate a compound average growth rate or CAGR in an Excel 2007 pivot table. I am familiar with the CAGR formula: ((End Value / Start Value)^(1/N)) -1, where N is the number of ...
0
votes
1answer
350 views

How to create a macro to transfer data from another spreadsheet?

I need a macro that would copy all columns and rows from one workbook to another. I would like that macro to be triggered from a push of a button. When pressed, it would automatically transfer all the ...
0
votes
1answer
753 views

How to convert currencies in Excel based on historical conversion rates?

I want to make a small program in Excel that allows the user to convert certain currencies (USD, Euro, AED, CHF and GBP) to Kuwaiti dinar. The user can set the amount, the currency and the month, and ...
0
votes
1answer
272 views

Mapping of child elements

I can't find one good way to solve this problem. I will try to sum the issue as best as I can: I use Hyperion Essbase Excel ad-in to navigate inside OLAP cubes. What I am trying to accomplish here is ...
0
votes
1answer
2k views

Changing cell values based on another cell

Lets say that I have 3 parameters/cells: High (Cell A1) Medium (Cell A2) Low (Cell A3) the fixed values for these cells are 2, 2 ,2 how can I change the value of cellA1 based on the changes of ...
0
votes
1answer
163 views

Creating a Macro or Formula to copy data through a query

Here is my formula that I'm looking to build off of: =IFERROR(VLOOKUP($A1,Table2,10,FALSE),"") I don't know if I can use just a formula or if it has to be a macro. I am trying to create a query ...
0
votes
1answer
269 views

how to set focus on sheet tab in excel?

How do you set focus on sheet tab in excel working book?I need to do a number of functions such as select all sheets, switch back and forth the sheet, delete, group,ungroup, is very inconvenient to ...
0
votes
1answer
37 views

Excel Statistical Table

I am trying to create a statistical table based on columns of information. The row/column identifiers of the table are also incorporated in part of the statistics of the table. I have three columns of ...
0
votes
1answer
237 views

“IF” condition to compare two sheets

I want to compare two sheets and write results to a third sheet. The first sheet has two columns: title_add | add something title_del | del something title_lst | list something The second sheet: ...
0
votes
1answer
76 views

Excel Formula For Re-arranging Numbers

I have got a bit stuck with trying to make a formula in Excel, and last time I asked a question here I got great help, I have come back again. At the moment I have column A with sets of product id's. ...
0
votes
1answer
94 views

How to count the most recent value based on multiple criteria?

I keep a log of phone calls like the following where the F column is LVM = Left Voice Mail, U = Unsuccessful, S = Successful. A1 1 B1 Smith C1 John D1 11/21/2012 E1 8:00 AM F1 LVM A2 2 B2 ...