The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
3 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
0answers
13 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
1answer
12 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
1answer
20 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
1answer
14 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
0answers
15 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
2answers
17 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
1answer
23 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
0answers
12 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
2answers
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
2answers
26 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
0answers
17 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
1answer
25 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
1answer
12 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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
20 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
1answer
18 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
1answer
34 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
2answers
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
3answers
70 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
0answers
15 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
1answer
23 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
1answer
14 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
2answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
13 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
1answer
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
3answers
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
3answers
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
1answer
16 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
0answers
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
0answers
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
1answer
43 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
0answers
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 ...
0
votes
2answers
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
1answer
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
0answers
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
1answer
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 ...