The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
2answers
12 views

Excel VBA : Msgbox from other application

I have an Excel macro that deals with thousands of lines in several tables and do some copy/paste/analyze/combine... operations. it takes almost 10minutes to run it fully. I added a MsgBox "Job Done" ...
0
votes
2answers
25 views

How can I combine multiple columns so that they appear as a single range in an Excel formula?

I've got a spreadsheet that has several columns that hold the same type of data (a list of average measurements). They're separated into different columns as each on represents a slightly different ...
1
vote
0answers
31 views

In Excel 2010 - Trying to get the cell address from where a formula got its answer

I have a complex spreadsheet with a named range (Vault) that covers chunks of data from many parts of the sheet: "Vault" represents a defined name and refers to the following areas on page 1 (you ...
-1
votes
0answers
25 views

highlighting duplicate rows in excel by VBA macro

I have a matrix which includes different/same values in first column, and different values in first row. I would like to compare all rows and highlight duplicate rows. For each row, it should check ...
1
vote
1answer
77 views

If(AND) combination produces “You've entered too many arguments for this function” error

Combining around 4 If(AND) conditions giving error as You've entered too many arguments for this function The formula is here: =IF(AND(C2 = "Low", X2 <= 168), "Met", "Not Met",IF(AND(C2 ...
0
votes
0answers
11 views

Looking for a formula to calculate multiple rows and multiple columns, but only rows with matching reference numbers?

I am trying to calculate the Gross Margin for a "load" that has multiple transactions (each in own row). My first thought was to use a SUMIFS formula because I need to have the following criteria: 1. ...
-1
votes
1answer
16 views

Grand Average in place of Grand Total in Pivot Table

In a pivot table I want to change the Grand Total field to Grand Average. For example. Row Labels Day1 Day2 Day3 GrandTotal 1 10 20 30 60 2 15 25 ...
-2
votes
0answers
20 views

VBAscript if condition is true on range of cells, copy a value to another specific range of cells

I'm trying to create a VBA scrip that will check range b47:b53 for a "true" value and if value is true it should insert the value of cell "I64" on the correspending cells range g47:g53 ... I use a ...
1
vote
1answer
31 views

How to restructure data in Excel?

I have daily data for different sites organized as shown here: I'd like to organize the previous data using Excel to look this figure: I have tried using pivot table to change rows into columns ...
1
vote
3answers
29 views

Excel Converting Time to Decimal

I have a python script that collects a bunch of data. At the end, it prints the collected data to an excel spreadsheet. One of my columns is displaying the "Time Elapsed" in a form of minutes:seconds. ...
1
vote
1answer
40 views

Index match function to return range category in Excel 2010

I have defined categories in columns on which the values represent the ranges for each item (rows). By using the query (column G), I want to know in which category the item ("yellow", 60) falls into. ...
-1
votes
2answers
27 views

Formula to extract the string between the Nth square brackets

Cell A1, A2, A3, etc contain strings similar to the following... 1 x Product A [SG014] 1 x Product B [SG026] 1 x Product C [SG023] Each cell in column A could be a string of up to 20 different ...
-1
votes
2answers
46 views

if greater than zero copy from the range [duplicate]

I have data sheet with "product" list in range B38:B161 and "to order" column in range I38:I161 which will be updated manually. So when cells in range "I" is updated with number to order, the product ...
1
vote
2answers
32 views

How do I identify duplicate rows in an Excel cell?

I have an excel file with thousands of rows of contact info. I need to get a list of all the rows that have duplicate first and last names. I have been able to use conditional formatting to ...
0
votes
1answer
26 views

Display prefix units in excel cell

I have a specific cell in my excel sheet that contains a value from 0-100 (The value can be changed by the user). Whose value is used in some formulas at different places in the sheet. I would like ...
-4
votes
1answer
45 views

Formula to find the upper case in the sentence as true [closed]

i have one worksheet which has a sentence in-between uppercase words, i want to know which cells has a uppercase word in the sentence. Please someone help me out with the right formula to find. I ...
-1
votes
0answers
28 views

How to stop Excel from splitting data onto several rows

Secenaro .. have an CSV file in one of the blocks of data their are several values e.g. Other, Mobile, Data etc.... which is the results of a query dump from field that has "multi-select" options. ...
1
vote
1answer
33 views

Excel Copy Formulas Horizontally

On Row 1, Column A I have =Sheet!1K2, on Column B I have =Sheet!1K3, Column C =Sheet!1K3 and so on. On Row 2, Column A I Have =Sheet!1L2, on Column B I have =Sheet!1L3, Column C =Sheet!1L3 and so on. ...
0
votes
2answers
40 views

How to find time difference between two rows of one column in excel sheet?

I have an excel sheet containing the Entry and Exit time for users from bio metric software. I want to find how much time the user had stayed i.e. sum of difference between entry and exit times, but ...
0
votes
1answer
44 views

Excel formula to calculate the total time spent on various tasks [closed]

I need a formula to calculate the total time spent on various tasks but I want the total splitting across the relevant interval each day. For example, column A has the start time and column B has the ...
-2
votes
0answers
29 views

Macro (Need help writing) in excel 2010

I am trying to write a macro that will compare column A and column B. I need it to look at the first number on A and see if there is a match on B. If there is I need it to delete the cell in A and B. ...
2
votes
0answers
24 views

Date types management mismatch (2-digits year) - on copy/paste user action

I find a strange inconsistency when copying-pasting dates on MS Excel, when they have a 2 digits year. I work on a machine Windows 7 Enterprise 64 bit and my Excel is a 2010 version. PROBLEM ...
0
votes
1answer
35 views

How do I create a table with multiple header rows

How can I create a table in Excel that has two or more headers rows. I want to keep the range as a table so I can use the built in tools such as re-sizing, totaling, formatting, etc... I saw a ...
1
vote
1answer
27 views

Conditional Formatting on a Specific Character only

I have the following Excel table : > N 1 Open / Closed 2 O 3 C 4 O 5 O 6 C I want to put a Conditional Formatting, putting in GREEN ...
0
votes
0answers
11 views

Why does my Excel 2010 file add rows to the bottom of one of my sheets?

I have an excel 2010 file that continually adds extra lines to the bottom of the one of the sheets when I cut and insert rows from the top to the bottom. I have two sheets, one works just fine and ...
1
vote
0answers
23 views

Calculated Fields Reference Error (#NAME?) on Pivot Table Refresh

I'm helping a colleague fix a spreadsheet with a similar issue as stated in this ozgrid post. The problem: Pivot table with 31 calculated fields. Some calculated fields are calculations of the source ...
0
votes
0answers
13 views

Accessing locally stored external data

I have an excel file that has an external connection in it to a SQL server DB. The external data from the last refresh is stored in Excel somewhere as i can create new pivot tables from that data set ...
3
votes
1answer
142 views

How to automatically colour cell background with value selected from custom dropdown list in MS Excel 2010

In MS Excel 2010 Professional is there a way to automatically copy the background colour of the custom dropdown values from somewhere else in a spreadsheet? I have some Data Validation on a row of ...
1
vote
1answer
15 views

Excel Stuck in Developer 'Design Mode'

We have a set of spreadsheets that contain scrollbars added in developer mode. Clicking these scrollbars changes a value and a diagram in the spreadsheet. Suddenly these do not work. The mouse cursor ...
-2
votes
0answers
14 views

macro to collect data from number of sheets to main page and need to add the sheet name that where the data collected

Please help me..,I need a macro to collect data(Student names) form number of Sheets(Class Name).all student names collected from sheet1, then a new column added with the sheet name (i mean ...
0
votes
0answers
19 views

Using Chart BeforeDoubleClick with a chart object in worksheet

I am trying to get a macro to work on a chart in a worksheet using the Chart.BeforeDoubleClick event. I have been able to use BeforeDoubleClick event (without the use of class modules) in a ...
4
votes
4answers
155 views

Comparing the first part of a string in Excel

I'm trying to create an automated function that will determine the class identification for IP addresses after you input it into Column A's input section by checking the first section of the address. ...
1
vote
3answers
500 views

Can't click on ActiveX control in Excel 2010 Standard

I have a .xlsm file that has ActiveX control button with a module macro assigned to it. Problem is I can't click the ActiveX button from my Excel 2010 Standard. I tried to repair and reinstall Excel ...
0
votes
0answers
11 views

Oracle connection/Pivot tables

I'm using Microsoft ODBC for Oracle Connection to connect on Oracle 11g database through Pivot tables. It works fine with old version of Excel (i.e. 2003) but when I'm saving file as 2010 .xlsx my ...
0
votes
1answer
27 views

Adding Index to Match formula

I have the formula below working correctly, it is returning the max value in column G when the other conditions apply (valumes in B and F). However now I know what the Max number I want to return the ...
0
votes
0answers
11 views

My image wont show up when I insert picture from file in Excel

I am trying to insert a picture into an excel spreadsheet. I follow the normal procedures, but when it brings it into the excel sheet it either says "Image cannot be displayed" or shows up a clear ...
0
votes
0answers
10 views

Why does Access return “Conversion Type Failure” if I'm importing text into… text?

For some reason, no matter what, I get a "Type Conversion Failure" (found in a generated log-table) after importing data from an Excel spreadsheet. It's only happening to a few columns that have ...
0
votes
0answers
10 views

Keeping cells in the same row lined up when columns in the same row have 2 different data sources

I am working on a worksheet that references data on a different worksheet (within the same workbook). Each row in the referenced worksheet represents an order. Data from the referenced worksheet ...
1
vote
1answer
27 views

Excel return a list of stringe where 'TRUE'

Ok so I have couple of cells listing warnings: A B C 1 Warning1 TRUE 2 Warning2 FALSE 3 Warning3 TRUE Now I want to return list of warnings that are set to ...
1
vote
5answers
42 views

Using 3 conditions in Excel

I am trying to extract data using three conditions. I have very sensitive information, so I am only able to provide some basic data below. What I am trying to output from using 3 lists is that if a ...
0
votes
0answers
20 views

merge multiple sheets in a work book excluding specific sheets excel 2010

How can I merge multiple sheets in a work book excluding specific sheets in excel 2010. I tried the macro below but it includes all the sheets in the workbook. Thanks. Sub Combine() Dim J As ...
0
votes
1answer
21 views

Looking to total cells, but leave some blank in between

I've written a worksheet for selling work. I have one column "C" for the cost, and the column next to it "D" for a subtotal. Depending on the work to be performed, not all rows will have values to ...
0
votes
2answers
41 views

Conditionally Formatting Across Cells

I am organizing an event and would like to do the following: I have a General sheet with all the invitees names, addresses, etc. I also mark here if they replied and how many people will be ...
0
votes
1answer
34 views

Chart labeling: durations in minutes and seconds

I am attempting to chart the durations of phone interactions. They are currently entered as time of day values (I did not build the workbook), even though they are actually duration values, and Excel ...
0
votes
1answer
17 views

How to use excel 2010 functions to caculate the sum of distinct unique values?

How to use excel 2010 functions to caculate the sum of distinct unique values? remove the duplicate values sum of distinct unique values but I don't need to know who are the distinct unique values, ...
0
votes
0answers
24 views

Why is the autosum behaviour not as expected when used on an entire column?

This is some strange behavior I encountered when using the Sigma to sum a column. If I click on the open cell under the last number in a column and then hit the Sigma button and press enter I get the ...
0
votes
1answer
21 views

Capturing Text from Pivot Table

I'm trying to create a pivot table that has 2 parts. In order to push parameters into the table, you would add allows users to filter across any one of several parameters in a field. For instance, ...
0
votes
1answer
13 views

How do I assign a key based on count of available keys and indicator value?

I need some help writing a formula that does the following: Looks to see if an indicator=1 If indicator=1, lookup the key value based on the number available for that particular key Keep looking up ...
0
votes
1answer
16 views

converting a cell specifcally formatted as 1h 25m (not excel time such as 1:25) and converting the cell to 85m

I would like to convert a cell with the following text/numeric string 1h 25min to a cell that displays 85min. Unfortunately, the original cell is only in the 1h 25min format and not in a true excel ...
0
votes
1answer
33 views

Mass change the appearance of URLs in Microsoft Excel

I wish to change the appearance of the URLS in a Microsoft Excel worksheet. At present the current URL's look something like: http://www.example.com/101010101010101010101010101. I know how to change ...