The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
6 views

Mode of text in excel

I have a spreedsheet with team numbers and some info about them (as text). Teams appear several time, and in a different sheet I have a summary for each team. I want to find the mode for one team. I ...
0
votes
0answers
2 views

Data Entry Form Button to Fill Next Blank Row in Multiple Sheets in Same Workbook (Excel)

I have made a form to enter data one time (Data Entry) and need a button that when pressed will perform the following: Copy "Data Entry A8" and paste it into next blank row of "Data C"; Copy "Data ...
0
votes
0answers
3 views

Freezing and Crash in Excel 2010 When Formatting Cells

After normal function for over a year, we began to experience a problem in Excel 2010 running on Windows 7. When we try to format cells or change the font, we see a freezing or crashing behavior. ...
0
votes
0answers
10 views

Automated weighted counts in a Pivot Table (Excel)

I have data for sales people who work with different clients. Sometimes the sales person has multiple deals with the same client. I want to be able to work out the count for each sales person for each ...
1
vote
1answer
18 views

MS Excel HyperLink a cell value to a corresponding cell with the same value

Lets say I have a Column of data, at the top of the column I have all my math calculations and I pull up important data points to the top of the sheet, such as (Max and Min data points based on a ...
0
votes
0answers
14 views

Complex coutif formula

I hava a dataset that on the headers has: (String Employee Name, String Day off, time Check-in, time Check-out). What I want to do is get a table that has row labels from Monday through Friday, and ...
0
votes
0answers
13 views

Excel, pair 2 columns, then find all rows where column J is in two different Column D

SO I would like to have a formula or macro, to look at a table in Excel, pair two columns say J and M. Then find rows where M is connected to more then one value of Column J, Column J is Super Group, ...
1
vote
1answer
11 views

How do I match cells in one worksheet to another and print a result?

Not new to excel, but new to formulas. I have to say this is killing me. So what I am trying to do is take strings in one column, check if any of them are in another column of a separate worksheet, ...
-1
votes
3answers
43 views

How to capitalize the first letter in a cell in Excel

Recently i came across excel with cells filled with small cases,Is it there any easy way or macro to capitalize each word of the excel? For E.g Consider the below image : After conversion it ...
0
votes
0answers
4 views

Show Pivot Table values as percentage of another Pivot Table's values

I have two pivot tables with identical axes to each other - a list of countries down and across either side. Each table has a count of different types of interactions between the countries as values, ...
3
votes
0answers
21 views

Nested IF function returning tiny value instead of zero

Whilst creating a balance sheet for a lotto syndicate, I encountered this phenomenon; Note the negative zero value in D5. With no formatting, its actual value is -0.0000000000000230926389122033 ...
0
votes
0answers
24 views

How can i sort data with macro in different worksheet?

I use the following code for sorting a sheet in a workbook with a macro but when I open another workbook, it doesn't work. How I can I change the code so it can run in another workbook as well using ...
0
votes
1answer
36 views

Excel max number between 2 non-blank cells A, in column B (given no blanks in B)

I need to calculate the maximum number between 2 consecutive non-blank cells in A, but using the values in B. ie. use a formula in column C that will give me the results I manually plotted in D. ...
0
votes
1answer
23 views

VBA- Copy and paste error 1004

I was doing a code for vba and wondering why I received a runtime error 1004 when attempting to paste in sheets "Datasheet". It tells me the information cannot be pasted as the copy area and paste ...
0
votes
1answer
34 views

If Column value = string then add row next to column to sum

I want to make an expense chart In Excel. I have two Columns, one for type of expense and one for cost of expense. I made a few categories where the types are summed. The types are Entertainment, ...
0
votes
0answers
12 views

Keep a table in view while scrolling down the page [on hold]

I want to keep a list of hyperlinks on my worksheet in view when I scroll up and down the page, its not in the first row or column and I don't want to split the page, does anyone know how to do this ? ...
0
votes
0answers
33 views

Link primary and secondary x-axis in Excel 2010

I have an y-axis and two x-axes, which are depending on each other. But this depencence is not taken into account in Excel 2010 and I can primarily move the secondary axis up and down the range by ...
0
votes
0answers
24 views

How to combine two sheets based on their dates?

I have two sheets: one is stock index, one is air pollution value. I want to match the air pollution value to each trading day. How can I do it on Excel? the first sheet looks like: 01/01/1997 39 ...
2
votes
0answers
8 views

Hyperlinks on Excel 2010 - copying from orignal list to search index list

I've created a search index (using forumlas) from a list of products that have hyperlinks attached (created with Insert Hyperlink). The search index is created without the hyperlinks however. Both ...
1
vote
0answers
11 views

Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time? See the PivotTable below as well as the source data (both excerpts). If it is in fact not possible to ...
-1
votes
0answers
12 views

Excel time and date query

I have an excel sheet where in column A has dates and column B has time, i tried IF function but in vain. I want if the column A has same date in row then column B should not have the same time in ...
-1
votes
1answer
36 views

Formula issue Microsoft Excel

I need help urgently for a work problem. So basically, the summation of opening stock and production give total stock. While closing stock is ((opening stock+production)-sale)) and stock cover is ...
-1
votes
0answers
26 views

Excel Sort multiple rows at once

How do I sort all the cells of each row in a worksheet? I have 3 columns: Option 1 > Option 2 & Option 3; Not all rows (60+) are sorted A, B, C I can sort each row but due to the number of ...
0
votes
0answers
22 views

Save worksheet as a seperate file [on hold]

I would like to know if there is an option in Excel 2010 where you can save a specific worksheet in an Excel file into another file, without having to open the destination file. Thus without having to ...
1
vote
1answer
23 views

After pasting data, how do you navigate cell contents with keyboard arrow keys in MS Excel?

Using MS Excel 2010 I can copy ASCII plain text from a separate text document and paste the text into a cell (I first enter cell edit mode before pasting with Ctrl+V or Shift+Ins). After pasting, ...
0
votes
1answer
16 views

How to transpose two cells data at a time from 2 cells to multiple rows

I have Excel data in the below format: Excel Std Row: A B C D E F G H I J 1st Row Data: 1 1 2 2 4 4 5 5 6 6 Now I need output as below: A B ...
1
vote
1answer
32 views

Copying cells to another sheet and inserting rows for the copied cells

I am trying to create a sub that copies information from one form (which has four cells) to another sheet. When it copies the information it also creates a new row. Each form has a maximum of ten ...
1
vote
2answers
29 views

Need to count the amount of times -1 appears above a certain cell

I have the following Excel Spreadsheet - Hy Newcastle 042216 -1 Not Matched 1000 Hy Newcastle 042216 6461735 Khanyile;Florence Success 1000 Hy Newcastle ...
0
votes
1answer
37 views

How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...
-2
votes
0answers
30 views

How to track changes in Excel 2010 like Word?

I have a workbook with a tab for each of 12 product lines. Each month the execs for that line make changes to their worksheet(s), depending on new products, different financials, comments or notes, ...
2
votes
1answer
17 views

Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function. I also have a scatter plot where the selected data is like this: =SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1) I want to replace $F$4 in ...
1
vote
1answer
29 views

Is there a way to configure Currency or Accounting dropdown in Number Ribbon?

Is there any way to configure the list of currencies showed in the Ribbon (see screen shot)? My most used currency, $, is not available in the default list and I can't found out how to modify this ...
0
votes
0answers
18 views

Excel 2010 VBA Freezing panes when scrolling down (multiple headers)

I have a large spreadsheet with multiple headers in different rows, and I want to be able to freeze different headers while scrolling down and freeze pane. For example, A B ...
0
votes
0answers
19 views

Copy Top 10 from one workbook to other [closed]

I have excel workbook as "Report June 21 - June 27" and each containing "ATT" sheet as first sheet. Report June 21 - June 27.xlsm I want to take the Top 10 in B, Q and R column by sorting Q5 by ...
1
vote
1answer
40 views

Excel: Write a 1 or 0 value if condition is met

Sorry if this has already been posted, but I just started today playing with Excel macros and I need a hand. I have a data column with values and I would like that if the conditions were met, the ...
-1
votes
0answers
20 views

excel 2010 VBA insert column headers [closed]

I have a piece of VBA code (Excel 2010) that generates tables with 5 columns x 6 rows. There is an option to input the number of tables to be generated, as required e.g. 1 or 6 or 10 etc. basically ...
3
votes
1answer
43 views

Can this 5-attribute 2D risk map be built in excel?

So there is this risk map (or heat map otherwise) below (*): What is interesting is that in the a 2D image there the following attributes are mapped: Attribute -------- Drawing component 1. ...
0
votes
0answers
10 views

Using Hlookup to populate a worksheet from a data sheet

I am trying to develop a worksheet that requires a list of equipment based on an area header. I would like to be able to pull the separate lists based on this area header. Here is sample data I am ...
1
vote
1answer
45 views

Excel 2010 error message when opening .xlsm files

I'm trying to open a .xlsm file in Excel 2010 when I receive the error: "There was a problem sending the command to the program" Once Excel is open, I am able to open the file, but if Excel is ...
0
votes
0answers
15 views

Prevent my excel file from been opened in an older version of excel

As the title says, I would like to prevent my excel 2010 Pro Plus spreadsheet from been opened by someone using an older version of office. I created a spreadsheet that my colleagues and I update ...
0
votes
0answers
22 views

Is there a way of 'detaching' a column from the rest for the purposes resizing the cells in it?

Here's an example Excel spreadsheet. Basically what it is an chart for time organisation, and I use the left most column for storing some notes (back log items etc). Now I need to to keep the ...
-1
votes
0answers
37 views

Excel range to html? Excel 2010

Looking to take a range of A1:I26 on sheet "Desc" and convert it to html. That html then show in Cell H2 on sheet "-Listings-" The cells in range A1:I26 has a graph with formatting i want kept (I.E. ...
0
votes
1answer
43 views

Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well. The ...
0
votes
2answers
77 views

How can I compare two columns and if match return a value?

How Can I compare the entries on TAB: SUMMARY SLS, column B with SUMMARY P&S, column B and bring back a "X" if a match is found in the cell with the formula? SUMMARY SLS and SUMMARY P&S are ...
0
votes
1answer
23 views

Find cell address for MAX+IF function based on category

I have a large set of data, which has been divided into 9 categories using numbers 1-9. The data is not sorted by category, but the categories are defined in a column as data. Using MAX+IF, I have a ...
4
votes
3answers
48 views

How do I force Excel to always type purple text?

I'm making changes to a large Excel worksheet, and every change I make needs to be in purple text. Right now, I'm typing the change and then clicking purple text. Is there a way to force Excel to ...
0
votes
0answers
10 views

Why does outlook 2010 contact avantlink.com during splash screen startup?

The "contacting ......" message takes forever and finally allows outlook to run. I blocked the site via host file and now it either tried to make contact and stops to allow outlook to run, or a second ...
1
vote
1answer
38 views

If statement that returns original function if false (similar to iferror, or substitute)

If I use IFERROR as opposed to IF(ISERROR I can save typing the condition twice. i.e. =IFERROR(Long lookup,"not found") is much preferable to =IF(ISERROR(long_lookup),"not found",long_lookup) ...
-1
votes
1answer
27 views

BOM comparison sheet

I have been working on Comparison sheet, where i need to compare Base BOM1 with other BOMS. I added formula & prepared the attached sheet & I am able to highlight the mismatch values. But i ...
0
votes
2answers
19 views

How to sum with two variables involving date range

I get raw data much similar to the example below that has thousands of rows. What I need to be able to do is sum the values in column C (Or column D) based on the value in column A within the date ...