**0**

votes

**2**answers

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

**0**

votes

**1**answer

19 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

**0**answers

6 views

### Excel superscripts as data in chaer

I have data like this:
1 | 5
2 | 6
3 | 7
I want to plot them (scatter plot) with x={1,2,3}, y={5,6,7} but show in the chart as 2^1, 2^2, 2^3, but not with the ^ but as superscripts. Is this ...

**0**

votes

**1**answer

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

**1**

vote

**2**answers

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

**0**

votes

**0**answers

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

**2**

votes

**3**answers

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

**-2**

votes

**1**answer

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

**3**

votes

**2**answers

5k views

### Printers not visible in Microsoft Excel

When in MS Word or PowerPoint, when I go to File → Print, I can see all the printers. But when I do the same thing in Excel, no printers are installed. Yet I can use the Ctrl-P shortcut keys and ...

**-1**

votes

**1**answer

18 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

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

**0**

votes

**2**answers

19 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

12 views

### Link to a formula in a different cell

I would like to be able to pull a formula through onto a second tab (not copy a formula). For example on sheet 1 I have a range of cells that calculate amounts (cell A) divided by a number of months ...

**0**

votes

**0**answers

32 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

**1**answer

1k views

### Change numbering language of the Excel context by changing the Windows language

How could we change the numbering language of MS Excel 2010 by changing Windows language
In version 2007 as I can remember we had an option in the advanced options tab that allowed us
to do that with ...

**2**

votes

**1**answer

32 views

### Excel 2010 Pivot Formatting - Can't indent and wrap fields?

When working with pivot tables in Excel 2010, I want to show my pivot in compact form, with each field being indented as you move through the data, like so:
However, some of my data strings are ...

**0**

votes

**2**answers

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

**0**

votes

**2**answers

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

**1**

vote

**2**answers

35 views

### How can I use the row number in an Excel chart?

I have an Excel table which is simply one column of dates. Each date has a distinct value, and they are already sorted. Something like:
5/29/2011
6/21/2011
6/26/2011
7/1/2011
7/3/2011
...

**5**

votes

**1**answer

2k views

### How to combine data from two rows, when certain criteria is met

click to enlarge
I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column ...

**-2**

votes

**1**answer

21 views

### Macros to parse excel data [on hold]

When I am copying the data from putty after queries like ( Select * from tis_zfb where rownum<2; ) the data is getting shrinked, the null values are getting replaced by the values from there right. ...

**0**

votes

**1**answer

26 views

### I don't want Ms excel to scroll down by cell units

When I scroll down (or up) in Ms Excel 2007, it scrolls down so that only whole cells (or at least it tries to do so) could be displayed next in that page. And it keeps jumping down one complete row ...

**2**

votes

**1**answer

246 views

### read excel sheet into jagged array

I am a programmer but recently new to both powershell and vba. I found this simple but effective command in powershell to read in a csv file and you can then immediately access "columns" by their ...

**0**

votes

**1**answer

11 views

### Count the number of times a value/string is in a column when other columns are filtered

I am trying to count the number of times a value/string is in a column when other columns are filtered.
Example: I want to be able to filter any column, A through V, and then count how many times a ...

**-2**

votes

**0**answers

24 views

### Win 7. Use the contents of manually updated .xls to create a batch file that deletes files in folder to match spreadsheet?

Win 7.Use the contents of manually updated .xls to create a batch file that deletes files in folder to match spreadsheet?
Hi.
I have a folder that has a number of subfolders. Each sub contains lots ...

**29**

votes

**9**answers

110k views

### Convert a column into a comma separated list

I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this:
1234
123461
123151
11321
And make them into a comma-separated list in another cell ...

**0**

votes

**0**answers

20 views

### Powerpoint 2013 - CPU spike

for some reason when i run PPT and/or Excel 2013, and even despite pretty robust and new system (see below, please correct me if i am wrong), my computer commands of large amounts of memory and CPU, ...

**3**

votes

**2**answers

1k views

### Setting the content language of cells in Excel

In MS Excel, is it possible to set the content language of cells e.g. per column? The purpose would be, among other things, to make proper spelling checks when the content is multilingual (e.g., a ...

**0**

votes

**1**answer

29 views

### How do I group and chart date ranges in Excel?

I want to visualize the use of vehicles in a family through time. I have collected the dates each vehicle was being used as follows (example data) :
And want to somehow chart the data to visualize ...

**0**

votes

**1**answer

23 views

### How to control individual functions in excel chart?

I'm not sure this is the right place, but I'll give it a try.
I have this graph:
All of the functions' X Axis were given the same data (12,24,36,48), except ROULETTE and TOURNAMENT which were also ...

**1**

vote

**1**answer

7k views

### Unable to change Excel cell font or shading colors.

6/15/2012
I'm having the same problem as a previous user's query (linked below) wherein I can't change the font or cell shading color on an Excel spreadsheet. I've confirmed that the cell/spreadsheet ...

**0**

votes

**1**answer

15 views

### One Cell OR Another

I am working on a formula- If A3 returns an error #NUM! then use A1 or A2 (whichever one does not have an error message). I am going to use ISERROR but can not figure out how to tell it to use A1 or ...

**1**

vote

**1**answer

24 views

### Excel 2013: Change text in cell based on date in another cell

I have the the following spreadsheet: http://postimg.org/image/nti4akie5/
My formula in Columns A to E is the following:
=IF(ISNA(VLOOKUP(Query1_2[@Branch],Master!A:J,10,FALSE)),"Branch Not ...

**1**

vote

**1**answer

3k views

### Create a dependent drop down list in a single cell in Excel

I am trying to create a dependent drop down list for a High School. The User will select cell A1, Click on Hallway 3(for example), then the user will click on cell A1 again and then select the Room #, ...

**-4**

votes

**0**answers

20 views

### EXCEL HELP.Comparing 2 columns [duplicate]

Please Help me regarding this issue.
I have 2 columns
1st column-676 rows
2nd column-1006 rows
All the data in 1st column are there in column 2
I want the ones which are not there in column 1 and ...

**-1**

votes

**1**answer

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

**0**

votes

**2**answers

7k views

### How can I create matrices of data in Excel?

I want to create a 4x4 matrix in Excel 2007 by taking three or more columns or conditions, for example:
Column index Row index Name
1 2 x
2 3 y
...

**1**

vote

**2**answers

255 views

### Excel File Names not Displayed

Problem: When excel windows are minimised, I can't see the file name, all I get is a rather unhelpful 'Microsoft Excel' proceeded by the file name.
I have the taskbar docked on the left, and have ...

**1**

vote

**1**answer

12 views

### Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...

**2**

votes

**9**answers

27k views

### Excel isn't calculating the SUM of cells

I am trying to use a very simple formula which is =SUM(B9:B11). However the cell doesn't compute for some reason.
I've used Excel for years and have never had this problem. Any idea why it may be ...

**4**

votes

**3**answers

18k views

### Excel: making line charts so the line goes through all data points

I've got data based on over 50+ years for various products. Not all products have data for each year, so the line is not always shown from point to point - Excel bug or is there a work around?
I've ...

**0**

votes

**2**answers

25 views

### How can I summarize age ranges and counts in Excel?

I have a table with a long list of individuals, and their age. From this data, I was able to derive a list of all ages, and then count how many people were of each age. Here is some simple, sample ...

**0**

votes

**1**answer

3k views

### Excel scatter chart, with grouped text values on the X axis

Apples 1
Apples 5
Apples 2
Bananas 1
Bananas 4
Bananas 6
I want two bars on the X axis (Apples, Bananas), but with crosses marking the points on the Y axis.
Here's a mockup:
I'd want 1 ...

**2**

votes

**1**answer

5k views

### Stop “Excel formula or sheet contains the name” dialog

When I want to copy a sheet (within the same file, so simply using left mouse button and Ctrl) in Excel 2007, I get this pop up dialog:
where Author is a specific field somewhere in the sheet I'm ...

**0**

votes

**3**answers

28 views

### In Excel need to copy a range of cells based on single criteria

I am trying to copy/insert a range of cells based on a single criteria. I have tried using the IF function as follows
=IF(B6="RHH1",Sheet2!A4:J15,Sheet2!A18)
The FALSE statement works and the ...

**0**

votes

**0**answers

6 views

### =VLOOKUP() function performed on dollar value displays value without “$”

I'm not entirely sure how to present pleasant-looking spreadsheet representations on SE, so I would appreciate any advice on that issue given on the side.
I want the B2 cell to display the salary ...

**-1**

votes

**1**answer

6 views

### Transpose rows to columns in Excel using formulas

I have the following table of results that i would like to transpose from rows to columns using formulas.
Name Details Values
Server1 CPU 1
Server1 Cores ...

**1**

vote

**1**answer

30 views

### Excel - 'Concatenate' columns with Alt + Enter

I am trying to combine three cells into one, with Alt + Enter or Char(10) separating each value. When I use a simple Excel formula =B2 & Char(10) & C2 & Char(10) & D2 and wrap the text ...

**-1**

votes

**0**answers

3 views

### Ref in external linked excel files

i have a problem with two external linked excel files,
the first called Revenue Analysis and the other called FS - WB
Revnue Analysis reads from FS - WB
When i open the Revenue Analysis it gives ...

**-1**

votes

**0**answers

34 views

### Cell alignment in Excel by same value or within a number of character

I have different text cells so:
As you can see:
Some of the cells in column A are equal to some cells in column B.
Some of the cells in column A are equal from last / or second-last / to some cells ...