The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

4 views

### Find max with duplicates XL2010

I have a table and need to find the max in each row, I want it to bring in the header, but there are duplicates, E.G. COLUMNS A-D, columns A and B have 2 and C 3, D 1. I want it to say A, B. Can ...

**1**

vote

**1**answer

51 views

### Flip x and y axes in Excel graph

This should not be very difficult, but I cannot figure out how to do it.
I have a table similar to this
%low %high
0 0 12
1 13 26
...
19 90 94
20 95 100
When I graph it, excel ...

**0**

votes

**0**answers

34 views

### direction does to RTL in Excel when I add sheet

When I add a new worksheet to my workbook in Excel 2010 (by clicking the button insert worksheet next to sheet names), one sheet will be added and the direction goes to RTL from LTR automatically and ...

**0**

votes

**0**answers

20 views

### Why Powerpoint 10 is not opening a file from network?

I upgraded my power-point from 2007 to 2010 recently. Upgraded version is working fine with all the files inside my laptop. But when I tried to open a file from a shared location it fails with a error ...

**1**

vote

**1**answer

74 views

### Use data from a drop down list to populate table

I am trying to make an employee recognition tracking tool. I would like to have in sheet 1 a drop down list of all the employees in the hotel and a drop down list of the month.
When an employee ...

**-1**

votes

**2**answers

63 views

### Excel: Complete row Hash Value calculated as a Numeric value in a cell on same row

I have to manage "Change Control" on Excel spreadsheets comprised of 1000's of rows and dozens of columns.
Downstream Teams often submit revised columns that I have to incorporate into a master ...

**0**

votes

**1**answer

21 views

### Can Excel 2010 Cell Formula Reference Another Cell For A Portion Of The First Formula?

Perhaps this is not doable, but all I can do is ask.
I am using MS Excel 2010. I am going to greatly simplify the issue.
I have a column of many, many cells that all contain the same, very large, IF ...

**0**

votes

**4**answers

54 views

### Excel - How to add cells that have letters and numbers

For example:
A1 - "AA123"
How do I get B1 to read "AA124" and C1 to read "AA125"?
I know that in A1 I can drag the box to the right and it will populate with this, but I need a formula for this. ...

**-1**

votes

**2**answers

20 views

### How to remove some duplicates in Excel

I want to remove all but the topmost value of duplicates in Excel. For example,
I have this:
A B C
R123 5 35
R123 5 14
R123 5 27
R345 89 19
R345 89 42
But I want ...

**-1**

votes

**1**answer

46 views

### Closest thing to variable in Excel formulas( not VBA)

I have following formula
=MID(G34,FIND(" ",G34),FIND(" ",G34,FIND(" ",G34)+1)-FIND(" ",G34))
G34 ="begining middle end"
The goal of this formula is to return "middle" and it achieves it, but the ...

**-3**

votes

**2**answers

40 views

### how can i make an excel graph of this data (two)

Mean ± SD baseline Mean ± SD Final
56.7 ± 6
84 ± 14 82 ± 13
34 ± 5 33 ± 4.5
42.79 ± 3.19 40.45 ± 3.48
46.75 ± 9.64 ...

**0**

votes

**2**answers

50 views

### How to calculate with Microsoft Excel the correct amount of minutes?

64 people receive services 105 minutes per day. How can i use Excel to calculate the total minutes of service per day and then multiply by 7, so i have the total amount of minutes per week, and then ...

**0**

votes

**3**answers

49 views

### group values in set of 5 and then return the first value from each group

I have a long list of values of a stock in minute format. The column C shows the open values(per minute) and column F shows the corresponding close values
Now I want to covert this data into 5 min ...

**-1**

votes

**1**answer

72 views

### Excel conditional formatting based on time values

Hi i need to create an Excel template like the cells will be loaded with a timestamp like
2014-09-29 16:02:59.112213
I need to provide a condition like, if the timestamp is less than 3 AM, its ...

**0**

votes

**2**answers

64 views

### Is there a way to use Regex( or comparable solution) in Excel formulas?

I have a spreadshet that requires me to do some matching,namely speaking its a list of bonds, their tickers(names) and some data about them. I want to match their tickers(names), I know how would ...

**0**

votes

**1**answer

34 views

### Adjust sequence position of barcode scanning result

I've been improve our warehouse record method by barcode scanning.
But the problem defaut scanning result inside excel format is after scan cursor will move to below cell ( ex : A1 to A2 to A3 etc).
...

**-1**

votes

**2**answers

37 views

### larget/smallest number in a range in excel without overlap

I have a sheet with 1000 rows and 5 columns.
1) What I want to do is in a cloumn find the biggest number in 5 adjacent row (e.g. row 1-5 in column A). then find the biggest number in next 5 rows (i.e. ...

**-1**

votes

**1**answer

29 views

### Microsoft Excel 2010 Search for Specific Text and copy it to new cell

I have a list of single words in a column A1:A10.
In row A11:G11 I have words which could include a word from the list. If it does it could be the only word or appear together with another word in ...

**0**

votes

**0**answers

29 views

### I need a macro to separate a column of names into 4 different shifts

Our system creates a report for accuracy. Our manager wants it separated by shifts. From those lists, it will go to a report 'by shift' along with the information on the row with each.
I need a macro ...

**0**

votes

**0**answers

41 views

### Calculated Field in Pivot Table - Reference Previous Value

I am trying to summarize data within a pivot table that was formerly calculated in excel. The format is much nicer and I believe it can be done, I just need some help.
Overview of data:
I have ...

**1**

vote

**1**answer

379 views

### Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010

I have two data sets each containing 10 coloumns of data.
X values in data set 1 go from 380 - 750 in steps of 5
X values in data set 2 go from 250 - 2500 in steps of 1
Data set 1 is permanent and ...

**1**

vote

**3**answers

113 views

### Can you change linked charts to embedded charts in PowerPoint 2010? Or use relative links to Excel files?

I need to replicate a PowerPoint presentation across multiple countries then send the presentations to colleagues and give them the ability to edit charts.
To do this I have created an Excel file ...

**-1**

votes

**1**answer

214 views

### Excel 2010 VBA or formula to find value in dynamic column based off entry (vlookup like) but copy the value and paste the value into the cell

My question is rather complex so I will try to use examples and be clear as possible. In one table I have values that are populated based off formula:
Name Timestamp Datedif1
123 1-Oct 1 ...

**-2**

votes

**1**answer

103 views

### Excel, using cell text references as input for formula

First of all thanks for your help. I have a problem regarding the use of text into formulas. I am working on a huge dataset of stocks of several years. The stock are not correctly grouped. I used an ...

**0**

votes

**1**answer

32 views

### Massive number of obsolete defined names in Excel = huge file

At my current job I discovered that many Excel files were unnecessarily large, a file with a single worksheet and simple table can be more than 2 MB and Excel seems to be very sluggish at times. After ...

**-1**

votes

**2**answers

38 views

### Excel. Sumif with special specific ifs

I would like to understand how to do the following sumif;
I have three pages
Page 1 & 2 has same layout
Page 1 has column range A with specific numbers, and column range 2 with sums of other ...

**-1**

votes

**1**answer

28 views

### How to specify a month in cell A1 and have all the dates that fall in that month appear automatically in row B?

I have a question about Excel. I am using Excel 2010 and I want to be able to create a table that will auto populate the dates within the month that is specified in cell eg A1 into a row in B for ...

**0**

votes

**1**answer

119 views

### Converting a mmm-yy date in string format to date format

I have an excel document that lists dates in mmm-yy format as a string (they've been copied in from a pdf). I need to be able to determine the number of days between these dates, however excel ...

**1**

vote

**1**answer

28 views

### Find all Excel files linked

I have an Excel file that is the source of data for several other Excel files (they are linked to this one). Is there a way to find a list of all of those files?
To explain another way, this post ...

**0**

votes

**1**answer

59 views

### Align header with cells whose text is oriented at an angle

Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle?
This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" ...

**1**

vote

**1**answer

32 views

### How to efficiently reference an entire row in Excel?

I am working on a budget spreadsheet in which I have to pull in cell data from another external spreadsheet. I have to do this for several different sheets with massive amounts of data in the sheets, ...

**1**

vote

**1**answer

21 views

### Duplicate detection in two excel colums

I have two columns of data in Excel 2010. One column has about 5,000 cells and the other has usually has 20-30. I need to be able to compare the two columns and output to a third if there is a ...

**0**

votes

**1**answer

18 views

### How do I copy multiple lines of content from the web to one cell in excel?

I am trying to copy multiple lines of content from a website to a single cell in excel. For some reason when I paste the information into excel it locates the first line in the cell I want and the ...

**-1**

votes

**2**answers

33 views

### Excel create reference to whole column throught a formula

I have a spreadsheet where I need a reference to a whole column, catch is that I don't know which column ahead of the time, so I use MATCH function to find that out. Once I find the right column I ...

**0**

votes

**0**answers

164 views

### vba excel macro runtime error 1004

Dim lastC As Long
lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug
SourceRange.Copy
wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...

**0**

votes

**2**answers

69 views

### How to eliminate the space after a line chart in Excel 2010

I have problems to get rid of this space (the one marked in blue in my Excel 2010 line chart.
I noticed that it appears only if the line chart has more than one series.
Any suggestion?

**0**

votes

**1**answer

27 views

### Unable to expand cells in Microsoft Excel

I have an odd issue that I need your help with.
Within my spreadsheet there are many cells that although contain data, do not respond when I try to automatically resize them.
I've tried auto-fit, ...

**0**

votes

**2**answers

34 views

### How to use different formula in case of en error?

I want to run the following formulas on a cell, in this order,
in case the previous formula returns an error.
=MID(P2,SEARCH("q=",P2)+2,SEARCH("&",P2)-SEARCH("q=",P2)-2)
...

**0**

votes

**1**answer

23 views

### Excel: How to strip search terms from a cell (referring URL)

I have cells that contain a referring URL of visitors who entered my websites.
this URL always has a different lenght, but it's constant format is such that the search term always shows up between p= ...

**0**

votes

**1**answer

24 views

### Can we set Excel to append cell text on key press instead to delete the current text?

I am using Excel a lot for accounting. It happens a lot of time that I calculate multiple values into the same cell. So my cell may look like =12+345+23+88.
Now, the default Excel behavior is to ...

**0**

votes

**1**answer

17 views

### Cell colours depending on value

I have a column of cells where each cell contains one of the following text values
Optimal
Normal
High-Normal
Mild
Moderate
Severe
I would like the cell colour to be a set depending on what the ...

**1**

vote

**1**answer

12 views

### Why does ADDRESS function return an error across different worksheets?

When I try to count cells that match my criteria using the address function, I get mixed results depending on which sheet the formula is nested.
For example, if I use the following to count the ...

**0**

votes

**1**answer

25 views

### Page Break lines won't stay off for a shared Excel document

I have a shared Excel document on my NAS, and in Excel I go to options and disable Page Break lines.
However, when someone else opens the document, the page breaks reappear. When I reopen the ...

**0**

votes

**1**answer

27 views

### Excel Values Require Enter within Cell to recognize as number

I have a worksheet where I am getting direct output from STATA that has a weird character format that included " =[ number ]". I put in a new column to strip the characters and leave the numbers. ...

**2**

votes

**2**answers

35 views

### How to find the last value in a column in excel?

I am tracking rooms booked in a hotel on a daily basis in Excel. Every day I input the number of rooms booked in a column to show a trend of pick up over a period. I'd like to return the value of ...

**0**

votes

**3**answers

400 views

### Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.
I have a spreadsheet, exported from our exchange server, that contains a column ...

**0**

votes

**1**answer

29 views

### Count Row and Column in Pivot Table

Hi I have a sheet that collects the following
++++++++++++++++++++++++++++++++++++++++++++++++++++
+ Name + Address + Borough + Postcode + Date Added +
...

**0**

votes

**1**answer

339 views

### VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...

**2**

votes

**1**answer

64 views

### How to apply conditional formatting only to cells that contain a subtotal formula

I have a list of values, I have to alternate color of each row (that works fine).
In that list I also have subtotals, calculated using the SUBTOTAL function.
How would I be able to give just the ...

**-1**

votes

**1**answer

330 views

### Break the forgotten encrypted password of excel workbook

i have an Excel 2010 workbook, on which i applied an Encrypted (128 bits AES) password, which i can't remember now, is there any way to remove/reset or retrieve that password or any method to retrieve ...