The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

38 views

### Identify in what of the given ranges is a random number

I have this table with the first column being just an Identifier Code and the second one being the ranges.
So for example if a number is between 0 and 1134, it corresponds to the first row ...

**0**

votes

**1**answer

26 views

### Excel logic AND and OR functions

Does my formula below need to read (Occupancy=1)*(Gender=2) to consider the occupancy for both genders?
=(MIN(IF((Occupancy=1)*(Gender=1)+(Gender=2),Gross_Rev)))
I guess as a general question, ...

**0**

votes

**0**answers

15 views

### Excel 2010 “lastcell” issue with formula in complete column

I'm currently using a formula throughout a column in an Excel 2010 worksheet. It works fine, but I'm not really using the entire worksheet, I only don't want to have to worry about adding the formula ...

**1**

vote

**1**answer

13 views

### Easy way to calculate total height of rows having different row heights

I have a worksheet (Excel 2010) in which I want to delete 14 rows having different row heights, but after deleting I want to increase one row by the total height of the 14 deleted rows so that all my ...

**0**

votes

**2**answers

34 views

### Make Excel marks the repeated rows with a lot of data in each row

I have this Excel archive with 5 columns of data, and then, about 4,000 rows of different data for each column, but I can’t find a way to make that Excel marks the repeated rows?
I have tried using ...

**0**

votes

**0**answers

19 views

### excel chart data labels failing to apply to all series

if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps ...

**0**

votes

**1**answer

5 views

### Automatically Copy numeric values from different column which has numeric cells & alphabetic cells

I have a column (Suppose Column B) in which some numeric data cell & also some cells which contains alphabets only, and I want to copy only numeric data in a different column (Suppose Column C).
...

**0**

votes

**1**answer

10 views

### Specific sequential numbering in excel 2010

I need to create a spreadsheet with the following sequential numbering "0001/2014", I can create the number in reverse "2014/0001" but that is not what I want. Any suggestions would be most ...

**0**

votes

**1**answer

18 views

### Can I filter out all rows corresponding to reference list in excel

I have a list of IDs that I would like to select in a excel sheet. I am used to using the filter function to search for 1 ID, but now I would like to filter out all the rows with that match the ID in ...

**0**

votes

**1**answer

20 views

### Excel formula - Return value from lower row

I'm looking for a way to search for a value in a single column and return a value in that same column two below it. Example:
A1: Apples
A2: Bananas
A3: Oranges
A4: Pears
If I search for ...

**0**

votes

**3**answers

40 views

### How do I get the fiscal year to start on a specific date each year in Excel?

I used the formula listed here to generate a fiscal year based on the current month. I have an odd requirement where she wants the fiscal year to start on 6/20. For example, any dates ranging from ...

**0**

votes

**2**answers

17 views

### How to get Excel to show username of person that has file open?

When our admin staff try to open an Excel document on a shared network drive that someone already has open, they get the following message. The name shown (under the red box in the snapshot) is not ...

**0**

votes

**3**answers

30 views

### Excel Averageifs with multiple conditions in one column

I am looking for some help for how to tidy the second formula below in bold. I am looking to calculate the average 'Pupil_Score' (this is also my first try with named ranges) based on race, I am ...

**1**

vote

**1**answer

14 views

### Search for a string in the whole Excel Workbook

How can I find all the occurences of a sequence of characters in the whole Excel workbook ? (Excel search is limited to the current sheet only)

**0**

votes

**0**answers

16 views

### Rows order lost just right after refresh all (data connection - SharePoint)

I got an excel workbook with a data connection to a sharepoint list... everytime just right after a refresh all, the row order dies in some columns. Those columns are "manual columns", the data is ...

**0**

votes

**1**answer

35 views

### How to add markers to all series in an excel line chart in one go?

I have about 15 series in my chart and do not wish to manually select and edit each one individually to give it a distinct marker
Is there a way to do this for all lines in one go?
I don't care if ...

**0**

votes

**1**answer

16 views

### Excel 2010 - Averaging columns data by different columns

My data includes several repeated measures (~4-5) for each participant and i want to be able to average all specific measures for each participant.
for example, in the screenshot attached, i want to ...

**0**

votes

**1**answer

19 views

### Merge two files with fuzzy / inexact key column

I have two spreadsheets with different dimensions. They share a common column, but not all the names are 100% similar. Specifically, I'm merging two data files from counties around the US, one has ...

**0**

votes

**0**answers

16 views

### Scan employee badge to return date and time in another coulumn

Want to be able to scan badge and lookup to see if employee was already scanned if so enter the date and time into the next blank column for that particular employee. If employee was not already ...

**0**

votes

**2**answers

34 views

### Fatal error in excel “Errors where detected while saving filename”

I have some of excel files and I got an error while saving that says "Errors where detected while saving file name. Microsoft Excel may be able to save the file by removing or repairing some features. ...

**0**

votes

**1**answer

37 views

### excel macro to reset/refresh a table column having dropdown

A newbie to excel macro so kindly bear if my question looks stupid.
I have created a table (listobjects ) in worksheet having four columns. The fourth column is incorporated with drop downs through ...

**0**

votes

**0**answers

16 views

### Excel: Colour formatting has ceased to work [duplicate]

Excel: Colour formatting has ceased to work. No matter what I set the cell colour, text colour (manually or with conditional formatting) it remains in black & white. The same documents do work ...

**0**

votes

**2**answers

38 views

### how to check for a value in excel and populate column based on it

I have the following query :
My input table is
Basically I want to lookup columns for each ID.
Value3>Value2>Value1
If value3 and value column has data then ouput should show ID having value3
If ...

**2**

votes

**2**answers

31 views

### Return a value given that a number is within a certain range

I'm looking for a little help on my scheduled withdrawals problem. I currently solve this with nested IF functions, but I'm getting more and more ranges and that leads to more and more nested IF ...

**0**

votes

**0**answers

22 views

### Expored XLS file opens the first time, can't be subsequently opened, even if it first opened in ReadOnly mode?

I have an application that exports a lot of various sets of data to Excel. One of our exportation routines is generating a very-basic Excel file. Our users have sent in a ticket claiming that when ...

**1**

vote

**1**answer

30 views

### Excel VBA to add cumulative total to new sheet

I am trying to create a workbook that creates a new page and puts the cumulative total from two cells to add to the new totals entered on the new page. I've been able to create a new page, but can't ...

**0**

votes

**1**answer

16 views

### Network resources being called when no connections are configured

Some users were reporting awful performance in Excel 2010 when doing simple things like clicking a cell or changing sheets for many workbooks they use.
I made sure there were no dead connections ...

**0**

votes

**0**answers

15 views

### Why is links in an Excel workbook changing when one user opens the file?

I have multiple users on a company network that have access to the same Excel workbook. When one of the users opens the workbook, it changes the file path of a link in the formulas to a non-existent ...

**0**

votes

**1**answer

21 views

### Insert formula for each row in Excel or LibreOffice

I have the following data in LibreOffice:
As you can see there are 3 sets of measurement. I want to automatically feel in the D column with the following formula automatically. For example D2 will ...

**0**

votes

**1**answer

24 views

### Variable file name in cell reference as part of longer string using OneDrive

I want my spreadsheet to be easily replicated with each new year. I've already got an input section that allows me to enter the present year (for instance 2014 in A1), generate the prior year ...

**0**

votes

**0**answers

4 views

### Insert table from sheet A as an object in sheet B

In Excel2010, I want to insert a table from sheet A as an object in sheet B. As an object means if I click/double click on this Object table in sheet B, I should reach to source data in sheet A for ...

**0**

votes

**1**answer

22 views

### How to Lock or password protected specific cell in excel 2010

How can I Lock a specific cell in a sheet of excel 2010 so that any one can not change or input anything in that cell?

**0**

votes

**0**answers

12 views

### Formula to copy rows to a new worksheet based on a single value in a row

I need to extract complete rows from a spreadsheet to a new spreadsheet based on a specified value in the row. Cannot be advanced filtering since that only allows me to copy into same worksheet. Is ...

**0**

votes

**1**answer

14 views

### Indirect(Address(…'Name' issue

I have a range named 'select' which contains random numbers =ROUND(RAND()*8+0.5,0) - These represent 8 people. Elsewhere I use the following formula to randomly select from those random numbers.
...

**0**

votes

**1**answer

22 views

### Track the username and date in one sheet when the user is opened

I have written the below code in the VBA code sheet.
Private Sub Workbook_Open()
MsgBox ("Welcome to Tracker, " & Application.UserName)
End Sub
Result is " Welcome to Tracker, Sakaray, Kiran"
...

**0**

votes

**1**answer

49 views

### How to keep Excel line graph from incorporating dates that are not in my range

I have created a line graph based on dates and the values associated with those dates. However, it is inserting dates into a graph which I do not want. The dates run in chronological order, I only ...

**-1**

votes

**2**answers

41 views

### formula to work percentage [closed]

I am trying to find a formula that will perform a specific function.
I have two values, for example 15 and 50. 15 (b6) is the number of questions I have correct and 50 (c6) is the total number of ...

**1**

vote

**3**answers

120 views

### Excel formats a String to Date in a CSV file. How can I retain the original string value?

I'm encountering a problem in Microsoft Excel 2010 regarding auto-formatting a String into a Date, and it seems to lose the cell's original value.
Steps to reproduce:
1 Create the following CSV ...

**0**

votes

**1**answer

30 views

### Date formatting from a derived/computed column

I have a column(A) in excel with data like "20141024X000000". First part before x is a date.
In another column(B) I want to format the date to become like "14-Oct-24"
What I did was use this function ...

**0**

votes

**1**answer

24 views

### From a range of cells that display the alphanumeric result of a formula, use the highest numerical value only in another formula

I have a row, let's say row 12, where 6 cells (e12:j12) display text and numbers as a result of a formula e.g. one cell might say 'UNIT PRICE: 9.83', another 'DAY PRICE: 11.62', another 'NIGHT PRICE: ...

**2**

votes

**2**answers

35 views

### Excel formula to populate from one column only if another is empty?

I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not ...

**0**

votes

**0**answers

46 views

### Microsoft Excel Starter 2010

I have multiple columns/tables of data that I want to use in what I think would be an if/then formula BUT I have more than 2 options ie. I want to be able to type in a number (62111) and have it auto ...

**0**

votes

**0**answers

13 views

### How to change a number each time I open a document in excel

I am developing a purchase order document and I would like to have the Purchase Order Number associated with it to change each time I open it. I am very unfamiliar with VBA and functions so I may need ...

**1**

vote

**0**answers

21 views

### Creating a list from another list's value

How can I populate a cell with a list as a result of a condition from another dropdown list?
I have a dropdown list, when I select a value from it I will need to populate the cell beside it with ...

**1**

vote

**0**answers

38 views

### Text to copy cells with formatting into Excel

I am looking for a way to copy-paste text into Excel, which Excel will recognize as formatted (ie, styled or colored, etc) cells.
On the one hand, Excel recognizes tab-delimited text pasted from the ...

**0**

votes

**1**answer

18 views

### Refer to another worksheet that has increment in cell number

I have a worksheet (let me call it WorksheetA) that each row has a different information. Then, I want to refer this information per row on my other worksheet (WorksheetB).
To explain further, ...

**0**

votes

**0**answers

16 views

### PowerPivot install cannot activate add-in

I am having problems activating PowerPivot on my colleagues' computer. While I have been able to activate successfully, 3 of my colleagues are having problems even though our hardware and software ...

**0**

votes

**1**answer

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

**1**

vote

**3**answers

35 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

**3**answers

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