**6**

votes

**4**answers

24k views

### Select an entire column minus header row in an Excel macro

How would I access a range that corresponds to an entire column starting at row 2 (there is a header row)?
The end of the selection should be the last non-empty cell in the column.

**0**

votes

**2**answers

8 views

### Excel Count number of cells based on three dependent selects

I am looking to count the number of cells based on three dependent select statements. each select corresponds to a column.
For example,
Select nth-Day (Column A)
Select Issue Type (Column B)
...

**0**

votes

**4**answers

4 views

### How to refer to cells in other sheets

I have a workbook contains several sheets. And i'm trying to use cell value that present in other sheet . How do i refer or use cell value in other sheet.

**0**

votes

**1**answer

24 views

### Excel Convert XML cell to columns

I have an excel spreadsheet with XML in a single column. I know that you can import XML data into Excel; but only imports the entire file. However, I need to do this on a cell by cell basis.
With ...

**0**

votes

**1**answer

26 views

### Excel SUM function for whole column?

How can I sum the whole column without freeze head?
I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...

**0**

votes

**1**answer

22 views

### Why do I get HEX2BIN() error for long (but valid) strings?

In Excel 2010, the formula =hex2bin("111",10) gives the right answer of 0100010001. According to the function help, the arguments should be at most 40 bits (10 hex digits). However, the following ...

**0**

votes

**1**answer

28 views

### Excel - displaying numbers and text on cell

Hi I am struggling with a formula but not sure it can be done
In column F - I have number or text in each cell and I want to show in column G if its text to show blank and if a number show the actual ...

**1**

vote

**0**answers

13 views

### Coloring separate rows based on matching of data in key cell

i have a excel file as
i want change the sheet that after sort on key column(MasterID), any rows same as key column change color to similar.
for example

**-2**

votes

**2**answers

32 views

### identify the rows with the lowest values in an array based on identical values in a column of that array

I have an array of product data which includes code, description and cost. code is unique, cost is numeric and description is non-unique. Please see example. How can I select the cheapest of each ...

**1**

vote

**1**answer

22 views

### How to sum amounts in column given specific criteria in excel

I have a spreadsheet with two columns. A (for example) has the values 1 2 2 3 4 4 5 and B has 1.2 4.3 3 2 5 4.5 7.
How do I total the amounts in column B given that the cell to its left equals 2? In ...

**-1**

votes

**2**answers

38 views

### Search price Grid

I am looking for a way to find values within a table: Lets say I have width of 575 and a drop of 575 then the search values should round upward to 600 width x 600 drop and the answer should be 66.6.
...

**1**

vote

**0**answers

3 views

### Excel VBA not working when “enable editing”

I'm not sure if this is the right place to post this but I'm having issues with excel VBA. I sent a worksheet with custom VBA attached to an email. Once the user downloads the file, it open in excel ...

**-1**

votes

**1**answer

24 views

### Custom Data Validation in Excel 2010

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use?
...

**0**

votes

**1**answer

16 views

### I want to map rows from Sheet one on and excel file to other sheets if they meet certain criteria

I work in sales and cover a large territory. To manage the territory, I break it up into "Zones" (i.e. Philly / Pittsburgh / etc). My organization provides an excel file with every company I call on ...

**0**

votes

**1**answer

19 views

### How can I use indirect references for a pivot table's data source?

(This question is mostly about Excel, but it's also relevant for LibreOffice Calc, so I welcome answers about either.)
I have this sheet with many rows, some of which only become relevant at certain ...

**2**

votes

**2**answers

853 views

### How to disable keyboard shortcut animation in Office 2013?

I am looking for a way to disable the animations for keyboard shortcut selection in Office 2013, especially Excel 2013. When you select a keyboard shortcut using Alt and a key sequence (e.g. ...

**8**

votes

**2**answers

2k views

### How can I dismiss the floating “Auto Fill options” button in Excel 2010?

Reproduce the issue
Go to Excel and type fill in the first 2 rows of a column
Select both rows of the column
Drag down the anchor of the selection (bottom right) 1 row down
Now you will see this:
...

**1**

vote

**1**answer

42 views

### Excel: Calculate pilot currencies

I recently got my pilots license and started using Microsoft Excel as my backup logbook. Now I'd like to add a "currency-calculator", which should show me until when I am type and day/night current ...

**1**

vote

**1**answer

998 views

### How to make a Pie radar chart

I want to create a circular chart in Excel with 8 sectors like in this example:
Instead of representing the percentage like in a pie chart, I want the actual value like in a radar chart.
Is it ...

**1**

vote

**0**answers

27 views

### How do I create a master workbook in excel?

In powerpoint we have something called a master slide. I want the same idea for excel. I want to create a template that I can work on with formulas and I want it to update all children files.
...

**1**

vote

**0**answers

22 views

### Excel Visual Basic Issue

I've been using VBA quite a bit recently, and, so far, I haven't run into any issues. For some reason, and, I cannot for the life of me figure it out, visual basic wont include "+" or "-" signs in ...

**0**

votes

**2**answers

2k views

### Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...

**0**

votes

**0**answers

9 views

### Editing registry for the error - One of your object libraries (I) is missing or damaged. Please run setup to install it

When I opened an excel (.XLS) file today, I got an error - One of your object libraries (I) is missing or damaged. Please run setup to install it. I don't know why that happened, but it could be ...

**2**

votes

**3**answers

9k views

### Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...

**0**

votes

**1**answer

14 views

### Adding a time period in Excel 2010

A simple question, but some quick Googling did not prove fruitful.
Basically, I have a column called "uniqueID", which is a unique identifier for all the people in my dataset. Most uniqueIDs have ...

**0**

votes

**2**answers

3 views

### Total number of instances of single-digit numbers w/in two-digit numbers w/in same cell.

Our legacy payroll system reports each day of the month, i.e., 1 through 31, across a single row of cells, e.g., A1:AE1. Below each day, an empty cell or a two-digit number is reported. An empty cell ...

**0**

votes

**1**answer

17 views

### display cells as improper fractions in excel?

In Excel one can format cells so that they display their numeric contents as fractions:
But the fractions are reduced, i.e. 3/2 is written 1 1/2. Is there a way to display improper fractions in ...

**-1**

votes

**1**answer

27 views

### how to copy data from on cell to diferrent cell using command button

for example the first thing i put in cell b1 has "='Ex-post'!C172"which has value "1" and c1 has "=OFFSET('Ex-post'!$B$4,MATCH($H$1,'Ex-post'!$B$5:$B$542, 0),4)" in which the value is 2300 and i want ...

**0**

votes

**1**answer

21 views

### Excel date time find max / min and max min timespan

I have data time data in excel in the format "04/18/2014 17:09:09". I would like to use MAX and MIN on a range of such dates to get max, min and time span between min-max.
I tried using custom format ...

**2**

votes

**3**answers

34 views

### Custom user function without using VBA

Is it possible to create a custom user function in Excel without using VBA?
My problem is I have a long string of standard excel functions strung together to make one very long function.
This function ...

**0**

votes

**1**answer

5 views

### Load a picture from one inserted ActiveX Image to another - VBA Excel

I got a set of named pictures on an Excel sheet, created by the "Insert" button in development tag, and from the section "ActiveX controls" from the "Insert" button. What I want is, when I click on ...

**0**

votes

**1**answer

40 views

### How can I embed a tracking GIF in an Excel document?

I want to add www.sometrack.com/blah.gif to an Excel document. My goal is to embed a trackable element (e.g. a GIF). I want to send a person this document, and if they open it, the pixel opens ...

**0**

votes

**1**answer

2k views

### How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...

**1**

vote

**2**answers

1k views

### Format Change Event for Excel VBA

I'm trying to prevent people from modifying (most) of my spreadsheet while still alowing them to use the sort function of the AutoFilter. What I've done so far is used the Worksheet_Change event and ...

**0**

votes

**1**answer

9 views

### Excel formatting not working for some cells when trying to do center alignment

I have an excel file that has been exported from a SQL Server Reporting Services report. The cells in the first column are a list of store numbers and should all be center aligned but for some reason ...

**-1**

votes

**1**answer

33 views

### Excel - Concatenate words separated by “_”

I need help with the following problem:
My column in A2 in Excel has the value: TB_PLACES_NAMES
But I need to separate the "_" from the others words in the same column.
I've tried this function:
...

**0**

votes

**1**answer

31 views

### How can I avoid an error from a blank cell in VLookup formula?

So this is my formula in one of my cells. The problem is that when I don't have anything in B15, I get the error message. Sometimes I want it empty, and sometimes I want it to have text in it for ...

**0**

votes

**1**answer

2k views

### Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns.
For example, we have a B column with values that are one or more letters followed by one or more ...

**3**

votes

**1**answer

2k views

### Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...

**1**

vote

**0**answers

21 views

### Excel Need to Check one Sheet for Data if True take data and paste in field

I am doing inventory for my company but need to use last years inventory prices in this years quarterly spreadsheet. There are only 3 Information fields. SKU, Qty, and Cost. In the master it has SKUS ...

**1**

vote

**0**answers

15 views

### Change Excel Zip Compression Level in Windows

Excel compresses its files using Zip-Deflate and stores it. However, the compression level is far from the best. To reduce the size and send it across I have to unzip and re-zip it manually everytime. ...

**1**

vote

**3**answers

11k views

### How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...

**0**

votes

**1**answer

16 views

### Can Excel copy and paste formulas and automatically adjust by more than one cell?

I have one column with values in every nth cell that I also want to have one after another in another column. Individually referencing every nth cell is impractical, so I'd like to copy and paste one ...

**0**

votes

**1**answer

2k views

### Remove Excel data link in Visio Drawing

I am creating a server topology for one of our SharePoint farms and thought it would be easy to just link the Excel spreadsheet with our server information to the Visio drawing to auto-populate some ...

**0**

votes

**1**answer

28 views

### String compatible equivalent of Excel Small()/ Large()/ Rank()

I'm wondering if there is a string version of the Excel Small()/ Large()/ Rank() functions, i.e. a function that could look at a list of strings and tell you how they rank.
E.g. in the following ...

**0**

votes

**2**answers

44 views

### From column to matrix

I have few addresses in a single column. Need to move it to rows as below:
name1
street1
city1
state1
phone1
email1
name2
street2
city2
state2
phone2
email2
NAME ADDRESS PHONE EMAIL
name1 ...

**1**

vote

**2**answers

34 views

### How to i convert a date entered as dd-mm-yy or dd-mm-yyyy to excel date

I have a sheet with date column entered as dd/mm/yyyy eg 15/12/2014
However excel does not treat this as a date ,hence I cannot apply any date functions to this column .
Is there a way to convert ...

**0**

votes

**1**answer

22 views

### How to replace characters?

I have numeric data such as 8,1, 9,2 etc. and I need to use this data on Weka Data Mining program. So I need to replace commas with dots (8,1 --> 8.1). I have selected data and replaced with dots(Ctrl ...

**-1**

votes

**1**answer

49 views

### How do I count attendance in Excel?

I want to make an attendance sheet in excel. If a child is present, the teacher will write P in a cell, or A for absent, or L for latecomer. I want to get the number of P or L in a range to calculate ...

**0**

votes

**1**answer

34 views

### How to implement conditional border formatting in Excel?

I need to force cells B, C, D, E to have an upper border IFF cell A is not empty.
How can I do this ?