The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

9 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

9 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

**1**answer

10 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

**3**answers

29 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

**0**answers

19 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

21 views

### CF 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

24 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

22 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

**0**answers

5 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

43 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

8 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

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

**0**

votes

**1**answer

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

**-1**

votes

**0**answers

7 views

### Copied cells are not highlighted (blinking in the selection corner) [on hold]

In excel after copying. Cells are not highlighted (blinking in the selection corner).
Please give a solution to close.

**0**

votes

**2**answers

39 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

18 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

49 views

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

Is it possible for the numbering in column A to 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 ...

**0**

votes

**1**answer

31 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

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

**0**

votes

**0**answers

10 views

### Excel error message “An invalid value was used while saving to WK1 format”

I have a cell that evaluates just fine, but it comes with the warning that "An invalid value was used while saving to WK1 format". When I google this, I get basically no results. I find this very ...

**0**

votes

**1**answer

31 views

### How to convert a column of dates as text to Excel dates

I am working on a spreadsheet and imported external information with a date format of yyyy mm dd. I understand excel recognizes this as text as it's left aligned, however I need to convert this into ...

**0**

votes

**1**answer

25 views

### Create multiple rows based on repeated columns

I have a csv (technically, an Excel spreadsheet) that has rows/columns like this:
AC-10 ECLO-1 ECLO-2
AC-11 PESL-1
AC-13 ABCD-2 ABDE-3 AGTU-5
What I'd like to do is create two columns so ...

**0**

votes

**1**answer

35 views

### How to fill down formula so that range references are offset by 5 rows rather than by 1 row

How can I get Excel to increment ranges arguments by more than one row when I fill down a formula?
For example, if I want Excel to keep averaging the next five numbers in a column, how do I set the ...

**0**

votes

**2**answers

20 views

### Excel Highlighting First Empty Cell Below An Entry

I've been trying for hours what I thought would be simple but clearly is not for me!
I have a column where every ten cells has the word "TRUE" in it, the rest of the cells in between are empty. So it ...

**0**

votes

**2**answers

25 views

### VBA code to select certain worksheets in Excel and save as new workbook?

Is it possible to use VBA in order to select certain worksheets in an Excel workbook and save as new workbook file?

**0**

votes

**0**answers

15 views

### Excel concatenate returning #VALUE [closed]

Returning #VALUE!
This says "a value used in the formula is of the wrong data type"
=CONCATENATE("TVD_000",O8)
Cell O8 has a number in it. I have formatted it general.
Retyping the number, now that ...

**0**

votes

**3**answers

36 views

### How can I merge 2 sheets in excel?

I have to update a defect database in excel that is filled with data that fluctuates between 160 to 700 rows every day. This database has 19 columns, some of which are numerical and some are ...

**0**

votes

**3**answers

20 views

### Create custom parts for the header and footer in Excel

I have a spreadsheet with several worksheets. On each printed page of each worksheet I would like to have references to some fields that i define somewhere in the document.
More specifically, i would ...

**-2**

votes

**0**answers

8 views

### Compare and copy in Excel 2010 [on hold]

I have a 7 columns of the same length containing account balances for 7 months. I want to compare each row to see which account balances are the same across the 7 months. Once the comparison is done, ...

**0**

votes

**0**answers

12 views

### Horizontal/Column filtering in Excel? Should be simple

In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value ...

**0**

votes

**1**answer

19 views

### How can I return corresponding value from Master List by comparing Child List?

I have 3 columns MasterList, Value and ChildList. Now I want to compare Childlist against Masterlist and get the value from corresponding MasterList.
I have below values in worksheet.
MasterList ...

**0**

votes

**0**answers

8 views

### Microsoft Excel 2010, Adding/deleting lines in linked workbooks by only adding/deleting them in the Master Workbook.

I have Multiple Woorkbooks linked to one Master Workbook. Each WB has 13 columns and 452 rows(Different Products I sell). Only one column(My Selling Price) is linked to the Master as of right now. ...

**0**

votes

**1**answer

23 views

### Convert Array to String with Excel Formula, is it possible?

Convert Array to String with Excel Formula, is it possible?
I know how this would be done with VBA, but I have to share my workbook, and I have to assume that other people will not be able to enable ...

**0**

votes

**1**answer

24 views

### How to use SUMIF to calculate 12-month moving averages

On a single sheet I have Datapoints listed from top to bottom (A:A) and months from left to right (C:AI). In Column B I have an indicator which is used with SUMIF to 'group' certain data points.
...

**0**

votes

**2**answers

29 views

### Find most frequently used value

I know that that question has been asked before but my question needs more scalable solution!
I have a column G with States, there are 10,000 States in that column.
I need to find out what is most ...

**0**

votes

**1**answer

11 views

### Excel max values across many worksheets

I have multiple worksheets each with 4 columns of 32 names and values. I need to be able to find the highest 8 values(with associated names) from across all sheets. I have been able to determine the ...

**1**

vote

**1**answer

15 views

### How can I link value of a cell from another sheet according to the text which is already in the another sheet?

I am exporting a report from Quickbooks to Excel in a existing excel workbook. In that workbook a table is already created. I am exporting the report to a new sheet in the same workbook.
Now I need ...

**0**

votes

**2**answers

31 views

### Excel: Do not open files in multiple instances

How do I open all excel files in the same instance/window by default (happens only when I open from the menu, but not from the windows explorer)?
I have this option unchecked, but is still not ...

**0**

votes

**1**answer

34 views

### How to disable specific Excel 2010 add-ins at startup?

I want to disable specific add-ins from loading in Excel 2010 every time I open up a new workbook or instance. How do I achieve this?
When I disable the specific add-ins by unchecking them in the ...

**0**

votes

**0**answers

15 views

### Continue from one excel sheet to other without merging them together

i have an Excel workbook whic contain monthly sheets of sales. Each monthly sheet contains sale figures for various items (in columns) on a daily basis. the days are grouped in weeks.
Now i want to ...

**0**

votes

**1**answer

48 views

### Compare Excel Columns A & B and return C

I am a High School Principal and I need help figuring out how to use excel to create a class tracer for my students. A tracer is a spreadsheet that tells you what classroom a student is in during a ...

**0**

votes

**1**answer

21 views

### LO Calc / Excel - Dropbox change another cell

I am creating a simple Point of Sale System for a store using an excel/libre office spreadsheet.
The spreadsheet has a sheet called "Inventory" which has the following columns:
Name
Price
This ...

**0**

votes

**0**answers

8 views

### Can I use a GUI to import seperate sheets into another workbook?

I am trying to export a single sheet from three seperate excel workbooks to three seperate sheets in one master workbook. I then have to print this master workbook to a pdf, then repeat with three ...

**1**

vote

**2**answers

39 views

### How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date).
The chart is printed or worked on at ...

**-1**

votes

**0**answers

20 views

### How do I make XML Excel files to be opened by Excel by default?

I would like to have Excel files with the extension .XML on the Excel 2003 XML format to be opened by Excel by default. The rest of XML files should be opened by a regular text editor.
My files do ...

**0**

votes

**0**answers

29 views

### How to enable macros by hard coding using VBA

I have an attendance tool in MS Excel which is built by having macros.
Now the task is to enable macros in customers system by hard coding in the same tool itself when they using this tool for the ...

**0**

votes

**0**answers

37 views

### Copy rows from one Excel workbook/worksheet to auto-populate another workbook/worksheet based on text and date criteria?

I have two Excel 2010 workbooks with one worksheet in each (A/"2014" and B/"Allo 2014").
I need to have Excel find each row in worksheet "2014" where U2:U253 equals 'Allo' and AI2:AI253 equals ...

**2**

votes

**2**answers

22 views

### How do I drag formula in Excel

I need help with with Excel on trying to drag the formula down without having to copy and paste all the time
Example:
Column A
Row1 =(A1/A2)*100
Row2 =(A3/A4)*100
Row3 =(A5/A6)*100
...

**0**

votes

**1**answer

7 views

### Prevent Excel from scrolling all the way to the right when adding filters to column headers?

Whenever I add filters to all column headers in Excel 2010 and I have enough data to have to scroll horizontally, it jumps me all the way to the rightmost column. Whatever cell I had selected is still ...