The 2010 version of Microsoft's spreadsheet application.

**1**

vote

**3**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

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

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

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

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

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

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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