**0**

votes

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

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

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

**3**answers

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

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

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

**0**answers

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

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

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

**1**answer

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

**1**answer

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

**0**answers

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

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

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

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

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

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

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

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

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

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

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

**1**answer

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

**0**answers

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

**0**answers

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

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

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