The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

6 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

14 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

26 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

11 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

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

**0**

votes

**1**answer

10 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)

**-2**

votes

**0**answers

20 views

### Excel Search, Copy, Paste

I have an Excel spreadsheet with just two columns.
I would like to create a Macro that would allow me to use a barcode scanner to search for a number in one column and then copy all of the ...

**0**

votes

**1**answer

13 views

### Excel If Statement Override and Sum

Here is what I have:
=IF(SUM(J19:J29)=Quote!J55,Quote!J55, "ERROR")
The sum of the rows must equal the total in a cell of another sheet or it reads ERROR.
Then I have Alternative totals that can ...

**0**

votes

**0**answers

19 views

### excel 2010 formula for counting formulas in a column (or row) [on hold]

I have a huge file containing many worksheet, each of which contains hundreds of rows and columns. Most of the cells contain formulas. In order to be able to check if the result is reliable, I need a ...

**0**

votes

**0**answers

9 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

**0**answers

18 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

15 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

22 views

### macros for multiple queries [on hold]

I'm engaged with a project. I have a worksheet with table incorporated to it. The table starts from columnb "B" while the column "A" is just the sheet column. now the queries what i have here is
...

**0**

votes

**1**answer

16 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

20 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

28 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

13 views

### Excel: Colour formatting has ceased to work

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

30 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

28 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

19 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

26 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

14 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

16 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

10 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

17 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

20 views

### excel formula required to clear many specified cells in different sheets on the same workbook - [on hold]

i.e. on sheet 1 I want to instruct many different specific cells in other sheets in same workbook to clear text - so as i can rewrite into these cleared cells at a later time therefore cannot have ...

**0**

votes

**0**answers

5 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

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

**-1**

votes

**0**answers

21 views

### Excel 2010 macro that will search for multiple values in a very large worksheet, and then copy full rows into a new sheet when value is found? [on hold]

I'm new here, so forgive me for the length and any rookie questions.
I have a very large worksheet, about 100k lines, filled A-AD.
Row 1 is header (I will need this in the new sheet, but can easily ...

**0**

votes

**1**answer

20 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

39 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

78 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

**0**answers

17 views

### Get information from one worksheet and move it to another worksheet [on hold]

Basically, I could do this manually, but I have a lot of information and it would take me a lot of time. I am trying to find the right formula.
I have 8 worksheets in Excel.
Details
Date ...

**0**

votes

**1**answer

25 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

17 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

33 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

19 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

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

**-1**

votes

**0**answers

24 views

### Can a cell reference be used to automatically update a VLOOKUP formula?

I have the following formula:
=VLOOKUP(R3;'\\RZ01TB01\team$\COMPANY\C754Ideal_DOO\Logistic\2014\MPS\ABC\[ABC Weekly - wk 42.xlsx]Calculation FAP'!$B:$V;7;0)
It works fine, but I want to ...

**0**

votes

**1**answer

15 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

14 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

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

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

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