The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

9 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

14 views

### macros for multiple queries

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

12 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

14 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

15 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

20 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

11 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

26 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

24 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

16 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

23 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

10 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

13 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

15 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

9 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

19 views

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

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

11 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

19 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

16 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

33 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 [on hold]

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

66 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

15 views

### Get information from one worksheet and move it to another worksheet

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

22 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

12 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

15 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

32 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

11 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

30 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

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

**1**answer

15 views

### Excel datetime plot

I have a data set which is nothing more than series of datetimes.
Ex:
X-axis| | Y-axis
11/10/2014 8:56 | 1
11/10/2014 9:01 | 1
11/10/2014 9:04 | 1
11/10/2014 9:15 | 1
I have 5 sets of ...

**0**

votes

**0**answers

18 views

### Windows 7 with MS office 2010. Excel issue

Excel
Referencing text from another sheet (not another book).
Have a 'summary' sheet and want to reference text from other sheets.renamed '1' to '40' and have a real problem getting it to work. I'm ...

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

**0**

votes

**1**answer

41 views

### Auto sequential numbering based on cell criteria with two numbering sequences and ability to ignore duplicates

In the example below the numbering in column A skips rows that have the word "TOTAL" in column C but picks right up again in the next rows. The rows with the word "TOTAL" in column C have their own ...

**0**

votes

**0**answers

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

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

**0**

votes

**0**answers

10 views

### Is there any formula to return multiple values from duplcate entries

I have a data in the form as shown below
Client Master Days
AD1P server1 1917
BIAP server1 0
BMCP server1 1917
BMWP server1 2112
CHOP server1 1903
AD1P Server2 0
BIAP Server3 ...

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

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

**5**

votes

**2**answers

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