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)

0
votes
3answers
45 views

Find entity in a list of entities and give back another cell value based on which category it belongs to in excel

I want to find a nice way to get a specific value based on a category and another characteristic. I'll try to to exemplify it below; Problems: 1) I want to check what category a certain entity ...
1
vote
1answer
17 views

Custom date auto fill

I need to auto fill the following date pattern: 1-Sep-2014 1-Sep-2014 1-Sep-2014 2-Sep-2014 2-Sep-2014 2-Sep-2014 3-Sep-2014 3-Sep-2014 3-Sep-2014 If I select all the above cells, and pull down ...
0
votes
0answers
19 views

Trying to make a Bibliography from book database

I try to transform a book database excel to a text bibliography index in word. We need to copy text and formats, in a one line per book text with negrita (for autor), and (cursive) for title, and i ...
-4
votes
0answers
39 views

INDEX AND MATCH

I am using a formula w/ index and match and it returns data where it should be blank. help ex miles month unit 1000 apr 101 1001 may 101 1001 jun 101 1002 jun ...
0
votes
1answer
25 views

Excel: INDEX and array on another sheet

My raw data is a list of students and their grades on Sheet 1. 6th Bobby 6th Carl 7th Tommy 8th Bobby I want Sheet 2 to give me a list of students based on the grade I input into cell A1. example: ...
2
votes
1answer
19 views

Excel Formula…Complex…Invoice tracking without inputting info into multiple spreadsheets

I have a list of store# in one worksheet(1) and another worksheet which has (2)invoice tracking for these stores. As the store# & invoice # are added to one worksheet(2), I want the invoice number ...
-3
votes
1answer
93 views

Excel - sumproduct/sumif

I am able to look up single values that meet multiple criterion; but I would like to do more, I want to sum up values that meet two conditions - year and country like in my example. I tried it in my ...
0
votes
2answers
66 views

Enhanced Vlookup Excel Formula

I am looking for an excel formula that I can use to automatically fill E2 in the screenshot below. The intention is to find Marc's age from column B, ie E2 should be 20. Any ideas please? I have tried ...
-1
votes
0answers
21 views

Standard deviation per month in certain year excel

So I have a dataset containing daily stock prices of over 20 years. The dates are the top row and all the companies in the first column. And per date per company is a certain return. Now i want to use ...
0
votes
0answers
18 views

link excel sheet to word doc and be able to change multiple cell values at one time [closed]

I would like step by step instructions on how to link excel sheet to word doc and be able to change multiple cell values at one time. I have linked up several tables but then if I move to another ...
1
vote
1answer
30 views

Excel formulas: Dates A, B, C and D. How many days between A and B also fall between C and D

Example: A1 = 8/5/2004 B1 = 29/12/2004 C1 = 1/1/2003 D1 = 21/11/2004 I want to work out how many days between A and B also fall between C and D. I can't get my head round what the formula to work ...
0
votes
1answer
16 views

Compare 1 column with 3 others and extract values from col1 that do not appear in other cols

Hey I have column A that has a list of text values, and have columns B,C,D which contain some of the same text values. I want to extract the values from Column A which do not appear in column B,C or ...
0
votes
1answer
21 views

Picking N Values at Random From Column

Is there a way to have Excel pick N values at random out of a column where the total number of items in the column is greater than N? I was thinking of just doing =RANDBETWEEN(0,1) but this has the ...
1
vote
0answers
15 views

How do I change the function field in excel to show Bengali Characters?

I received an excel file that has columns translated from english to Bengali. I have a Bengali font installed and it shows up in the main body of the spreadsheet but the characters are not showing up ...
0
votes
2answers
14 views

How to assign rows in multiples of a number (Excel/Google Docs)

For example, I want the first entry in Column B (B1) to show A5, then B2 shows A10, then B3 shows A15. How would I go about doing this?
-1
votes
3answers
84 views

Microsoft Excel Splitting rows in a column into a separate column

I have a couple of thousand rows of data in Excel where each logical record uses two rows, with the Job/Eqp number and the Job Name in column C on alternating rows. I want to move the Job Name data ...
1
vote
0answers
34 views

Reset Numbered List with Text Style VBA macro MS Word

I'm trying to make a VBA macro to create a Word document from Excel... Currently I'm having issues with setting up the Lists properly. I want the list indexes linked to my 2 header types. Like so: ...
0
votes
0answers
15 views

VBA Code Won't Work if Any Cells Protected

I have a shared workbook that needs to have a set amount of protected cells. I also cut and pasted some VBA code into the workbook that allows multiple data validation drop down selections for the ...
-3
votes
1answer
46 views

How do I get image hyperlink in text?

I have images with hyperlinks (copied from internet). I need to convert those hidden hyperlinks to URL in another row. How do I do that?
0
votes
1answer
19 views

How to add New Excel Worksheet in the Right Click New context menu? [duplicate]

OS - Windows 7 (32-bit) Office Version - 2013 Standard Whenever I right click on a blank space in a folder, I see option to create a New Folder / New Word Document etc, but am not able to see a New ...
0
votes
0answers
17 views

Hiding the Microsoft Query table properties in Excel

I have done a data connection in Excel using the "From Microsoft Query" data connection type. In that i have also set criteria where the values are taken from a particular cell. This is so that the ...
1
vote
2answers
50 views

summing values that match text critera

I have a need to create an Excel Sheet that can compare a column of employees' names to a second sheet that has a certain number of monetary figures, as such: list of specific employees who's profit ...
1
vote
1answer
791 views

Filtering by currency in Excel

I have this situation in Microsoft Excel: Cells are formatted by using "Format Cells" and setting the Currency manually for each cell. So, they are not simple strings. I would to sum filtering by ...
1
vote
6answers
23k 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, ...
3
votes
3answers
5k views

Formula in table header cells

I have a table in Excel 2007 that I want to summarise, in a similar fashion to a Pivot Table, but for various reasons I can't use a pivot table. I like the "Format as table" features of sort and ...
0
votes
1answer
83 views

how do i get a simple IF function to work in Excel only when another cell has a value in it?

How do I get a simple IF function to work in Excel only when another cell has a value in it? I've tried =IF(ISBLANK(G4)="Sold","Closed","Open") but that didn't work so I was wondering if anyone could ...
0
votes
0answers
11 views

How to be able to write numbers in multiple languages in MS Excel?

In MS Word we can set the Numeral option to Context and be able to switch the language and use it's numerals, This question has the answer that shows how to do it. I can't seem to find anything at ...
0
votes
0answers
21 views

direction does to RTL in Excel when I add sheet

When I add a new worksheet to my workbook in Excel 2010 (by clicking the button insert worksheet next to sheet names), one sheet will be added and the direction goes to RTL from LTR automatically and ...
2
votes
4answers
3k 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
4answers
60k views

Keyboard shortcut to change case of text in cells in Excel 2010?

Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.
0
votes
0answers
13 views

Dynamic Scenario output in excel

I have a model where in the input numbers going into the model depend on the cases/scenarios i select from a drop down menu ( Base, Best and Worst). These numbers are then used across all remaining ...
0
votes
1answer
18 views

Excel 2013 scatter plot

Hi I'm creating a sieve analysis graph. The graph is in logarithmic scale but I want the labels in the horizontal axis to be exactly as per the sieve sizes (horizontal data values) Can I make the ...
0
votes
2answers
3k views

Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...
1
vote
2answers
697 views

Decimating rows in spreadsheet

Is there such an option to preserve only every 10th row in my spreadsheet? It can be Excel or Calc. Quality standards want some noise to be added.
6
votes
2answers
5k views

Why does pasting into an unprotected cell in Excel protect it?

While researching the answer to this question, I stumbled across a rather odd behavior in Excel related to unprotected cells in protected worksheets. To see what I mean, create a new workbook, ...
0
votes
0answers
17 views

Find and replace multiple values within selected cells using another workbook

I was wondering whether anyone could point out what's wrong with the VBA code below. It's based on the following: Find and replace multiple values within selected cells I want it to take the find ...
0
votes
1answer
3k views

How to trim out extra characters from values within an Excel column?

I have an Excel sheet which has a Text column Name Object Name. Now I have another script which using these columns further processing. Now before running the script with it, I want to trimmed out ...
1
vote
1answer
39 views

How to set up data validation to allow only a date or a specific string

I would like to use data validation to ensure someone has entered a valid date, but I'd also like them to be able enter TBD - just those two options. Is this at all possible without VBA? Is there a ...
0
votes
2answers
13k views

How to disable auto recover?

I've tried disabling "Save AutoRecover information" option, but to no avail. The window "Excel has recovered the following files" still pops up at the start. Any other ideas? UPD Auto-recover window ...
1
vote
1answer
23 views

Flip x and y axes in Excel graph

This should not be very difficult, but I cannot figure out how to do it. I have a table similar to this %low %high 0 0 12 1 13 26 ... 19 90 94 20 95 100 When I graph it, excel ...
0
votes
2answers
7k views

How to force Excel to open CSV files with data arranged in columns

I generate a CSV file with an extension .csv in which every piece of data in one line is separated with a comma: 1,2,3,4 1,2,3,4 The file is sent via email and I want that when a customer opens it ...
0
votes
1answer
522 views

Why Excel doesn't ask(prompt) to Save the file which is modified while closing

This is what happens, I open an Excel (2013) file (of any kind) Make changes to the file. Close it. Before, it used to ask if I want to save the file sine it's modified. Now, it closes the file ...
2
votes
4answers
4k views

Generate a comma-separated list of cell contents, excluding blanks

To concatenate a certain four cells, I'd use: =CONCATENATE(A2,",",C2",",D2,",",F2) This would make it so that... A2 = "Matthew" C2 = "Mark" D2 = "Luke" F2 = "John" would result in ...
-1
votes
2answers
44 views

how to cancel the focus change of cells in excel 2007?

When I move the cursor in Excel 2007 from cell A1 to cell A2, so that cell A2 is highlighted instead of A1, sometimes I press the tab key too quickly, so I try to go back and highlight A1 again. I ...
0
votes
1answer
2k views

Excel 2010-line graph not displaying data as desired

I will to plot a line graph of year vs. sales on excel 2010. However, the years are displaying on the y-axis wihile nothing but 1,2,3 etc is displaying on the x-axis.... Anybody might know what the ...
2
votes
2answers
33 views

XLS files on website

I have an XLS file, such as www.mysite.com/test1.xls. When clicking on the link it always brings up the spreadsheet inside Internet Explorer, with excel embedded in the browser and in a less ...
39
votes
7answers
67k views

How do I join two worksheets in Excel as I would in SQL?

I have two worksheets in two different Excel files. They both contain a list of names and addresses. One is a master list that includes other fields, and the other is a list that only includes name ...
0
votes
1answer
28 views

Copying worksheets in Excel

I have a shared Excel workbook with two worksheets in it named "PREVIOUS" and "CURRENT". At the end of the night, I would like to click a button or perform some action to have the CURRENT sheet copy ...
2
votes
2answers
253 views

Excel: searching for a maximum lower than X

From the sorted list of values, I'm looking for a maximum that is lower than X Example: A B C 1 1 X=7 2 3 3 5 4 8 ANS=5 Do you have any smart ideas for this problem?
0
votes
1answer
2k views

How do I get Excel to pull data from multiple workbooks from exact dates based on an entered date

I am running windows-7 and using Excel 2007 Enterprise. I am a truck driver and need to catalog my pay based on a changing day to day system. I am paid per mile, per stop, per hour, or per flat rate ...