The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
3answers
124 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
1answer
31 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
25 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
37 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
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
0answers
41 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
1answer
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
0answers
17 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
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
3answers
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
3answers
64 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
20 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
19 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
61 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
46 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
55 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
31 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
0answers
12 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
27 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
1answer
25 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 ...
6
votes
2answers
94 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 ...
0
votes
0answers
62 views

Trying to get VLOOKUP to get data from a table array on another workbook where the worksheet name is variable

I currently pull data in from 4 workbooks using the INDIRECT function, the formula is as follows, =INDIRECT("'[" & $AE$1 & "]" & $AA$13 &"'!" & $AI$1) $AE$1 contains the workbook ...
-1
votes
2answers
38 views

Is there a way i can copy this macro i made but have it change for the next tickbox

I have made this macro to Select cell A3 copy the value and paste it into cell Y3. it then clears cell A3 as that's a dropdown box, by doing this the dropdown option can be now selected in A4. ...
0
votes
1answer
37 views

I need to check a column for specific text and if found run a formula elsewhere

In column B I have a name, (John, Jane, etc,) in column C I have text (orange, blue, etc.) I would like to check column B for a certain name and finding that name I need to run a COUNTIF formula for ...
1
vote
1answer
28 views

can someone help me with my Formula Excel need it show blank

=IF(NOW()-B4>=15,"OK","Warning - Time to Renew") that is the formula, but can it stay Blank until a date is put into cell B4 thanks
0
votes
3answers
28 views

How to record in adjacent cell what my drop down selection was, as a Hard Record formula? plz

is there a excel function coding which can record in an adjacent cell what my drop down selection was From cell A3, into Cell B3, but to keep this even if i remove the drop down selection at a later ...
0
votes
0answers
31 views

Making DropDown list without repetition, Adding name back to List?

i use this method to help me with my own Excel data for Car Hire. its working great user can select one car and until its deleted from the first field the next user can select. is it possible that the ...
0
votes
1answer
19 views

Prevent Copying from a Range of Cells

I want to protect a range of cells in Excel, that I don't want another user to copy text from. Is it possible? I did have a look at this other question: Locking cell range in Excel, but doesn't ...
0
votes
2answers
20 views

Does a range of cells contain a value in a list?

I want to answer - does a range of cells (A1:E1) contain any value from a list (G1:G50) In other words: Does A1 OR B1 OR C1 OR D1 OR E1 contain any value that appears in G1:G50?
0
votes
0answers
44 views

Change value color in a specific column/row/cell if not equal to another specific column/row/cell

I have column A and column B. Column B's rows contain one of the values A, B, C, or D. The user needs input in column A any change to the value in column B. If there is no change, or the value is the ...
0
votes
2answers
19 views

Excel 2010 Custom Formula / Conditional Formatting to highlight data that is greater than Twice the Value of Original Cell

I am trying to figure out how to indicate cells that are greater than twice the value when compared to a specific cell. For example, a value of .1 compared to .18 would be OK but .1 compared to .2 ...
1
vote
2answers
68 views

Convert Text Value to Time Value in excel

I am trying to convert text to time. Basically I copy and pasted the total time of employees but it pastes as text value and then in order to add the time I have to convert it to time and I have to ...
0
votes
1answer
44 views

Need a way to have excel show items I have used already from drop down list

This is my first time asking. I have an excel sheet, new to excel but love to learn. I worked out how to make drop down lists and I have a list of cars that are being used. The user in sheet 1 ...
0
votes
1answer
41 views

Index/Sumproduct calculation error

I have been working on an excel problem for the better part of 24 hours. I have a formula that almost does what I want but it is not returning what I imagine it should return: ...
0
votes
1answer
85 views

Conditional Formatting Cells with Different Values for Rows with the Same Value in Specific Column

I need to conditionally format cells with different values between the same columns, if their value for a specific column is the same. Scenario My spreadsheet is a contacts database, where each row ...
0
votes
1answer
47 views

How to combine two columns with no data loss for further analysis

Hopefully you good people can help me as I'm pulling my hair out doing this manually and can see no way to automate At present I have two sets of data consisting of three columns each - Date, Amount ...
0
votes
2answers
26 views

Sorting in Excel

I have entries in Excel that are like this: 52173 PURCHASE USA*SNACK SODA 52172 PURCHASE USA*SNACK SODA 668414 PURCHASE REDBOX *DVDRESERVATION I would like to sort the rows ignoring everything ...
0
votes
2answers
33 views

How can I create a list in Sheet1 made up of selections on Sheet2 in Excel?

I am trying to create a quote form that will print only the selections of interest to my prospect. I want to list all available options (list of my services) in Sheet2 and make my selections (for ...
-2
votes
1answer
49 views

Sum values within a time frame

I have 550 rows of data that represent daily flight times. Each flight, depending on aircraft type, requires a certain number of people to attend the flight. That task takes 45 minutes. So at any ...
0
votes
0answers
15 views

Excel quadratic trendline formula wrong?

I made a scatter plot graph on Excel, however the trend line formula does not replicate the values shown. Currently I have have this file here. Why is the formula not replicating properly and how do I ...
-1
votes
1answer
18 views

How do I reference a specific row number using a defined column name?

I'm using Excel 2010 and am creating a workbook to define details about products in a store (including category, price, accessories). I also want to define default details to use if the specific ...
0
votes
2answers
23 views

Multiple data tables in excel

I'm having problems building a data table off values that come from another data table. For example, with a black-scholes option pricing model, I first get the value of options at different strikes ...
1
vote
1answer
31 views

Excel 2010 PowerPivot: How do I avoid apostrophes being displayed as ’?

When I import a text file to PowerPivot containing apostrophes, they are automatically converted to ’. I've been manually correcting the few that I find in the PowerPivot window, however when I do ...
0
votes
3answers
53 views

Excel last appearance of a given string in a column

I am using the LOOKUP function to find the last appearance of a given string in a provided column, like this: LOOKUP(A3;Runs!D3:D6;Runs!A3:A6) However, the bounds in the vector are hard-coded: ...
1
vote
0answers
27 views

How to find and replace lines in one file that match the pattern of lines in another file

I have a scenario with two documents. The first doc has lines of text, and the second doc also has same text with different text before and after this text. They need to be replaced. Doc 1 ...
0
votes
1answer
91 views

Auto Sequential numbering based on cell criteria - create two independent automatic numbering sequences

How to make the numbering in column A skip any rows that have the Word "TOTAL" in column C but pick right up again in the next rows? At the same time can the rows with the word "TOTAL" in column C ...
0
votes
1answer
39 views

How can I list data and create a summary table?

Let's assume I have a table with sports results somehow like this: player A | player B | 2 | 1 | player C | player D player C | player B | 1 | 2 | player E | player A As shown in table, there are ...
1
vote
0answers
10 views

Windows Xperia excel 2010

I have 50 work books each work book is for 1 subcontract operative. Also each operatives work book has 52 sheets one for each week. I need to extract the same cell (£ payment total) to list the weekly ...