**0**

votes

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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