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
1answer
11 views

Expression in Access involving dates

I have written the following formular in Excel to calculate the year a person will be 18 by 1st September based on their DoB (in cell F2). It seems to work ok in Excel: ...
0
votes
1answer
61 views

Plot two time series with same start and end time: data does not align with axis

I'm trying to plot graphs for pressure and temperature recorded on different devices. The number of data recorded for each device is different (Eg. pressure has 1 reading per second while temperature ...
2
votes
3answers
162 views

Converting a .txt file with tab as separators into a excel spreadsheet

I have lines of data in a text file where each entry is separated by tab. I want them in different columns and each line to form a separate row in excel. I tried using Data > Import but it all comes ...
2
votes
1answer
21 views

How to use the 'left-arrow' key to move my cursor when typing into a cell for the first time

Using Excel, there are many instances when I need to move the cursor back 'in-between' characters, like in the case where I write open and closed parenthesis and then fill in the rest: ()*my_cursor ...
0
votes
1answer
15 views

Running Excel Line Graph?

I have a spreadsheet that automatically scores a questionnaire into 10 different subscales in the first worksheet. What I would like to be able to do is plot each data collection point on a line ...
0
votes
1answer
11 views

Keeping Page Breaks the Same Reguardless of User

I am having a problem with page breaks in the same document (on a server) moving when the same document is opened on another computer (actually the page breaks are not moving, but the number of pages ...
0
votes
1answer
24 views

Highlight Duplicates Not Next To Each Other Using Conditional Formatting

We have a list of parts in Excel in a certain order. For reasons I won't get into, we need to highlight when there are duplicates that aren't next to each other. Currently, I'm using this formula in a ...
0
votes
0answers
38 views

Excel VBA Script How to Open a File and Insert character into Cell

I'm hoping this is an easy one. I am importing a directory of CSV files with long numbers (16 digits plus 4 leading zeroes). I need Excel to preserve the number data instead of applying scientific ...
0
votes
1answer
24 views

How to compare a column with previous column when the new column has more data sets in it?

I am trying to compare weekly account sales numbers to their previous weekly amount. However the new week has more accounts in it (on average 50 more) than the previous one, how can I add these ...
0
votes
2answers
35 views

How do I get SUM and COUNT of below in an Excel worksheet?

I have dates in one column, names in the next column and counts in other column. I want the formula to count the individuals as per the date. 1. For example, on 11/1/2014, I want Sum of Kiran's ...
0
votes
1answer
27 views

How to apply formula to a cell dependent on data from drop down list

I hope I can word this to where it makes sense. I'm working on a budget. Basically broken down by month. So in the budget, if it is February, I have to estimate the remaining months of the year. I ...
0
votes
1answer
52 views

Macro: Insert a new row above a cell containing a value

I have a column containing the following values: A1 = 0 A2 = 1 A3 = 3 A4 = 4 A5 = 0 A6 = 1 I wish to select column A and insert a new column above any instance of 0. I have tried the following code ...
-1
votes
1answer
15 views

populate cells from another worksheet

I need to populate a worksheet with a calculation based on 2 cells in another worksheet within teh saem workbook. In worksheet one I have a table with 'Last Month' and 'This Month' that contain ...
0
votes
1answer
23 views

Chart the TIME something happened on a series of DATES

I have two columns of data. Column 1 is the DATE (i.e. 1/5/2011 ) Column 2 is the TIME a thing happened on that DATE (i.e. 16:42 ) I need the DATE to be on the X axis and the TIME to be on the Y ...
0
votes
1answer
25 views

Random Sampling in Excel based on specific criteria from other colums

I have a list of file numbers in Column A, a code associated with the file in column B, and a number of days in column I. Example: File Code Days 12345 AAAA 100 54321 AAAA ...
3
votes
1answer
51 views

how to create vertical line in excel for multiple charts/multiple y ranges

I am trying to add in vertical lines to my line charts to represent an important data/event, and the way I went about doing so was adding in the max value of the y range for the specific date as seen ...
-2
votes
1answer
19 views

Return segment of statement that makes it TRUE

H I J K L M Lenght Width Height Compare_Length Compare_Width Compare_Height 3.750 3.750 4.500 3.750 3.750 ...
0
votes
1answer
18 views

modify excel paste options

This is what happens when Excel "fixes" my pasted data. The copy source is Notepad++. I never want this to happen. How do I turn all modifications of data into Excel off - forcing "text" as the data ...
0
votes
2answers
21 views

Sort Excel Row Based on Values in Another Row

Sorry if this question has already been answered, I looked but I didn tfind anything that was quite what I am trying to do. I have a lot of spreadsheets where I have something like: A|B|C|D|E|F... ...
1
vote
2answers
117 views

How to fit mm/yyyy in SUMIF criteria

I've looked around for answers regarding this, but am still a bit confused. I have a column A in Excel with dates in the format mm-yyyy (i.e. September 1014 is Sep-14). I want to add all the values in ...
0
votes
0answers
37 views

how to get exact value from Y axis and X axix for any point in chart

I have a chart with line graph. now for a particular point on the line how can i get the exact co-ordinates from Y axis and/or X axis. For example if the major unit on Y axis is 200 and Minor unit is ...
1
vote
1answer
23 views

Excel - auto-fill blank cells or 0 in B:B to a dummy e-mail address which changes sequentially

I am creating a database in Excel that requires an e-mail address to be assigned to each row or user. While some users have an e-mail address in the original CSV file the majority do not. Each e-mail ...
-6
votes
0answers
25 views

How can I split 2 sets of data into a multifile in Excel

I have 2 sets of data in 1 sheet, how can I split these into a multifile Raw data is CUS Name Number 01 AAA 011 01 AAA 012 02 BBB ...
0
votes
2answers
28 views

Error is using Microsoft Query data in excel in 3rd Person's PC

I have a problem when using Microsoft Query in Excel Data Link. I have used SQL Server Connections before in Excel. When we use SQL Server, after doing the connection and retrieving the data, the ...
2
votes
1answer
27 views

Excel 2007 Formula Issue - Newbie

I have a cell containing 5;9;11;13;15;17. There could be upto 15 different numbers in the cell. These numbers represent attributes. For example 5 = Padlockable, 9 = Keylock etc. There are around 50 ...
0
votes
1answer
32 views

minitab or ms excel function for a conditional count

Is there a way to count how many times some number(zero in my case) occur before another number occurs in the same series in either minitab or ms excel(or any other statistical software)? Eg: if I ...
2
votes
1answer
30 views

Excel is pausing my word doc each time it refreshes the link between the tables that I have in excel and my word doc

I have a word doc with many linked excel tables in it. Every so often, word has to pause while the excel automatically refreshes it. How can I slow down the intervals between refreshing to say once ...
0
votes
2answers
26 views

Excel Formula - if there is data in any of A - F cells, copy that data into G cell

Can anyone assist with this formula? I need to have data (number) copied into a cell from any of the other 10 cells. For example, I have 10 cells all of which might have data in them (only one cell of ...
0
votes
1answer
35 views

Excel COUNTIF criteria using curly brackets for logical OR not working

Given the following in column A: tom bob harry tom2 bob harry tom3 bob harry I want to count "tom" OR "bob" using =COUNTIF(A:A,{"tom","bob"}). However the function returns only 1 instead of 4. If ...
0
votes
1answer
29 views

Running subtraction in Excel

I have a number which is the number of sessions of therapy a person needs to have in a month. I want to subtract each session from that number and see the new total every day. How can I get that in ...
1
vote
1answer
18 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 ...
-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 ...
2
votes
1answer
21 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 ...
2
votes
2answers
35 views

How can I get information from one cell in a row, based on the clue of 2 other cells in the same row?

I'm trying to get Excel to give me information in Column C based on the values in Columns A and B. Cell A and Cell B will contain duplicates, and what I'm trying to do is build a formula which finds ...
1
vote
1answer
30 views

Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot : The Layout : 1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...
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 ...
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 ...
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
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 ...
0
votes
0answers
16 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 ...
1
vote
0answers
40 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
2answers
19 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?
0
votes
1answer
24 views

How to replicate an anchor tag in Excel

I have an Excel (csv) like this: column1 link yahoo <a href="www.yahoo.com">Yahoo</a> google <a href="www.google.com">Google</a> Is there any way to make link ...
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
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 ...
0
votes
0answers
15 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 ...
-2
votes
0answers
39 views

setting up notification by email from excel

I maintain a service schedule in an Excel spreadsheet. I would like Excel to notify a workgroup by email 30 days before a due date that it is coming up. Is it possible for Excel to send, or trigger ...
0
votes
1answer
20 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
0answers
19 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 ...