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
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
33 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
33 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
58 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
51 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
57 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
33 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
59 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
38 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
77 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
8 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
37 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
108 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
26 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
33 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
41 views

How do I do probability outcomes in excel? [closed]

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
23 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
34 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 ...
6
votes
2answers
93 views

How do I stop excel from turning numbers and dates to # in short columns

Question I have an excel document that is being used for reports. For readability I currently have all the columns fairly narrow and am using cell overflow a lot visually. I want excel to recognize ...
0
votes
0answers
27 views

How do I bulk replace a hyperlink containing a File:\\ command in excel

I work with Sharepoint 2007 and Excel 2007 In SharePoint I sometimes use a hyperlink with the file command like; (file://\\group.net.dk\sites\S01625\stt\Drawings). This is useful when I want to open ...
0
votes
2answers
42 views

How to compare two columns with other two columns for duplicates in Excel

I need to compare columns C and D with A and B and only if exist same combination of two cells in one row. Hope the image below will explain the situation better.
0
votes
0answers
42 views

Trying to get VLOOKUP to get data from a table array on another workbook where the worksheet name is variable

I currently pull data in from 4 workbooks using the INDIRECT function, the formula is as follows, =INDIRECT("'[" & $AE$1 & "]" & $AA$13 &"'!" & $AI$1) $AE$1 contains the workbook ...
0
votes
2answers
33 views

Excel outer border around two rows

ID Date Code Price 9202188 04/11/2014 212015 29,47 212026 30,5 9202190 03/11/2014 813012 99,47 814027 60,5 I have ...
0
votes
1answer
27 views

How to determine next Delivery date based off today's date

I have many stores with various delivery dates. For instance, I have a store that gets a Monday Wednesday Friday delivery but I may input product for them on Saturday, so I need it to see today is ...
-1
votes
2answers
37 views

Is there a way i can copy this macro i made but have it change for the next tickbox

I have made this macro to Select cell A3 copy the value and paste it into cell Y3. it then clears cell A3 as that's a dropdown box, by doing this the dropdown option can be now selected in A4. ...
-1
votes
1answer
30 views

VBA not recognizing MsgBox property VbMsgBoxStyle

I'm getting the error message "Compile Error: Named argument not found," when I try to run my VBA code. VBA doesn't seem to recognize the last property VbMsgBoxStyle. Dim dump As VbMsgBoxResult dump ...
0
votes
0answers
9 views

Excel legends are not positioning correctly

I have two excel pie charts and a line graph next to each other on a Dashboard. The pie charts look fine and are not touching the legends, yet they are disfigured in a way that the stings are lower ...
0
votes
1answer
36 views

VBA Validate input in the input box

I need an input box that will provide a value that is an enumerator. MSDN Does not mention validating the fields at all. Is there a way of doing that? Like in HTML5 the pattern in input tag? Here ...
0
votes
1answer
50 views

Mirror cells so that a change in either cell updates the other

I have 2 cells containing the same picklist values on separate sheets. I want the cells to mirror each other so that whenever I choose a new value in either sheet 1 or sheet 2, the value on the other ...
1
vote
0answers
32 views

Link Microsoft Excel to Word document

I need to link certain numbers in my word document to an excel file that I have. For example, the Revenue for FY2014 is "20,000". I would like the 20,000 to be linked to a certain cell in an excel ...
1
vote
1answer
26 views

view files recently restored from recycle bin

I had an unsaved .xlsx file and after opening Microsoft Excel, I suddenly chose No to the recover suggestion of Microsoft Excel. I think the name of that file was my_file_name (version 1).xlsx Then ...
0
votes
2answers
44 views

How to add up hours

I have a spreadsheet to track my hours at work and I was wondering how I would go about adding up my total hours. I'm not fussed what format it be in, whether it be HH:MM or as a decimal. ...
0
votes
1answer
36 views

Understanding SumIF and Subtotal combinations

I've come across this solution to combining sumif and subtotal formula but I don't understand it.. Combining SUMIF() and SUBTOTAL() for Dynamic Subtotal Could anyone please offer an explanation of ...
0
votes
1answer
18 views

Copying data using VLOOKUP error

I'm having problem with the formula I'm using in Excel. Since I can't add images here, here's a link: Here's the link to the sheet, where Sheet 1 is the source data: ...
1
vote
1answer
34 views

Excel add maths keyboard shortcuts

How can I get excel 2013 to auto correct maths? For example change \int into ∫. I know how to do it for one symbol but is there any way to get excel to recognise all the maths auto corrects?