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)

6
votes
4answers
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
2answers
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
4answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
0answers
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
0answers
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
2answers
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
0answers
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
3answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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 ?