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 ...
0
votes
1answer
20 views
Excel VB Convert sheet text to unicode chars
I need to enter a function in an excel sheet that converts all cells values, that are texts, to it Unicode values.
For example I want ΓΌ to be ü and so on.
How can I achieve this, is it ...
1
vote
1answer
32 views
How do I auto-refresh an Excel auto-filter by colour when the colour of cells is changed?
How do i auto-update an Excel auto-filter (filter by colour) when the colour of cells is changed?
Use case: I change the colour of one cell to the colour that was filtered. I want to see the current ...
0
votes
3answers
35 views
Excel: Find rows with first column empty
My company uses a giant excel spreadsheet that shows which IP Addresses are being used by which computers (among other information). IP Addresses that are not in use still have a row, but the ...
0
votes
2answers
35 views
How do I get the last value of a column in an Excel spreadsheet?
In column A, I have dates. In column B, I have my body weight logged for the day. I add one row to each every day when I weigh myself, so this means the data is sorted by date ascending. The weights, ...
0
votes
3answers
39 views
Excel table - delete rows not in filter
i have a very large table in excel (1000's of rows) and i filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown [ ie dont meet filter conditions]? this would enable ...
2
votes
2answers
46 views
Merging columns in Excel with “;” separator
I'm new here and I hope to seek for your assistance on converting data format of my excel to csv.
This is my raw data in excel in different row and cells:
A B C D E F
1 2 3 4 5 6
...
1
vote
2answers
64 views
Excel 2007 opens with only one worksheet
In Excel 2007, when User A creates a new workbook, there is only 1 worksheet for the book. When user B creates a new workbook, there is the standard 3 worksheets for the book. How do I get this back ...
1
vote
4answers
54 views
How to prevent Excel rounding numbers or adding redundant 0's?
I have a column of numbers that appear like this:
but the actual value of the shown cell is 20130.153334
Other values have a different number of decimal places. I don't want to add redundant 0's, ...
1
vote
2answers
23 views
Excel - Create text file named after a cell containing other cell data
I'm looking to create a .txt file for each value in column A containing the corresponding values in columns B and C
-1
votes
1answer
30 views
Concatenating # with leading 0's in Excel [closed]
I am trying to concatenate 3 fields together but some of the fields have leading 0's. Does anyone know of a way to use this formula and still be successful?
1
vote
1answer
39 views
merge cells with formula skip duplicates
Our Goal is to merge the names (B) when the data in A is equal. The formula below looks at the next line (A), if it's the same, it merges data (name) from B. The formula is in C, so the result of the ...
0
votes
1answer
22 views
Prompt to select excel spreadsheets in Access?
I have a Microsoft Access 2007 database that uses excel spreadsheets to track changes between the two. A new file is generated every week. I then do a compare against the two of them with some custom ...
0
votes
1answer
27 views
Horizontal hierarchy chart in Visio from Excel
I can create a vertical hierarchy chart in Visio from Excel data. Thing is, I need a horizontal (left to right) chart. Is it possible to create?
If not, as a workaround, I rotated the chart, but now I ...
1
vote
3answers
37 views
Should I transition from an Excel file to a MS SQL database?
I currently have an Excel spreadsheet acting as a small data base, about 2000 entries. It is fine for our needs but we now need to allow a couple of staff to securely and quickly access subsets of the ...
0
votes
1answer
38 views
How can I search by SearchFormat in the wildcard text in Excel?
For example, there are 100(row) x 20(column) cells in a sheet, and every single cell has 5 lines. Some lines are in red, some are marked with strike-through, etc. How can I search all lines in red? ...
1
vote
2answers
21 views
Excel: Remove Duplicate Table Filters?
I have an excel spreadsheet in which I have created a table. I have a heading called "Location" which I have applied filters to. When I click the checkbox on this heading which allows me to apply ...
0
votes
1answer
38 views
Drag and Drop files into an Excel Spreadsheet
Is there a way to drag and drop NON Excel files to cells in an Excel sheet? I'm trying to manage PDF and/or JPG files in an excel spreadsheet.
2
votes
1answer
31 views
Can you bring back the “show full cell content” bar (UI element) in new Excel 2007+ ribbon?
In Excel 2003, there was an UI element below menu, which showed full content of a cell where cursor was.
If a field contained a long string which would not fit into the column and would not overflow ...
2
votes
2answers
44 views
Referencing a cell in Excel using values from other cells
I would like to know if it is possible to reference a cell in Excel depending on the value of another cell.
Example
I have a cell, let's say A1 where I have the row number that I want to use (e.g., ...
-2
votes
2answers
55 views
Excel formula to get smaller value of a cell
I want to compare to cell in Excel between two value and when I get smaller value then this value subtracting from third cell is it possible?
for example
cell E1 Value is 961.454 And Cell E3 ...
1
vote
3answers
54 views
Excel 2002 won't activate
I installed Excel 2002 on my Windows 7 machine and activated it. I then uninstalled Excel 2002 and installed the Office 2010 trial to see if it's worth paying for the upgrade (I don't like it btw). I ...
1
vote
1answer
41 views
Lookup and return value based on sub-string match
Is there a formula or script that will match sub-strings from one column in another column and return the full value of the sub-string match? e.g.
Input
COL_a COL_b
name ...
2
votes
1answer
45 views
How to filter and aggregate Excel data in new tables
I have one table filled with customer data. Some examples:
date of last contact
gender
...
Now I want to create a new table where only male customers are shown, ordered by the date of the last ...
1
vote
4answers
82 views
Does Excel have anything like a 3-way switch?
In short, if one wanted to make an IF switch
a) if A < 0.5 ... B = 10.
b) if A >= 0.5 ... B = 15.
c) if A > 1.0 ... B = 20.
How would one go about that?
0
votes
1answer
33 views
Easy way to one-off import data with different decimal separator in Excel?
My OS's locale uses the comma as a decimal separator. However, once in a while I need to process data in Excel which is formatted with a point as decimal separator.
Depending on the source of the ...
0
votes
2answers
49 views
Advanced cell selection in Excel
I am new to this flavor of StackExchange, so if this belongs elsewhere, please move it; I figured this would be the best place, though.
I am making an Excel Worksheet that simply stores basic ...
1
vote
1answer
36 views
How to select radio buttons by cell value in Excel?
I have a group of radio buttons with labels in adjacent cells. How can I arrange for the radio button with the label matching a target cell value to activate?
EDITED TO ADD
Here's an equivalent ...
1
vote
1answer
52 views
Excel: change data source with macro
I'm using a CSV file (generated by a thing party program) as an external datasource, and I'd like to change its path from a macro... How can I do that ?
Another acceptable answer to my problem would ...
0
votes
1answer
21 views
Excel: How to plot a stacked scatter set
I have two datasets that share the same x values, but each have different y values.
I would like to plot both on the same graph, however I do not want the secondary y-axis on the right side of the ...
1
vote
1answer
84 views
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited) file types in excel 2010? They are all listed as a save file type, but ultimately are Comma Separated Value files.
0
votes
1answer
25 views
Step line pivot chart excel
I have a line overlaid on some bars in a pivot chart in excel, but I want the line to be stepped instead of curved. How can I accomplish this?
0
votes
1answer
27 views
Excel chart does not show all line feeds
I'm trying to set up an Excel chart. I've tried to enter 6 line feeds. I have followed the steps correctly, but on the graph it only shows 5 lines. On the right hand side listing of feeds it shows the ...
1
vote
1answer
40 views
Excel: Preserve a data cell's bold/italics in a linked text box
Suppose I have this formatted text in cell A7 of worksheet "myworksheet":
My bold and italic text.
I can get "My bold and italic text" to show up in a text box in a chart by setting the formula ...
1
vote
1answer
34 views
Excel chart by date
I am trying to make a chart that represents our company's order forecast. I want the chart to be a pivot chart so that it automatically updates. I have a pretty in depth table that will be driving the ...
2
votes
3answers
51 views
How to export multi-line cells to CSV file
I have an XSLX file where some rows have multiple lines, for example:
test
test1
test2
When I'm trying to export (using menu "Save As") this file as CSV or Excel workbook (1997-2003), Excel ...
0
votes
2answers
46 views
Excel calculation based on user input from dropdown fields
We are using Excel 2003 but can upgrade if necessary. We need to compute (or lookup) a value based on two inputs. Both inputs will be Excel dropdown boxes.
The first one will have values 6, 9, 12, ...
0
votes
2answers
82 views
Autoincrement the VLOOKUP column index in Excel
This feels like a common question but I cannot get it to work or find an absolute answer:
How to make the column_index "auto-increment" as I drag horizontally the cell with this VLOOKUP formula?
...
3
votes
1answer
34 views
Can I remove images from an Excel spreadsheet by name?
I have a series of large Microsoft Excel 2010 spreadsheets with images in them, and I need to remove 2/3 of those images. All the images I need to remove contain the same string of characters in the ...
1
vote
1answer
32 views
Giving group indicators in Excel 2007 a name rather than numbers
This is a question relating to Excel 2007 - Can you give groups names?
Is there any way of giving the grouping indicators a name rather than using 1, 2, 3 etc?
1
vote
3answers
87 views
I lost the password for an Excel file, how do I recover it?
For some reason I cannot find the password I used to protect an Excel 2010 file a few months ago.
How do I unlock or recover it?
1
vote
1answer
74 views
Excel Macro/VBA cheat sheet?
I'm confident coding in C# & Java, but have never gotten around to writing macro's in Excel.
I was wondering if anyone could point me in the right direction for some NON-beginner cheat sheets for ...
2
votes
2answers
51 views
Excel: How to return the last Row Number that a contains a specific string?
In excel, is there an excel formula I can use to populate Column B (in my example below) that will return the last row number that contains a specific string, before the current row?
The data is not ...
0
votes
2answers
54 views
How to export file from excel (or other excel like software) to .CSV
I have 2 questions
Question 1.
Why is it when I try to export to csv file from excel 2007 I get a file that has a type of "Microsoft Office Excel Comma Separated Values File (.csv)"? I choose "Csv ...
0
votes
2answers
53 views
Is there any shortcut to iterate through Excel's worksheet tabs?
Is there any keyboard shortcut to iterate through Excel's worksheet tabs more easily?
Maybe something that would allow me to see all the tabs together and select one of them to switch to it.
1
vote
2answers
114 views
How do you average time, I keep getting 00:00:00.
I am trying to average time. The time format in the cells are 0:00:00. I have changed the number section at the top to time however I keep getting 00:00:00 as the answer.
1
vote
2answers
79 views
How to find the latest date/time on the column using macro
I have data generated from the system that looks like the table below. On the last column I need to display the user who was the last one updating the system from each dept.
Update Time User ...
0
votes
1answer
48 views
Excel: Automatic series with scatter plot
I have a 3-columns table (Date,Time,Value). I would like to automatically plot the table using the following format:
X-axis: Time
Y-axis: Value
Series: Date
This would give me a different ...
2
votes
3answers
79 views
Excel - automatically fill down a row with date range matching a specific pattern
Given a specific start date (say Jan, 11th 2012 for example), I want to fill down a row in excel automatically with a date range matching the following pattern for the days (bi-monthly pay period).
...
0
votes
3answers
56 views
How can I avoid the clipboard message box when copying large amounts of data in Excel?
I have a macro that is copying 4 sheets from one workbook to a new workbook and saving it down with another name.
Unfortunately the message box asking me whether I would like to make this large ...
5
votes
1answer
75 views
Where are possible fragments in Excel URLs documented?
When creating links to Excel files it is possible to add a fragment to the URL in order to specify a specific location (e.g. a certain sheet) which should be opened when the link is followed. See, for ...
