**0**

votes

**1**answer

8 views

### How to create an Excel Macro which works with any spreadsheet?

I want to create an Autofit macro which would work with any spreadsheet. Is there a way to create one?

**0**

votes

**2**answers

22 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

**1**answer

16 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

**1**answer

22 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

**0**answers

14 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

**0**answers

15 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

**1**answer

33 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

**2**answers

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

**4**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

24 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

**1**answer

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

**0**answers

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

**1**answer

21 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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**2**answers

37 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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

37 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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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 ...