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)

-2
votes
1answer
21 views

How can I remove the #n/a from a complex formula?

=IFERROR(VLOOKUP(AI57,SALESCODES!$B:$G,3,FALSE),(VLOOKUP(AI57,SALESCODES!$C:$G,2,FALSE))) How do I remove the #N/A on this formula?
0
votes
2answers
20 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) ...
1
vote
1answer
33 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
32 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 ...
0
votes
1answer
31 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, ...
-1
votes
1answer
26 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
4answers
7 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.
-2
votes
2answers
36 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
votes
1answer
25 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? ...
1
vote
1answer
23 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
vote
1answer
43 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
26 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
1answer
20 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 ...
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
0answers
4 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 ...
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 ...
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 ...
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. ...
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
0answers
17 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
0
votes
1answer
22 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 ...
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 ...
0
votes
1answer
17 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
32 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 ...
-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 ...
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
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: ...
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 ...
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. ...
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
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
2answers
45 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
0answers
21 views

Excel Weird with Filter & Match to get 1st result from filter

as view in this Forum from the Excel sheet Get first data after Filter Data 2 3 4 5 6 7 8 9 10 11 12 13 ...
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 ?
0
votes
2answers
39 views

Superscripts in Excel chart labels

I have data like this: 2 | 5 4 | 6 8 | 7 I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol but as powers/ ...
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
30 views

CSV File Import Error - Question Marks / Brackets Everywhere

I have a few .csv files that were sent to me, but when I try to import them either as .txt files or as .xml files I only get blocks of question marks (?) and brackets (CONTENTS) of the type that would ...
1
vote
1answer
20 views

Unable to format datetime in Excel Table

I have an Excel document with a table linked to a table in sql server containing a datetime field. The datetimes display as yyyy-mm-dd hh:mm:ss.sss and I'm unable to format the cells directly to a ...
1
vote
2answers
30 views

Vlookup across multiple columns

Within one workbook, I have two spreadsheets. Sheet A ("Master") looks like the following - it shows a main branch with it sub branches. Sheet B ("Query") looks like the following: The ...
-2
votes
1answer
24 views

How can I remove the duplicate values from this excel spreadsheet

I have a spreadsheet with around 15K rows of data. I have duplicate values in this spreadsheet that consist of a combination of columns A & B. How can I remove the duplicates from this spreadsheet ...
-1
votes
1answer
23 views

With VLOOKUP, if N/A, keep original value

I'm using Vlookup to find a value, but when it doesn't work, it returns N/A. How do I keep the previous value instead of having NA. I have found the answer HERE How do I implement this? Do I just ...
-2
votes
1answer
20 views

attendance software in excel [duplicate]

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.I have to add ‘l’ (which indicate late comer) also with attendance.So 'P' ...
2
votes
3answers
17 views

How to Find Specific Sheet Name in Excel

I have a excel file with 55 sheets in it It is very tedious to find a specific sheet name in the excel file since it has 55 sheets in it I have used the search function to find specific sheet name ...
0
votes
1answer
28 views

EXCEL: VLookupwith dummy variables

I have data that has dates, returns, and two columns of dummy variables. I would like to know how to use a formula to only show data when the dummy variable indicates a hit. My data looks like this: ...
0
votes
1answer
37 views

Complex drop-down lists

I want to make a spreadsheet to calculate energy consumed by a system. To automate I want to select some equipment and with this selection, the consumed energy appear at side. I try using INDIRECT ...
0
votes
2answers
21 views

Removing Specific Duplicates from an Excel Array

I have a workbook that has a list of account numbers and their attributes. Assume these are the only two columns on the sheet: 12345 Equity 12345 Cash 12345 Cash 55555 Fixed Income 55555 ...
0
votes
2answers
31 views

Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...
0
votes
2answers
25 views

Excel: deleting duplicate records based on an int value

In a sheet that has two columns, the first represents a string and the second represents some field value associated to that string as shown below. I roughly have 30,000 rows like that. My Question ...