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

26 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

54 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

20 views

### Return segment of statement that makes it TRUE [on hold]

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

19 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

118 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

49 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

24 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

34 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

37 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

19 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

23 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

36 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

34 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

32 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

16 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

17 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

48 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

25 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

21 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

17 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

21 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

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

**1**

vote

**2**answers

74 views

### Hiding all but the selected rows of data

I am unable to send any pictures,
The data contains 98 column headings, with the first column being unique identifiers, and 1000 rows of items. I receive commentary on specific items throughout the ...

**1**

vote

**1**answer

47 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

**3**answers

40 views

### Excel X Y (Scatter) Chart more than one value per cell

Is it possible to have more then one value in a cell and then use a X Y (Scatter) chart to represent the dots on the X and Y Axis ?
Here is what I mean:
Instead of having just one value per cell ...

**1**

vote

**1**answer

26 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

**0**answers

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

**0**

votes

**1**answer

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

**-3**

votes

**1**answer

50 views

### How do I get image hyperlink in text? [closed]

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?

**2**

votes

**2**answers

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

**1**

vote

**1**answer

47 views

### Changing a String Value to Date format in VBA

I am working on a VBA scripting in Excel. The following is the code that i am working on.
Option Explicit
Sub MoveThingsAbout()
Worksheets("Sheet3").Cells.Clear
...

**1**

vote

**1**answer

45 views

### Use data from a drop down list to populate table

I am trying to make an employee recognition tracking tool. I would like to have in sheet 1 a drop down list of all the employees in the hotel and a drop down list of the month.
When an employee ...

**1**

vote

**1**answer

25 views

### How to show 0 if formula is not complete in excel

I am using the formula =SUM('7-10'!F12+'8-10'!J12-'8-10'!F12)
This is to work out average daily sales in 24 hours.
But if no sale is recorded for 7-10!f12 but sales are recorded for 8-10!f12 it ...

**-1**

votes

**2**answers

30 views

### Excel: Complete row Hash Value calculated as a Numeric value in a cell on same row

I have to manage "Change Control" on Excel spreadsheets comprised of 1000's of rows and dozens of columns.
Downstream Teams often submit revised columns that I have to incorporate into a master ...