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)

0
votes
0answers
15 views

can I save a view of multiple worksheets in excel 2013

The image below is a view of two (2) worksheets in the same excel 2013 workbook. I made it using View--> View Side by Side, and the sizing each sheet, etc. Is is possible to save this view so that ...
0
votes
2answers
37 views

Get Last 5 Non-Zero Values in a Row

I have a large spreadsheet with many rows where the data can have zeros and positive/negative values but all numeric values. I would like to write a formula (or five formulas if needed) to tell me ...
0
votes
1answer
15 views

Excel Chart Object without source data in Word going back to Excel

I have an Excel object chart in word. The chart is a line graph. The data is there because when I mouse over the line, I see each individual x and y value. However, the word file chart was sent to me. ...
0
votes
1answer
30 views

Excel 2013: I need to go to last row in a table, go up 48 rows, then sum every 12th row

I know that I can use an offset/counta to get to the bottom, then go up a certain amount of rows. But if I use this with a sum, for example: =SUM(OFFSET(M1,COUNTA(M:M)-47,0,12)) I will get a sum of ...
0
votes
0answers
18 views

VBA code to paste value to an indexed position from a match on different sheet

I am struggling for days to make this excel formula work from a command button. =IF(‘Machine Status’!E$28=(INDEX('Import Pool'!$A:$H,MATCH(‘Machine Status’!$B$23,'Import Pool'!$G:$G,1),2)) then cut ...
-2
votes
0answers
17 views

Excel 2003 workbook and sheet damaged [closed]

I am facing problem with an excel workbook. Whenever am opening my data workbook am getting the following error: This file is not in a recognizable format Any suggestions please!
0
votes
1answer
32 views

How do I get a hyperlink open only one internet explorer window

How do I get a hyperlink open only one Internet Explorer window? It keeps opening the same thing from the link but in two IE windows.
0
votes
1answer
29 views

excel copy past repeat macro

At the moment I am working on a research project for my university in excel. Now I have a certain range BF1:DJ293 which has to be copied and past for 238 times to the right. So this range has to be ...
-2
votes
0answers
26 views

Add a “Submit” button to an excel sheet

I need to have this functionality in excel, wherein on clicking on "Submit" button in the sheet selects all text from a column and email them to a group of users. For e.g--Column A has the following ...
0
votes
1answer
31 views

Import external data connections into Excel 2013 for use in Excel 2003

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...
0
votes
0answers
19 views

Excel - How to get list text to display [duplicate]

How do I write this excel cell formula? So I have a RowA which has a list of words and they each correspond to RowB with an "!" or an "X". Row A : This is a list of words Row B ...
0
votes
1answer
27 views

Select text to display based on matching a symbol in another row

How do I write this excel cell formula? In Row 1 is a list of words and they each correspond to an "!" or an "X" in Row 2. Only one word is given an "!". [A] [B] [C] [D] [E] ...
0
votes
1answer
22 views

Enter button dosn't calculate

In MS Excel the ENTER BUTTON when pressed isn't adding up the calculation, example =2+2 enter what happens is the next cell is high lighted Please can you help me? Thanks
0
votes
1answer
12 views

I am trying to setup an Excel sheet to help keep track of our firewall Information

What I am looking for is a formula that when cell "M4" has a value, cell "A16" gets populated with something along the lines of 192.168."Contents of M4".0 I am sure this can be done and I am just ...
0
votes
0answers
17 views

Excel - editing a master tempate

I am encountering a roadblock when I try to edit a blank financial template in Excel. There are specific, highlighted cells in the template which, in theory, should change other cells that are ...
1
vote
0answers
34 views

Unable to insert rows or columns in Excel 2013

I'm using Office 2013 on Windows 7. Few times, I have not been able to insert rows / columns in a some of the Excel spreadsheets. I tried the following before searching on the internet. Use ...
0
votes
2answers
31 views

Dates in Excel - sorting

Is it possible to sort a list of dates by week? For example, if I have a list of specific dates and I want to group them into week 1, week 2, week 50 of the year, is it possible?
0
votes
1answer
21 views

Is it possible to combine HLOOKUP with AVERAGE to get the average of a column if the title matches?

I have a very wide data set from which I need to average certain columns on a different sheet. So I want to list the column headers that I want to average, and then put a formula in that will HLOOKUP ...
1
vote
0answers
30 views

file:// protocol in Excel and Word - Hyperlink URL changes

Clicking on file:///D:/UpToDate/contents/mobipreview.htm?3/4/3141 in Microsoft Excel opens an URL in a browser but omits the file:/// and ?3/4/3141 portions from the hyperlink thus the resource ...
1
vote
3answers
32 views

Insert columns and the formula adjusts with it

Lets say I have a number in cell A1 and a number in B1 and the forumla "=B1-A1" in C1. Now I insert a column to put a new number into the newly made C1 cell and the formula has moved across to D1 but ...
-1
votes
0answers
58 views

iF cell L1 = “Paid” show cell c2 d2 advice needed

I have a formula that looks at cell L if it = "Paid" if blank cell C client name and D Solicitor does not need to be recorded on another sheet. This formula works for me so far ...
0
votes
0answers
14 views

Auto Filter automatically when entering new data

I am new to VBA and are currently working on a little project for myself and got stuck at the following point. I have two sheets that I am working in and this is what I would like to happen. I have ...
-1
votes
3answers
55 views

excel if statement 0 value

I am creating an if statement which helps calculate the difference between two cells and displays the difference as a percentage- here's an example of the code I am using - =IF(D19=E19,"Values are ...
0
votes
0answers
50 views

Auto propagation of formulas down the columns for each new row

How to propagate those formulas down the respective colums for every new row automatically? There is an webhook which creates new rows with data with those columns (A1, X2, Y2) empty, and I would need ...
-1
votes
1answer
27 views

The value given by the Excel NOW() function

I have an Excel sheet that does a some SUMIFS() over manually entered data, including some kind of test for entry date. When I enter a new data line, I first type =NOW() in the cell then copy-paste ...
0
votes
1answer
14 views

Excel overflow when maximized, partially hides the row number column

i have two 24" monitors. when i open and maximize excel on the lead monitor all is good. when i open and maximize on the second monitor the left edge goes off of the screen partially obsuring the ...
0
votes
1answer
33 views

Excel spreadsheet issue

Is it possible for Excel to see what today is and then look at a master file to determine what the next delivery day would be. For instance: Store abc has a Mon Wed Fri delivery I enter information in ...
0
votes
1answer
28 views

How to generate inverted normal random numbers in VBA?

I am trying to generate 5.000 random variables using these excel functions: normsinv(rand()). This is the code I wrote: Dim r As Integer r = 1 For r = 1 To 5001 .Cells(r + 1, 1) = ...
1
vote
2answers
54 views

Using vlookup when data is in tabular format

I want to bring the amount using an excel funcation.it seems vlookup is not possible as database has columns too.I tried searching online,but in vain as I am unable to put my issue in google search. ...
1
vote
1answer
32 views

Sorting every 7 rows till end of worksheet

I have a worksheet with five columns A-E and nearly 10,000 rows. I need to sort every 7 rows till the end of worksheet using data in column C. The following code does the job for the range A1:E7. Can ...
-2
votes
1answer
58 views

pulling specific columns from various excel sheets and putting them to a new worksheet [closed]

I have a report that I do and at the moment it is very tedious. I have 6 separate excel reports with different information in them. I create a new report by going into each work sheet one at a time, ...
0
votes
0answers
36 views

VBA adding rows and deleting rows automatically when changing start/end year

I have 3 tables I would like to change number of rows as I update the number of years. Whether I change end year or start year where the table can flex. The problem I have encountered so far is that ...
0
votes
0answers
38 views

Notepad++ vlookup to Excel

I have an XML file that has some specific incorrect text within it. The incorrect text is associated to a specific code that identifies it,. Eg: CODE="RM014" PART="ROOM MONITOR". The issue is that ...
2
votes
1answer
72 views

Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?

I have a table where track data on a daily base, compare it to a daily target I have set, calculate the gap between the two and display the data on a line chart. The data has 4 columns: A. Date (from ...
0
votes
0answers
51 views

Excel 2010 Chart Not Printing To Size

I have an excel spreadsheet that I am trying to print with a chart located in it. The chart is properly sized in the spreadsheet and looks fine when viewing it in the editor. When I go to print the ...
2
votes
1answer
32 views

Create a double group scatterplot

I need to create a "double grouped scatterplot" like in the image below, where I would like to portray 20 numerical each time. The data exists already in the corresponding format (example given in the ...
0
votes
0answers
7 views

Excel 2010-Protecting Sheet while allowing rows to carry formatting when tabbed into

I have an excel file that allows the user to enter information into a row and when they tab to the new row formatting and drop downs populate for the new row, this happens all the way down the sheet. ...
0
votes
2answers
30 views

Excel Formula to deduct the amount of a text

I want a formula in excel.10 that I have some amounts in Column "A" and their comments in column "B". If I write the text "RECEIVED" in Cell B5 so it automatically deduct the amount of cell "A5" from ...
0
votes
1answer
36 views

Excel freezes for a few seconds

We have a strange problem with Excel 2013 where all excel options will grayed out when we use CTRL+SHIFT+END button to select all the cells. During this time we will not be able to select any cell or ...
1
vote
1answer
39 views

How to fill down when the fill handle isn't working?

I frequently run into an issue where Excel doesn't want to cooperate with filling a formula down thousands of rows. Double clicking the fill "handle" does nothing (wrong data type? wrong file type? ...
1
vote
1answer
12 views

How can I make a UDF run only when all info has been entered in Excel 2007 [closed]

I have a UDF that has Application.Volatile in it. This makes entering info very slow. Is there a way I can run this UDF only when all the info has been entered? I have tried setting ...
0
votes
4answers
98 views

Combining all combinations of data from three columns in excel

I have a few columns of data that I would like to combine, and get each unique combination. Concatenating across a row or set list is easy enough, but I would rather not have to enter each possible ...
0
votes
1answer
30 views

How Can I Comment a Block of Text in Microsoft Office Visual Basic Editor?

Sometimes when I'm writing a macro in Excel's Visual Basic Editor (VBE), I want to comment out a block of code to test the macro without it. I know I could go to each line and type an apostrophe ('), ...
0
votes
1answer
25 views

how to make a Copy formula, Value from A3 to B3 if z3 = csl

Is it possible to have a formula that can copy text value from A3 drop down list of cars, paste the text Value into B3, once i put CSl into Z3. then i can delete A3 but still have the text Value in ...
0
votes
1answer
32 views

Linear trendline equation incorrect in Excel

I'm using Microsoft Office Excel 2007 for some statistics work for school. I made a linear trendline on a graph corresponding to a data set. This is what it looks like: The data set in question is ...
0
votes
0answers
40 views

How do I do probability outcomes in excel? [on hold]

I'm trying to calculate the odds of making the playoffs in my fantasy football league - I know, I know...kinda weird maybe, but oh well. I'm pretty good with excel, but I haven't done any ...
0
votes
0answers
22 views

Xcel spreadsheet formula for sorting qualifying names

I am trying to set up a spread sheet to determine qualification for employee of the month. I am able to insert all the employees that qualify under a certain criteria. How can I make a formula that ...
0
votes
1answer
21 views

lookup col a or b and find match - return column 3

I am trying to compare two different sheets Sheet one has company names sheet two has company names in two different columns note the company names are not exactly the same, i.e one may have a comma ...
1
vote
1answer
20 views

Function to return Unicode Value

If a cell, say cell A1, contains ASCII text: A then I can use the CODE() function to return its numerical equivalent. That is: =CODE(A1) will display 65 Is there a function similar to CODE() ...
0
votes
1answer
31 views

Excel Formula to count unique cells in a range with Condition in another column [duplicate]

I am using the following formula to count the unique values in a range: =SUMPRODUCT(('Sheet 1'!$E$5:$E$900<>"")/COUNTIF('Sheet 1'!$E$5:$E$900,'Sheet 1'!$E$5:$E$900&"")) This formula is on ...