**0**

votes

**1**answer

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

**0**answers

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

**3**answers

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

**0**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**4**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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?