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

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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
2answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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 ...