**-2**

votes

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**4**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

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

**0**answers

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

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

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

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

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

**0**answers

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

**1**answer

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

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

**0**

votes

**1**answer

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

**1**answer

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

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

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

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

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

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

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

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

**2**answers

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

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

**0**answers

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

**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 ?

**0**

votes

**2**answers

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

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

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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