**0**

votes

**1**answer

16 views

### Reaarranging excel data from matrix to row

Month Code type QTY Price
201401 12345 AAA 20 76
201401 12345 BBB 6 1.57
201401 12345 DDD 1 4.5
201401 12345 EEE 417 8152
201401 12345 FFF 38 87
...

**0**

votes

**0**answers

27 views

### How to separate/filter out number with 3 decimal places into another column?

Please help,
currently i'm working on a massive number of data (up to 50 000++). i need to separate or filter out
the numbers which have only 3 decimal places into a new column (as bolted in the ...

**-1**

votes

**1**answer

30 views

### Excel Macro Radiobuttons dependent on cell value

I have a cell A1 which is filled with a dollar value eg. 20000 based on a vlookup. Depending on the value which is found I want 1 of 4 radiobuttons to be selected.
0-40K 40-150K 150-300K >300K
...

**1**

vote

**1**answer

18 views

### I need to do time conversions to work out average time taken by multiple students to complete a test

I need to work out some statistics to determine the average time students take to complete a test. I can do the conversion from minutes and seconds to just minutes for each student which is easy ...

**-3**

votes

**0**answers

22 views

### Excel: Replace only inside the brackets between

I have cell
452,Audi ,Audi 80 (B4, 8C, ka. S2, RS2) aasta 09/1991-01/1996 ,1.6
52KW / 71PS ABM aasta 09/1991-12/1994
This is in my CSV and delimiter is ",". But I need replace only in:
...

**0**

votes

**1**answer

17 views

### Can I disable banded rows by default for new tables?

When inserting a table into a worksheet, the Banded Rows table style option is enabled by default. I'm looking to disable this, I find fill colors to be very distracting.
Is there a way to toggle ...

**0**

votes

**1**answer

32 views

### 15 digit number with a letter on the end

I get spreadsheets with 1,000 15 digit numbers with a letter added on the end. I can retain the number by formatting the cells to Text and then remove the letter manually and it's fine. BUT if I use ...

**0**

votes

**0**answers

17 views

### when filter takes out all data, macro copies the titles over. Why?

I am using a macro that copies multiple columns into other documents. I use filters to determine which other documents it should be inserted into. When the set of data does not contain data for one ...

**3**

votes

**0**answers

23 views

### How to create a Call Diagram for Excel macros?

I have an Excel file with multiple VBA-Macros. For documentation purposes I want to create a UML Call Diagram, or similar that represents which macro calls which other one.
Is there a way to ...

**0**

votes

**0**answers

41 views

### How to change the colours of sparkline axes individually

I found the following code (in the office docs) which allows me to change the axis colour of a group of sparklines:
Sub AxisColor()
'The sparkline group
Dim oSparkGroup As SparklineGroup
...

**1**

vote

**2**answers

21 views

### Is there a way to reference an external excel file depending on a cell's value?

I am trying to make a template for a document that will be updated every week, and I was wondering if there was a way to insert some values automatically depending on the value of a cell.
To explain, ...

**1**

vote

**0**answers

21 views

### Excel: Naming results of intermediate calculations?

I'm making a marginal tax rate calculator and am finding that my formulas are getting quite large. Gross income, for example, is subject to a standard deduction and personal exemption. After ...

**0**

votes

**1**answer

38 views

### How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...

**-3**

votes

**0**answers

23 views

### count attendance in Excel? [on hold]

DATED Punch Records
1-Thur ABSENT
2-Fri 09:51:in,09:51:,20:18:out,
3-Sat 13:48:in,20:21:out,
4-Sun 10:46:in,
5-Mon 09:58:in,09:58:,20:18:out,
6-Tue 09:50:in,09:50:,20:18:out,
7-Wed ...

**0**

votes

**1**answer

34 views

### Find matching rows between two different data sets in Excel

I have two data sets as shown below. In the first dataset I want to know if the row exists in the 2nd dataset and return either "Found" or "Missing"
Is there any way I can achieve this in Excel?

**0**

votes

**1**answer

35 views

### How to count time absolutely, not on a 24 hour clock

I'm trying to find out the total runtime of a group of videos. I have a table of times for each episode in Excel, formatted in the Time format, e.g.
1 | 00:28:04
2 | 00:33:05
3 | 00:27:43
The ...

**0**

votes

**3**answers

26 views

### How to zero the milisecond time in excel

I have a table of times I've entered in excel.
The calculations added some fraction of times to my field so
0:13:13 is actually 0:13:13:1282
How can I get the exact time without the milliseconds ...

**0**

votes

**1**answer

18 views

### excel 2007 updating new adjacent cell value when reference cell i s updated

I have to copy or update cell value to new adjacent cell every time when reference cell value is updated.
I have Cell A1 with some formula, which updates it value frequently. what i need to do is, ...

**1**

vote

**1**answer

33 views

### Excel 2010: Combine Two Tables in Pivot Table

I have two named tables on separate Excel worksheets in the same Excel 2010 workbook. These tables contain the exact same header items. I could get the results I want by copying the data from one of ...

**-4**

votes

**1**answer

21 views

### Consolidate Text Data in Excel

I have an Excel document containing exam results. The results are in one column and appear as Pass or Fail.
I want to know percent of candidates who passed.

**0**

votes

**0**answers

34 views

### How do I install an Excel add-in? [duplicate]

In an answer to the question How can I set Excel to always import all columns of CSV files as Text? @nixda suggests downloading an add in, which I understand can save me hours of work, when I have to ...

**0**

votes

**1**answer

29 views

### Find Max Value in a Range - Return Contents of Cell in Corresponding Row

I have a spreadsheet that is made up of 2 columns - Each row contains a date and then a river gauge reading. The data covers 20 years - 1995-2015. I would like a formula that searches for the max ...

**0**

votes

**0**answers

16 views

### Using a date in the Value field of a pivot table

I have a "raw data" spreadsheet with hundreds of different contracts in it. Each contract has a different contract end date (among dozens of other data points). I am trying to run a pivot off of the ...

**1**

vote

**1**answer

30 views

### Best practice for displaying and calculating data in a pivot table? [closed]

I have a data table ('Legal Fees') with three columns:
Date
Attorney Name
Hours Billed
I have another data table ('Billing Rates') with two columns:
Attorney Name
Hourly Billing Rate
I would ...

**0**

votes

**1**answer

44 views

### Is there a way to copy data with a macro/button filter?

I have a worksheet with employee ids on the top and dates on the side.
Then I need to put a Y or a N at there name every day I have 96 employees so it's really long. Is there away with a button or ...

**0**

votes

**1**answer

31 views

### Excel find specific number of characters [closed]

I am trying to find in an excel list within cells all the consecutive 16 numbers without spaces
Is there a way to search for that ?
I want it to find all the numbers, 16 in total, but ignoring all ...

**2**

votes

**1**answer

35 views

### Count number of days between two dates including start and end date

I need to have a formula similar to networkdays, but I don't want it to count only work days.
For example: March 23, 2015 thru March 28, 2015
Those days are Monday thru Saturday, if I use ...

**0**

votes

**2**answers

24 views

### Excel Countif Function Error [closed]

I need to count values with < and > infront of them but excel won't recognize them as true numbers. How do I use a count function with true values and values?

**-1**

votes

**0**answers

10 views

### Copying sheet with references to another sheet using Open Office 4.1.1

For example:
In sheet1 in cell A1 I have function =E1. I want to copy sheet1 and I want that in sheet1_2 (copy of sheet1) in cell A1 to be this function: =E1 and not =sheet1.E1 Order of sheets is: ...

**-1**

votes

**0**answers

23 views

### Excel Macros stopped working?

A user recently updated iTunes and, since they, they are no longer able to run macros in excel - even from the developers tools tab when selecting to execute it does not work.
I'm not very familiar ...

**2**

votes

**1**answer

40 views

### Finding the first Non-Numeric Character in a String

If I have a cell with a mixture of numeric and non-numeric characters, I can locate the position of the first numeric character with:
...

**1**

vote

**1**answer

12 views

### Color coding data based off another sheet

I have a main sheet with names along the side, and authorized equipment along the top. I have separate sheets for each individual with all their assigned equipment. How can I make the corresponding ...

**0**

votes

**1**answer

11 views

### merge two sheets and keep the redundant data

I have 2 excel sheets.
First one is like this:
folk_id name first_name town_name
001 blog joe alamo
002 folk james brisbane
003 paco yatan barcelona
Second one is ...

**0**

votes

**0**answers

14 views

### Create Cluster in Excel by different columns [duplicate]

I have 2 columns of data, and I want to automatically sort them in a cluster way, at Microsoft Excel.
Column 1
Yes
No
Column 2
Platinum
Gold
Final Result:
Yes Platinum
Yes Gold
No Platinum
No ...

**1**

vote

**2**answers

15 views

### Problems with uninstalling Excel 2010 [closed]

Can I uninstall Excel 2010 from a computer if the mother board is damaged and I can no longer turn the computer on?

**-1**

votes

**1**answer

22 views

### Excel data validation: restrict to 10, 20 etc

I am trying to use Data Validation in Excel 2010. How can I restrict entry into a cell to numbers divisible by 10?

**1**

vote

**1**answer

42 views

### VBA - Populate cell if adjacent cell is not empty

I have created a macro that opens and edits excel workbooks for me.
Firstly, it adds a new column A and then changes the title for A1, B1, C1, D1.
After this, I want to create some sort of formula ...

**0**

votes

**1**answer

39 views

### Repair “corrupt” Excel file [duplicate]

I have some Excel files (.xls) which I would like to view. However, I have a problem in opening them.
When I open the file with a Wordpad-type program (TextPad), it opens, showing a dump of data. ...

**4**

votes

**1**answer

32 views

### Formula bar view changes when document is saved and reopened

I have an Excel 2007 document with a lot of formulas of the format:
SUMIFS(view1[COLUMN1],view1[COLUMN2],$C13,view1[COLUMN3],I$10)
but when I save the sheet and reopen it each formula is changed to ...

**1**

vote

**1**answer

28 views

### Manually editing Excel worksheet, need my edits to save as written in .csv without reformatting back

Here is my issue:
I have exported about 2000 records from a database to manually clean up the dates attached to them. (It appears that someone exported these records before, then re-imported them ...

**1**

vote

**3**answers

40 views

### Excel, IFs and Dates

I have a household budget, it is split into fixed and variable expenses. I would like to include the fixed expenses only during/after the month they are incurred.
Not a problem using the following ...

**2**

votes

**2**answers

427 views

### How can I combine two lists into one long list?

I have two lists in coloumns 1 and 2. I need coloumn 3 to be of the format one dash two.
For example:
Column C will need to repeat all values of A and B.
I would prefer a formula for this is ...

**1**

vote

**1**answer

24 views

### Higlight a specific cell based on ADDRESS() return value

I want to give a style (highlight) a specific cell based on a date value. This date is, say, in cell
A1.
To achieve this, I thought I would calculate the address of the cell I want to style with the ...

**0**

votes

**0**answers

25 views

### In Excel (2013) how do I get the value of grouped fields in subtotals

Using subtotals, I get the following:
click to enlarge
This is great, but when I collapse, I don't see what client (column A), project (column B), etc it is for. Is there a way to see the grouped ...

**1**

vote

**1**answer

50 views

### Excel VBA User Form option buttons

I've created a userform that will require an option button to be selected (thus emailing the intended recipient), otherwise it will display a msgbox.
I'm having a problem with the If And Then Else ...

**2**

votes

**1**answer

60 views

### Is there a way to skip down to the next change in value in Excel?

For my current daily use of Excel, I have a sheet where hundreds of consecutive rows have the same value for a particular column. I’d like a way to quickly skip down to the next different value.
ctrl ...

**0**

votes

**1**answer

25 views

### Excel 2010 Multiple Conditions and More Than 2 Outcomes [closed]

I need some help!
I have 4 conditions and more than 2 different outcomes dependent upon the condition so strugglig with IF/AND/OR statements. All data is dates. a2 is the reference date:
Condition 1 ...

**0**

votes

**2**answers

90 views

### Update and Append Rows based on Two Criteria in VBA Excel

Could anyone help me write a code in VBA that updates a table, or appends new data based on criteria in two columns?
For example, there might be a name column, and a project column, and we want to ...

**0**

votes

**1**answer

46 views

### Automatically update a filter

I have a graph depicting 3 years of data, and an option to pick which year(s) of data they want to see. I'm pulling the data from a chart that I have put in formulas that change the data to #N/A if ...

**0**

votes

**0**answers

13 views

### How to get excel make a nested outline hierarchy from an index column? format 1.2.3

I have a large set of data that is exported from a database.
In one column there is a index which shows the relations of the datasets.(Just an example)
Name Details Vendor ...