**0**

votes

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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 ...