Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
16 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 ...
0
votes
1answer
15 views

Excel on Mac and Windows have different row height / column width ratios

I find it odd that the same workbook in Excel is stretched horizontally on the mac. This is a slight problem, because the word wrapping changes, sparklines become squished, and the appearance becomes ...
0
votes
1answer
18 views

Excel - Recognize JS Date format

I have a service that spits database data out into CSV format, that I can't necessarily change right now. While the executing query returns the standard SQL date format - 2014-12-26 19:41:23.012 - ...
-1
votes
0answers
10 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 ...
2
votes
0answers
14 views

Why does Excel Table Format, always use absolute referencing in formulas. Any way to disable it?

The Table format (Home> Format As Table) option is a good feature of Excel. I am using it in Excel 2013. But when I put a formula and try to copy it across, it does not work. Trouble comes when you ...
0
votes
1answer
32 views

Count several values appearing together in several rows with another

In excel, how can i count how many times one value appears in the same row as another value. for example in this array, how many times does 5 appear with 6. I can see its 3 times but need a formula to ...
0
votes
2answers
22 views

How to sum rows with a timepoint and a duration criteria

I got two tables. One with 36 columns representing three years and a second table with three columns a number a start month and a duration in months. In the second table I got different rows, for ...
2
votes
4answers
40 views

The file is open by another user

Help me to hunt down a question. Then I am trying to open or save a spreadsheet in excel it always shows me a downloading status bar without any progress. After few minutes the file opens or not. ...
0
votes
1answer
34 views

How to calculate average bed and wake time?

I have a spreadsheet of two columns. A contains bed time (time I went to bed) and B contains wake time (time I woke up). How could I go about calculating the average of bed time and also wake time? ...
0
votes
1answer
27 views

Excel column functionality

i was looking for a function in Excel to do the following thing. I have a list with EAN codes (they're all in column A) with every EAN code there is a description of what it is (descriptions are all ...
1
vote
2answers
40 views

When draging cells down, how do I get it to fill with even refrences (A2, A4, A6)?

I am trying to fill cells with even references (condition A) but Excel provides me with complete series fill (condition B) when I drag down formula. Condition A: $A$1+A2 $A$1+A4 $A$1+A6 $A$1+A8 ...
0
votes
2answers
15 views

Building a graph off of a sensitivity table that's been conditionally formatted

Ok I'm having the hardest time explaining this so will use pictures. I have a sensitivity table with conditional formatting. Right now it's formatted to highlight everything <=$40. You see how ...
0
votes
2answers
23 views

Average for every n row in Excel

I have a column with about 1000 rows and I want to find the average for every 16 rows and add it in the next column without empty cells between them. I found this formula, which works perfect if my ...
2
votes
1answer
18 views

Vlookup formula works with some months, gets #value error with others

Here's my formula: =IFERROR(((VLOOKUP($D$2,UOS!$A$18:$AC$31,5))/30)*$G$2,"") The $D$2 field is populated with =Text(c1,"mmmm") When I use this formula and $D$2 is January, February, March, May, ...
1
vote
0answers
19 views

How to enable the 'Save and Open' option in Internet Explorer

I've recently upgrade to Internet Explorer 11 and now when I try to download/open a *.csv file from the internet I get the following options in IE. The Save and Open option is disabled/greyed out. ...
0
votes
1answer
19 views

Excel 2013 MySQL Database Connection - SQL Server does not exist or access denied

I recently set up the most basic possible version of MySQL 5.6 and created a test schema in which a test table was placed. The connection is just named "Local instance MySQL" with host "localhost", ...
-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
18 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
23 views

Using AVERAGEIF, how do I exclude Zeros?

The current AverageIf forumla works well for me. But the problem is it's counting all the Zero's in my data. Are you able to provide guidance on how i add into this formula the exclusion of Zero's? ...
2
votes
1answer
30 views

Application and Object Defined Runtime Error 1004 - using for loops to populate Cells(x, y)

I'm using the below code to try and find the intersect of Var1 and Var2, and populate the value into my userform that I'm running. I have no problem finding the intersect, but every time I try and ...
1
vote
1answer
26 views

Getting chart to ignore zeroes as a result of a formula

I'm doing a weekly log for some athletes with some data and I want to chart it as they fill it in during the week. The only issue is that for days in the week where the data hasn't been entered yet, ...
2
votes
1answer
21 views

Excel: extracting a number from mixed content cell

How would one extract a number starting with a "£" sign from a cell containing alphanumeric characters? Example: extracting £450,000 from A1 and placing in B1. See image for example text ...
-1
votes
1answer
16 views

Creating a hyperlink to link to the folder my file is saved in

I was looking to create a hyperlink within excel that would open the folder where my current file is saved. I don't know where to begin, I found the question linked at the bottom and thought that ...
-1
votes
0answers
10 views

I am trying to open multiple file paths at once from a generated list. [on hold]

I have a report that I run through Crystal Reports that generates all of the associated file paths that I need to have opened. I can export this list into a notepad or excel file if need be. What I ...
1
vote
1answer
39 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
0answers
32 views

How to transfer data to other sheets automatically

I have this master list (Sheet 1) including all items: Name Price Stocks Colours A1 A2 A3 B1 B2 I need to separate the items into different sheets like: Sheet 2: Item Price Stocks ...
-2
votes
2answers
65 views

How to have a value from one Excel sheet propagate to other sheets, while being incremented?

I have an Excel workbook, which has 100 sheets in it, all the sheets are identical apart from A10 in every sheet. In A10 of sheet 1 there is a value 101 which I typed in manually and A10 of all other ...
-6
votes
2answers
57 views

How to do simple math in Excel VBA

I have a value in any cell which is greater than 60. For my purpose, I need to subtract 60 from such values until the value is less than 60. So, for example, say I have a cell containing a value of ...
2
votes
2answers
36 views

Microsoft Excel - Sum drop down boxes with text

Good morning everyone. I require some help with my spreadsheet. As you will see by the screenshot below, i have added drop down boxes with text that i pick based on different combinations. I then ...
-1
votes
0answers
16 views

Microsoft Excel transform table data

I have the following table (#1) in Excel which I'm trying to convert to format shown in table 2. I tried pivotting, but I could not get it to work. Table 1 Time User Ref Average 8-Dec ...
1
vote
2answers
31 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 ...
2
votes
1answer
20 views

How can I filter which colums will be shown on a spreadsheet?

I have filters set up for each column, however I also want to be able to filter which of the columns show. Eg: I have 70 different columns, all with different headings. How can I create a filter that ...
-1
votes
2answers
41 views

Excel Data Not Refreshing [on hold]

I have an EXCEL sheet that is connected to an outside Flatfile. I have the report set to open up and refresh the data automatically. However, the data does not refresh and I still have to manually go ...
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
vote
1answer
42 views

Assistance with Excel macros

My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to it but don't have the first clue about how to do it. I'll do my ...
1
vote
1answer
36 views

VBA code to change the selection of a drop down list (combo box)?

I ran the macro recorder and changed the selection of a drop down list that is formatted with data validation, and nothing was recorded. Does this mean that there is no way in VBA to change the ...
0
votes
1answer
21 views

match product and copy a row range to Sheet 2

I have 2 Sheets. In Sheet1 I have a list of products (400) in column A. In colums B to M is the space for the names of 10 different owners, but each product could have any number of owners in one of ...
-1
votes
0answers
19 views

query about excel joining data on sheets

just wondering if its possible to link cells in excel, say i have in column A 1,1,1,2,2,2,3,3,3,5 all below each other and in column B a range of names matched to the numbers. Then in a second sheet ...
-6
votes
1answer
25 views

Deleting some cells in Excel 2013

I have 30,000 contacts on my excel sheet and some have not included their emails. I am a beginner at excel, and would like to know how to delete all cells without emails as well as the corresponding ...
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
39 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 ...
1
vote
1answer
45 views

IF formula incorporating sequential answers

I am trying to write an IF-THEN formula that outputs sequential numbers (See the example at the bottom). If you need further clarification on the process, just let me know. Here is what I am trying to ...
0
votes
1answer
25 views

Copy Full worksheet including multiple defined range names using macro or VBA

I've been trying to build a workbook for my company to use to track sales. The problem I'm running into is that I want each user to have their own workbook saved on their local computer for their ...
0
votes
2answers
37 views

Obscure DateTime Format

I have a document with dates of the form 2014-05-14T9:15:20. Unfortunately, Excel does not recognize this DateTime format. Is there a way to tell Excel to read this as a DateTime format without ...
0
votes
2answers
29 views

Numbering Identical Items in A Column

Suppose I have multiple, repeating names as follows: John John John John John Tom Tom Tom Tom Tom Tom Anna Anna Anna Anna Anna Anna I would like to find a way to tell Excel: while the name is ...
0
votes
1answer
46 views

How to find number rise within 1 hour in Excell?

I have numbers logged over the period of time. In one column, lets call it A there is a time in seconds from 0 to 10000, in the column B temperature logged accordingly to the time. Temperature usually ...
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
23 views

Referencing cell in workbook with variable name

I have a spreadsheet with a macro that creates a copy of a worksheet and names it with the current date. name of new worksheet is captured in first worksheet. How can I reference a cell in the second ...