Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). Features and usage The latest versions ...
3
votes
2answers
43 views
Why is Excel removing leading leading zeros when displaying CSV data?
I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell 2A attempts to display "01" as a ...
0
votes
1answer
18 views
Use Excel Table Column in ComboBox Input Range property
I asked this in StackOverflow and was redirected here. Apologies for redundancy.
I have an Excel worksheet with a combo box on Sheet1 that is populated via its Input Range property from a Dynamic ...
1
vote
0answers
36 views
File in use when it's really not
I am running Windows 7 Professional 32 bit on a Server 2008 network. I am getting a weird issue with an excel document where I open it up one morning, update it, save and close, the next morning I ...
0
votes
1answer
26 views
Is there a macro to split the contents of an Excel spreadsheet into separate spreadsheets?
I know there are similar questions out there but I don't think they are quite the same.
I have an excel spreadsheet with the following headings-
First name -- Surname -- Host Trust -- Contact ...
0
votes
3answers
42 views
How can I compare Excel serial dates WITHOUT converting to mm/dd/yy type dates?
I have a table that contains a number of values representing Excel serial dates. After a number of unsuccessful attempts to compare fields, my current approach is to do comparisons between serial ...
0
votes
1answer
19 views
Vlookup to retrieve an ID from table using text match
I've got an excel spreadsheet where I would normally use a VLOOKUP.
In this case I need to find the ID of the record when comparing email addresses, so the email address is the unique id here.
For ...
2
votes
2answers
66 views
How do I `SUM` by multiple columns in Excel
I have a comma delimited file that includes two columns date/time (which imports as Excel's mm/dd/yyyy hh:mm custom format) and status of 1 or 0. The status represents a piece of equipment either ...
-1
votes
2answers
49 views
bloated excel file with negligible data
I used ctrl+shift+down to enter formulas across all the rows, is that the culprit?
It has only 3 sheets and only a couple rows in one sheet and around 100 rows in another sheet (with only 3 columns)
...
0
votes
3answers
29 views
excel drop-down data
I'm using list feature to implement drop-down in excel.
Sheet2!$A$2:$A$101
Is there a way to replace it with something like
Sheet2!$A$2:TILL_THE_END_UNTIL IT SEES A BLANK COLUMN
instead of ...
-1
votes
1answer
27 views
Is there a tool to get data from a pie chart instead of the other way around?
I'm looking for a tool that helps me creating an investment portfolio. I'd like to decide the percentages first, and then the tool would output quantities. Also, percentages should be hierarchical. ...
0
votes
1answer
46 views
How can I create matrices of data in Excel?
I want to create a 4*4 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
3 ...
0
votes
1answer
38 views
Create Excel pie chart from choice placement
I have a table like the following :
Choice 1 Choice 2 Choice 3
Person A 3 2 1
Person B 1 2 3
...
0
votes
2answers
49 views
Excel Function Opposite of Vlookup
I've got two columns in Excel
like that. Is there a function to achieve the "NOT HERE" column? I tried using vlookup and http://superuser.com/a/289653/135912 to no avail =(
Any help would be ...
2
votes
3answers
37 views
How to sum up numbers conditionally in Excel?
I have the following Excel document, which tracks hours needed to implement various tasks by the development language (c#, sql, vb6):
In the cell E8, I'd like to calculate the total amount of hours ...
0
votes
1answer
34 views
Function to intelligently concatenate/combine tables in Excel
Which function in Excel will intelligently combine tables using a common column as an index?
For example: http://s10.postimage.org/8dwh1agfd/superuser.png
1
vote
1answer
37 views
Find column where sum is meeting condition?
A have a sheet with resources and week together with availabilty per week (hours). Like this.
Resource 1225 1226 1227 ... 1252
.NET 30 30 15 ... 30
Java 40 40 40 ... 40
In ...
2
votes
2answers
36 views
Excel - define a formula in one cell to be used in other cells with different inputs like a function
I use excel 2010.
I want to use a formula defined in one cell as if it was a user-defined function.
Example:
In A1 I put something like (I know it's not a real syntax):
= 3 * Input + 15
And then ...
0
votes
3answers
51 views
excel - how to enter formula for entire column
I know if I select the entire column and then enter the formula in first column and then press ctrl+enter, it would be taken care of. However, my first row is title row. How else should I do it?
0
votes
3answers
33 views
Excel: convert a column with hyperlinks to just display the links
In Excel, I have a column of links that display text instead of the actual link.
I actually need the links, is there a way to bulk convert the entire column so that the links are exposed? Otherwise I ...
1
vote
1answer
22 views
How do I make my Mac Air running Lion recognize Chinese characters in Excel?
I open an Excel document with Chinese characters and see the following.
How do I make my Mac Air running Lion recognize Chinese characters in Excel?
0
votes
0answers
48 views
Excel/Powerpoint found unreadable content
Since I upgraded my office to 2010, I experienced this error. When I try to open an Excel sheet every now and then Excel's telling me that my file is corrupted. When I try to "recover" the file, all ...
0
votes
2answers
26 views
Excel look-up column data
I have two data tabs for survey responses - the first shows the full set of exepcted responses an which office they are from
HMIP LDU
1 Leeds
2 Leeds
3 Leeds
4 Leeds
5 Wakefield
...
0
votes
1answer
32 views
Formula in Excel graph
I am creating a line graph in Excel 2007. What I would like to achieve is to specify a formula in the chart data range.
What I have now in the chart data range is:
...
0
votes
1answer
22 views
How to autofill a column with a single text and making it read only?
I need to create an Excel file where the first column of every row should be a fixed text string.
This column should not be editable.
The reason for this requirement is that the user can save this ...
1
vote
2answers
33 views
Reading macros in an Excel file?
I've got an Excel file (supplied by someone else) that opens with the message
This file contains Visual Basic macros.
I'd like to look at the macros within the file - they contain code that I ...
1
vote
2answers
34 views
How can I fully duplicate an Excel sheet in another workbook?
I have workbook A, which has 20 sheets in it, that I work out of consistently. There are 3 sheets out of this workbook that I would like to put into a new workbook, and put it in the public folder of ...
1
vote
2answers
59 views
excel formula to calculate average of consecutive 24 hour blocks?
Microsoft Excel 2010, input file of thousands of rows of hourly data, thus there are 24 values (rows) per day.
Let's assume that my data starts at B1, and let's assume that I put my average value for ...
0
votes
1answer
47 views
How to get the difference between two dates based on an item (truck) number
I'm trying to set up a database for a co-worker to track information based on truck number, amount disposed, etc. Sometimes trucks are left with garbage at then end of the day. That truck may not be ...
1
vote
3answers
63 views
How do I calculate number of hours > 24 in Excel?
I've got an excerpt of my spreadsheet below. It's a time tracking application containing a start date/day, a session ID and the duration of the session. Column A is populated by adding the duration in ...
0
votes
3answers
31 views
microsoft excel apply formula wrongly
Basically I am facing some problem due to excel auto generate formula that is wrong in such situation.
The formula at B6 is =A6*B1
Then the rest of the rows are using cursor bottom right drag down.
...
3
votes
3answers
75 views
To much text for an Excel cell
What do I do when I have more text in an Excel cell than I want to (was "can") show in the allocated space?
(Something making it "scrollable")
2
votes
1answer
57 views
Creating a Graph with Two X-Axes and Two Y-Axes with an Angled Secondary X-Axis
I'm struggling to create a graph that is supposed to end up looking like this:
I have been able to graph everything except for the secondary x-axis at the top for temperature in degrees Celsius. Is ...
1
vote
2answers
42 views
Why does Find in Excel give unexpected results?
I would like to find all cells containing the number 18 in an Excel 2007 worksheet where the numbers are in a column with entries in General format (both numbers and strings).
When I use the Find ...
2
votes
2answers
13 views
Excel COUNTIF Statement
A---------------------------B
2012-04-12 12:52...... FC
2011-06-24 10:07...... FC
2011-06-24 10:08...... FC
2012-04-17 0:00 ...... COH
2012-04-12 12:22 ...... FC
2011-06-24 ...
2
votes
2answers
45 views
How do I enter an @ at the beginning of cell (when its not a formula)
I often need to do such things as enter a column of twitter handles. But if I start a cell by typing "@", excel assumes its a formula, and worse, refuses to accept a bad formula.
0
votes
3answers
28 views
How to resolve #NAME? error in Excel?
I'm use Excel 2003. There is numeric information in Cell AI in my Spreadsheet. The cell is formatted as numeric with 4 decimal places. In Cell AK, which is also formatted as numeric, I type =AI and ...
0
votes
0answers
17 views
Percent of Hidden Values in PivotTable? Excel
I have a Percent of Parent Column field that works fine. But in the axis of values, I only want one shown to make the table much more compact. Essentially imagine if you had a table showing the ...
0
votes
1answer
20 views
excel - protect a sheet always?
To me, it seems like the way to edit a protected sheet is unprotect it and type some stuff in and then protect it again before sending it to someone else. What if a user forgets protecting it before ...
0
votes
1answer
44 views
Conditional formatting 2 different colors every two rows in Excel
I want to apply conditional formatting to change the background color of alternating rows on a spread sheet. The rows will alternate between two colors (yellow and green) two lines each.
This is the ...
0
votes
0answers
11 views
Outlook 2007, importing contacts?
In Outlook 2007, why can I import contacts, via Excel file, into one person's Outlook and it looks fine, but in the other person's outlook, it doesn't show the email addresses? Same file for both ...
1
vote
1answer
15 views
Excel - set data range for multiple charts
I have a 'dashboard' of weekly stats - with week numbers in the columns across the top, and about 70 metrics in the rows.
I want to create around 20 charts from these different metrics, but always ...
0
votes
1answer
27 views
Excel 2010 Help name worksheets automatically
I need to create a work book containing 52 sheets, with the first being named week 1, then week 2 and so on. How can I do this without renaming each sheet manually.
Thankyou
2
votes
0answers
35 views
Excel: Exporting Formula to other languages?
I am currently using excel to simulate some hardware control logic for a processor (for a class). I am only using four formulae: If(), Or(), And() and string operations MID(). I am trying to convert ...
0
votes
0answers
12 views
Excel Autofill Preserving Labels
I would like to Auto fill a formula across a form. The Form has a number of labels I'd like to keep the same, and a number of blank cells that need to remain blank. Is there a way to protect those ...
1
vote
1answer
31 views
Is there a formula in excel to allow a search in one column? (we're trying to pull specific cities from one column)
Okay, so we have an email database with the home address for each person in it and we need to know if we can enter a formula to search the database to find the specific cities. The column for cities ...
0
votes
0answers
23 views
Pivot table using comma separated cells
I need to mimic pivot tables for comma separated cells, and output into comma separated cells as well, grouping by country. I have about 100 rows of this data, so I cannot convert to column or rows. ...
1
vote
0answers
67 views
Create line graph with embedded horizontal histogram
How do I create these kinds of graphs:
with the horizontal histogram counting the number of times the left graphs go through a certain range?
I have access to Microsoft Excel and R.
2
votes
2answers
93 views
Conditional Formatting Alternating Rows in Excel
I want to apply conditional formatting to change the background color of alternating rows on a spread sheet. The rows will alternate between two colors (yellow and green).
The only problem is, that ...
0
votes
1answer
23 views
Go to last line with data, Excel 2007
Is there any button combination to jump directly to the last line containing data in Excel rather than scrolling through thousands of lines?
0
votes
1answer
47 views
#VALUE! error in Microsoft Excel
=IF(ISBLANK(S3);"";CONCATENATE(" UPDATE kkr_urunkredi ku
SET ";IF(ISBLANK($A3);"";CONCATENATE(" ku.yatirimsuresi =''";$A3;"''"));"
ku.kredikonu_kd =''";$B3;"'',
ku.kademeli_drm ...
