Tagged Questions

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)

-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
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
1answer
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
1answer
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
1answer
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
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
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
0answers
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
1answer
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
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
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
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
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
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
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
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
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
2answers
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
1answer
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
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
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
0answers
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
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
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
0answers
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
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
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
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
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
0answers
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
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
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
0answers
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
2answers
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
1answer
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
3answers
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
1answer
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
0answers
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
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 ...
-3
votes
1answer
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
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 ...
1
vote
1answer
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
1answer
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
1answer
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
2answers
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 ...