The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
13 views

Copy Table values from one sheet to another

On the first sheet of the spread sheet I have the following: 1 Item Item Description 2 xxxxxx yyyyyyyyyyyyyyyyy 3 4 Object 1 Object 2 Object 3 5 AAA ...
1
vote
1answer
15 views

How do I display the value of one cell in a cell on another sheet?

I would like to build a spread sheet with multiple sheets. The first sheet is the main 'working' page. The additional sheets would be filters of data found on the first sheet. On the first sheet on ...
0
votes
0answers
14 views

Merge two Excel files and only retain new data?

I manage a daily shipping report (an Excel file) that has many date fields (departure, arrival, etc.) that are populated automatically from our shipping system. In the last column of the report I add ...
0
votes
0answers
10 views

How do i get a cell to read multiple options for a seperate cell [on hold]

I am trying to get a cell to read another cell with different possible names in it and be able to reference the names to a separate items. Example: cell b5 has different items and cell c5 reads a ...
2
votes
2answers
17 views

Excel text to appear on screen but not print

I am creating a contract in excel and I do not want the line item pricing to appear when printed. Changing the font color to white is time consuming so not an option. Hiding the group of cells would ...
0
votes
1answer
22 views

Excel Office Pro 2010 SUMIF

Hi Im trying to SUMIF(range;"<>#N/A";range) but the cells im selecting to sum are not in a row adjacent, its every 4th cell in the row. But when i try it gives an argument error each time i try ...
3
votes
1answer
31 views

Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column? Let's say I ...
-1
votes
0answers
18 views

Replace cell references with values without F9 using macro (2)

I tried to use the macro in this post but it doesn't work on mine. Can you help to tweak this macro abit? I want to change from this: =((J26*J27*J28+J34*J35*J36+J30*J31*J32)*24/1000000) ... to ...
1
vote
2answers
17 views

Finding repeating digits at the end of a string of digits

I have a list of 10 digit toll free phone numbers. I would like to identify those that contain at least 3 repeating digits in the last 4 digits of the number. For example: 8xxxxx5444 8xxxxx2220
1
vote
2answers
16 views

Copying many cells to one location

I transfer data around a lot in Excel. I want to be able to copy many random cells to another location so that they are side by side. E.g. I want to copy a3,d21,aa32,cd121,etc. so that ...
1
vote
1answer
53 views

Excel chart for rail car movements

I need to display the movements of a group of rail cars between two locations. Each car has dates for "left location A", "arrived location B", "left location B", "arrived Location A" - repeatedly ...
0
votes
1answer
28 views

How to translate automatic months from a language to another?

I'd like to translate a billing report from Portuguese to english. It is accurate by months, and it is an automated sheet. A contract may start on January, but it's commonly started on the others 11 ...
-1
votes
0answers
22 views

Extract address from HYPERLINK cell in Excel 2010

I have a HYPERLINK cell in Excel 2010 where I have many rows on it. I want to extract underlined address from that HYPERLINK cell. Below macro is not working for me. Function GETURL(HyperlinkCell As ...
1
vote
1answer
21 views

Excel conditional drop down lists causing massive file size

I have an excel file which relies heavily on data validation. There are about 20 drop down lists per row. One column has a 35 formatting conditions. One column is a conditional drop down list (using ...
0
votes
1answer
28 views

Functions (specifically text functions) within a countif function

Is there any way to nest text operators within a countif? I want to check if the first 4 characters of a file are in the form A**. =Countif(Left(A1,4),"A??.") doesn't work, but I can put in a ...
1
vote
1answer
52 views

How to fetch data from another excel file and sort it under name?

I have 2 excel files, one of them is a list of workers and the other is a list of absences. I need to have the reason and the ending date from the absences list to be fetched into the main list, and ...
1
vote
0answers
28 views

Matching a column range based on a column label

I have written a spreadsheet for Excel 10 and am struggling with the last bit of formula. I wrote this: =SUMPRODUCT(--(ISNUMBER(FIND(B7,'PO SHEET'!$K$7:$K$74))),('PO SHEET'!$W$7:$W$74)) However, ...
-4
votes
0answers
22 views

Get the average of the last 5 non-zero cells in a row (not column) [duplicate]

Objective: Get the average of the last 5 non-blank cells in a row (not column). I am using Excel 2010. I have a row of 12 cells and weekly will enter a number or sometimes nothing at all. After ...
2
votes
1answer
38 views

Excel Strange Extra Digit

In Excel 2007/2010, I get this strange behaviour: Formula in cell: =2.6+1.4+4.62-8.2 Result in cell: 0.420000000000002000 Weird extra '2' about 14DP in. Can anyone explain why this is happening ...
1
vote
1answer
31 views

Excel add-in not loading when opening Excel from VBA

I'm using excel reg-ex add-in and it works well, the only problem with it that it doesn't load when excel is started by VBA. I've a macro in word to collect some data in Word and copy it to excel, ...
1
vote
2answers
26 views

Generating coefficients for SERIESSUM formula in Excel

I'm modelling a cash collection spreadsheet where a company sells products each week and wants to collect cash over a number of weeks (n; between 42 and 336 weeks). Assuming n is ≤ 52: To calculate ...
0
votes
2answers
27 views

how to insert a helper column?

I have an excel spreadsheet where each data set covers three rows. I want to sort the data based on the value in column K, which is in the third row of each data set, there are no values in rows 1 ...
1
vote
2answers
36 views

Excel 2010 Advanced Filter issue

I ran into something I can't really explain trying to filter a huge pile of data using the advanced filter... I had a document with hundreds of thousands of lines (.xlsb) containing a whole bunch of ...
0
votes
3answers
33 views

Compare two sheets in Excel and extract the differences to other third sheet

My situation: I got a huge excel sheet from a manufacturer of products for my online shop. This format: product ID | price | name | ... Every week the manufacturer is sending me a updated list ...
2
votes
1answer
50 views

Excel Macro Hyperlink.Add Errors

I'm relatively new to VBA code within Excel, so please forgive me if the answer is simple (I expect it usually is). I'm using Excel 2010, for reference. I'm trying to accomplish the following, with ...
2
votes
3answers
66 views

How can I make an Excel 2010 worksheet read-only without a password?

I want to make one of the worksheets in an Excel 2010 workbook read-only, but I don't want to use a password. I just want to make it so that I can't accidentally edit the sheet, and I don't want to ...
1
vote
1answer
21 views

How to use Conditional Formatting to change text color to match conditional fill color

I have used the Conditional Formatting to change the Cell fill color based on the percentage number. However, I would like to hide the text so I just have a bunch of colored squares with no value ...
0
votes
1answer
32 views

How can I find duplicate values in a column delimiting the results by ranges in a different column?

A B C 1 RANGES VALUES FORMULA NEEDED 2 1 x yes 3 1 x yes 4 2 x no 5 3 no 6 ...
0
votes
1answer
34 views

reference to first visible cell above in Excel

How can I get a reference to the first visible cell above the active one after the data in a table has been filtered. NOTE: I don't need this for summing up the data above. I know how to do that on ...
5
votes
2answers
331 views

Where is value coming from in formula?

I have been sent an Excel sheet and I am trying to workout how one of the formulas works. It has an if statement in it and the value if true looks to be some sort of variable that references a formula ...
0
votes
1answer
31 views

Making the 'Series Name' a combination of text and cell data?

I'm having an issue trying to figure out how to create a 'Series Name' for a line chart in Excel to a TEXT + CELL value. For example, I have two cells labeled 2015 and 2005 in Excel. In my chart, I ...
0
votes
1answer
15 views

How to create a preset for printing a workbook in MS Excel

I need to create a Default preset for printing a workbook in MS Excel. This includes predefining Sorting and Filtering values, Adding text to top and bottom of the printed document, And designing ...
1
vote
1answer
24 views

Formula to check 2 Excel 2010 data columns on Win 7 PC

I have 2 adjacent Excel sheet columns that contain numbers and I can insert an "IF" formula in a 3rd column to check for a certain condition without any problem but when I try to combine checking for ...
0
votes
0answers
50 views

Display the content of Column A when I put a 'X' in Column B

I have a workbook that contains the projects that I'm working, in many tabs. Each tab has one column that contains the name of the project and another that is an 'on going' column which I mark with a ...
0
votes
0answers
18 views

How to import excel data into power point with scrolling

Hellow Guys i need help about Power point I want to import data from excel into power point but i have a 1000 row data. if im import data using object or paste the data into power point it become ...
1
vote
1answer
26 views

In Excel 2010, how do you show the last time a row of cells was updated?

I have a project table that my whole team has access to. Each row is a specific project and they update the appropriate cells in the for those projects. The problem has become that the Last Updated ...
0
votes
1answer
32 views

MS Excel for Mac - conditional formatting

I would greatly appreciate help in writing the code to do the following: cell B7 is the sum of H7+I7+J7 when the sum in B7 is greater than 2 and less than 5 (i.e. either 3 or 4), I would like B7 to ...
0
votes
1answer
25 views

Excel Index Match for multiple conditions evaluates correctly with F9 but not in cell

I have an index match formula that evaluates correctly if I use F9, however when I actually press enter it returns #N/A. The formula is designed to perform a vlookup on two conditions: ...
0
votes
0answers
14 views

Scaling entire workbook in excel 2010 to same print size

I compiled a list of information into different tabs. From Tab 2 to Tab 8 are of the same information and I have set all their column length to be of the same size. But when I tried to print, they do ...
0
votes
1answer
43 views

Synchronized scrolling in excel 2010 across multiple sheets

I'm trying to figure out, how to scroll across multiple worksheets of one work book in a split horizontal view, without row number being off, when switching between the sheets. Excel synchronized ...
0
votes
0answers
9 views

Group command and shortcut not working in excel 2010 spreadsheet

I use Excel 2010 and maintain a yearly spreadsheet on it that tracks staff vacation dates. However i am not the only user so I don't know what may have happened to disable Shift+Alt+right arrow (to ...
0
votes
0answers
26 views

How to clear just the data from multiple Excel spreadsheets after copying using VBA

I am brand new to VBA and I have some code to transfer data from multiple spreadsheets into one master spread sheet. This works ok but at the end I need to clear the days data from each of the ...
-1
votes
0answers
12 views

I am trying to use multiple if statements to place data in specific columns based on the result

Here is basically what I am trying to do: If G4+90 is >= 1/1/2015 and <= 3/31/2015, then put the answer in J4. If G4+90 is >= 4/1/2015 and <= 6/30/2015, then put the answer in N4. If ...
0
votes
0answers
27 views

VBA: Restrict copy paste in drop down on PROTECTED Sheet (Figured out unprotected sheet but doesn't work for protected)

I am looking for a code that will allow me to restrict copy pasting something in a drop down menu. After some searching and trial and error I have found something that works perfectly on an ...
0
votes
1answer
61 views

Counting values in a column if a certain value exists in another column

I'm trying to create a Summary tab in my spreadsheet that will summarize info from another tab. Primarily, the parent tab is a list of tasks, status of the tasks (open or complete), and the persons ...
1
vote
1answer
36 views

WMIC |more has extra rows when .csv opened in Excel

I am trying to output the name and version of each program installed on my system to a .csv file. I could do something more complicated with VBScript, but would prefer to keep this very simple to ...
0
votes
1answer
22 views

How can I import a TAB delimited file with double quote text qualifier into Excel if a cell value already contains a double quote?

I am trying to import a TAB delimited file with the following format into Excel 2013 "Column A" "Column B" "tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp" "tjc0058088269r" ...
-1
votes
1answer
31 views

How to insert a button in MS Excel?

Friends I am using MS Excel 2010 and I wish to insert a button in Excel sheet whose name should be ‘1 ADDER’ and I want that whenever I press this button, it should insert 1 in the cell of column A ...
1
vote
0answers
17 views

Automatically Printscreen from result of formula

I have a procedure in VBA to call a PrintScreen: Sub PrintScreen() keybd_event VK_SNAPSHOT, 1, 0, 0 End Sub I want to call it every ten seconds, when the result of this cell ...
1
vote
4answers
53 views

How do I drag down a pattern over 100,000 rows?

In MS excel, suppose I have a worksheet with over 100,000 rows. How do I use the dragging feature over all the rows from the top for a fixed column efficiently instead of dragging down and waiting a ...