The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
4answers
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
2answers
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
1answer
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
2answers
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
2answers
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
3answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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 ...