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)

1
vote
0answers
7 views

How do I enable macros on an external harddrive

I have an external harddrive that I have mapped locally to the e:\ drive. There is a subfolder that contains excel sheets with macros that I am unable to run. In File->Options->Trust ...
0
votes
2answers
18 views

1 A, 2 A, 3 A automatically becoming 1:00 AM, 2:00 AM, 3:00 AM in Excel 2010

I use MS Office 2010. While using Excel, whenever I type 1 A, 2 A, 3 A up to 12 A and move to next cell by hitting Tab or Enter key it automatically becomes 1:00 AM, 2:00 AM.....12:00 AM. This problem ...
-3
votes
2answers
23 views

How can I scrape only word data from a website?

I want to download all the word content from a particular website. Save the results in MS Word, Excel or Notepad and check which words are repeated most often and how many times.
1
vote
2answers
22 views

How to use validation to make sure cell value starts with specific word

I need to check if the value of a cell starts with the term superuser. The entered value then should, for example, look like this: superuser template If the user enters super user template (with a ...
-1
votes
0answers
18 views

Excel 2000 - barcode scanning error

Using a well developed barcode scanning control panel that was made by another employee at work. Problem is, we get an error in situations where there are multiple barcodes on a box and the wrong ...
0
votes
0answers
19 views

Is there a limit on the number of rows a sum function can calculate in Excel 2007?

I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting ...
0
votes
2answers
25 views

Combine first letter and last word in excel

I have a spreadsheet of usernames. First and last name are in the same cell. Is there a formula to take the first letter of the first word and the whole second word? For example; Cell A1 has Jon ...
-2
votes
0answers
12 views

Shortcut for expanding the Year,Month.Day in pivot

I'd like to know if there is any shortcut for expanding Year, Month and Day in a Pivot table
0
votes
1answer
25 views

Finding Clustered/Consecutive Values in Excel

I am trying to find values in an Excel spread sheet where numbers greater than 0 will be highlighted. However, those highlighted must be clustered, consecutive numbers which should be (at least) three ...
0
votes
1answer
22 views

Excel formula - is it possible to return a value adjacent to a list of values, depending if that list of values matches another list?

In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B. I need to compare another list of document numbers (alphanumeric), ...
0
votes
1answer
20 views

Sorting cells in rows to match respective column headers

I'm trying to sort the cell value in multiple rows to match the value of a column headers. What it looks like: A B C D E --------- D A C C E B D E E What I want it to look like: A B C D E ...
0
votes
1answer
35 views

Sheet name dynamically assigned from a cell value

Sub CreateWorkSheetByRange() Dim WorkRng As Range Dim Ws As Worksheet Dim arr As Variant Dim template As Worksheet Dim xTitleId As String On Error Resume Next xTitleId = "Select Range" Set WorkRng = ...
1
vote
2answers
54 views

Index of N'th largest value in a range

I have a range of values that may contain duplicates. It looks something like this: A B C D ---------- 1 23 1 2 12 2 3 23 3 4 36 4 5 19 5 I want to display the 3 largest values, but I ...
0
votes
1answer
16 views

SUMPRODUCT where the product is computed from the row

I have a range AG6:AS38. It looks like this: AG AH AI AJ AK AL AM AN AO AP AQ AR AS -------------------------------------------------------- 6 | 1 A B C D ... 7 ...
-2
votes
1answer
17 views

EXCEL, I need to take data from 1 column & arrange in another column so the data loops [on hold]

EXCEL, I have 4 columns. one column having part numbers, a blank column, column with group number & 123 count column. I need to take item 1 of the 1st group copy it to blank column but in the ...
2
votes
1answer
10 views

Excel Autofill Linegraph with Time

I must admit that I am not the expert on excel, but I need help creating a graph with some data. In column A, I have over 500 cells filled with temperature values from a probe. Now, technically each ...
0
votes
0answers
10 views

To show data about one Excel file in another

An Excel sheet gets data from another, the source file, using DDE. How can I show, in a cell of the Excel sheet, the date/time when the source file was last amended or saved?
-3
votes
1answer
19 views

Obtaining Australian Population data from ABS [on hold]

I am having difficulty obtaining simple population data for Australia. I need the number of people in Australia by year from 1900 to present. 2013 is a suitably close year. Any information on how to ...
0
votes
0answers
11 views

One dynamic named range not staying dynamic while another in the workbook is

I am attempting to use dynamic named ranges to make it so I can pre-set the column portion of the print ranges in a workbook without assuming a number of rows. So I opened the name manager and ...
0
votes
0answers
12 views

Dynamic field names in Excel queries

As explained here, Excel queries accept dynamic values (e.g. "where name = ?" and "?" can be linked to a cell of your choice). Alas, Excel queries don't seem to accept dynamic field names (e.g. the ...
-1
votes
0answers
17 views

Excel 2013 autofill not working as expected [on hold]

I have a numbers in the first row. I multiply them with 2 in the second row by equation which was written in the first cell in the second row and drag it to the end of the row. the problem is the ...
0
votes
2answers
29 views

Excel formula to identify and group figures

I have two columns A and B In column A, I have figures in some currency say US Dollars. In column B, I have account codes to which the figures should be grouped. A B USd Codes 2,500 ...
0
votes
1answer
28 views

Excel 2013: moving X-Axis values to the middle of the columns

How could I move the X-Axis values to the middle of the columns? For example, the month values in the chart below (it's not my chart, it the state I want to reach) appear in the middle of the column. ...
1
vote
1answer
19 views

Column of text needs “summed” based on assigned value

On one sheet, I have a table with an employee name in column A and their associated rank in column B. On a separate sheet, I have a blank master schedule with all possible shifts in column B and days ...
0
votes
0answers
11 views

Outlines of merged cells not staying consistent when a filter is applied

I have a spreadsheet that uses merged cells for visual clarity. The merged cells are in the B column (dates), and in the A column there are various values. I use filters in column A, and in my other ...
0
votes
0answers
10 views

event-click sub in VBA for Excel

I have an ActiveX listbox on an Excel worksheet. Can I put the listbox click-event sub in a module? If I double click on the listbox in design mode, Excel wants to put the sub on the code sheet that ...
0
votes
2answers
40 views

How do you get excel to ignore zero or blank values in an Average?

I am making a spreadsheet to score recipe ingredients, averaging scores for quality of the ingredient, packaging, and accuracy of serving size, and then using that data to create an average for the ...
-2
votes
1answer
17 views

How to find the unique values in 2 columns of different sheets in which the values in each sheets were not in order [on hold]

I have two sheets with same data in columns(Lets say column A) but the data insdie the columns were misplaced, i just need to find the unique data in each column of two different sheet. Help me in ...
0
votes
1answer
22 views

How can I get a count of values for one column as compared to a second column?

I have a spreadsheet with a list of companies that submit data, the type of data they submit, and the date they submit. I need to a do a count of the number of times per day they submit, but only do ...
0
votes
2answers
23 views

How can I prevent changes to formula results after first use?

We have an Excel 2013 workbook that we use when we create new user accounts (column A for first name, column B for last name, column C for the password, etc.). First name Last name ...
0
votes
1answer
34 views

How can I search for a value that's repeated in excel?

I have a spreedsheet (Sheet2) that has 4 columns: ID | Name | Semester | SemesterAvg | Overall Avg | Period | 1 | John | 1 | 2.5 | 2.5 | 20132 | 1 | John | 2 | ...
0
votes
1answer
42 views

Creating Folders and Subfolders from excel cell values

Im trying to create a directory named after the value in column E within a directory (c:/Site Information), then create a further directory called the concatenated value of column A,B,C, and D. This ...
0
votes
1answer
21 views

Excel Month() function does not detect some date format

I have a simple table like this in excel: The formula i used was =IFERROR(IF(LEN(B3)>0,MONTH(B3),""),""). I check if a cell is blank by using LEN, if so ignore, else, convert it to month no. I ...
0
votes
1answer
31 views

How to weight data in excel? [on hold]

I am doing animal observations and recording the frequency of behavioral events during the observation period. Some observations are longer than others, and I don't want data from these observations ...
0
votes
1answer
20 views

PowerShell Excel search replace issue with loop

What I'm doing here is to search excel sheet for a value, if value matches it will be replaced by first value in a given text file: example: search for value text find the first instance replace ...
0
votes
1answer
29 views

Automate spreadsheet (Excel/CSV) workflow

I'm looking for a tool or process to help automate repetitive workflow tasks that require with an Excel or CSV file to be in a specific format. For example, we work with vendors that send us a list ...
1
vote
1answer
19 views

How do i right align an icon set arrow under conditional formatting so that both number and arrow are on right side of cell neatly together?

Cell displays a conditional format arrow Icon set which is on far left side of cell. The number in that cell is right aligned and I want to bring the arrow directly next to the number. I want the ...
1
vote
1answer
22 views

How to use a variable once, across the equation, in Excel 2007?

okay, is there a way to declare a variable inside a cell, without calling the cell name 3 times, across the equation(?)? I came up with this, to calculate the age from a DOB entered using the ...
0
votes
0answers
17 views

Compare and update two worksheets automatically [duplicate]

I wonder if it's possible to do the following in Excel: I have a spreadsheet that contains two worksheets. Sheet1 is a master sheet containing columns such as Customer Reference Number, Completion ...
0
votes
1answer
13 views

How to delete creating automatic back up file for MS Excel?

Every time I use a file Excel it generate an automatic back up file. How can I disable this feature? I use MS Office 2007 with Windows 7
0
votes
1answer
13 views

How to create a dynamic date title in excel 2010 using different tables and data

My friend has asked for help with an excel assignment and they have 2 tables, HRM and Data_Tables. Data_Tables has corresponding month numbers from 1-12 in column I from I3-I14. In J column there is ...
-1
votes
0answers
15 views

Add a cells content to another cell if cells at the top of the columns have only specific content

I already have a big part of this done thanks to another user, however I need it to go one step further please. I want to add the contents of cells in a specific row, based on a SUM formula. I want ...
0
votes
1answer
17 views

Excel Conditional Formatting greyed out

So I have a sheet open in Excel 2013. I have come to add some conditional formatting and cannot do so due to it being greyed out. My suspicion is that it is due to this [Group] thing. I know that ...
2
votes
0answers
34 views

align column with text and numbers [duplicate]

In Excel, I need to align on the decimal point a column of numbers that contains a mix of: numbers, and numbers followed by x's For example, the following data should be aligned as: 0.100 ...
-1
votes
0answers
18 views

Convert macro to save as Excel file and not PDF [closed]

Sub SaveAsPDF() Dim fName As String Dim StartRow As Integer Dim EndRow As Integer Dim a As Integer With ActiveSheet fName = .Range("AA17").Value & ".RG116.150420." ...
1
vote
1answer
17 views

Lining up sets of data in Excel (both with unique keys)

A related question asks how to line up two sets of data in Excel. I am struggling to figure out how to do this when you have values in both lists which don't exist in the other list. Ie: how would ...
2
votes
0answers
20 views

Taking an indirect reference in excel and making it a direct reference

For many somewhat complicated reasons -- it has to do with transposing columns and rows because of third party software limitations etc. -- I have had to use the indirect function in order to make ...
1
vote
2answers
29 views

In Excel, what is the appropriate function to use to find an item in a column that corresponds to an item in a column beside it?

Imagine that I have an Excel column ABC DEF GHI JKL MNO Then I have the following table option1 | ABC, DEF option2 | GHI, JKL, MNO option3 | PQR, STU .... (could be hundreds of comma separated ...
3
votes
1answer
35 views

Excel to count number of concurrent sessions based on start/end times

I have a massive set of data that I'm trying to work through. In Column A, I have a username, in Column B I have a session start date/time, in Column C I have the session end date/time. I am trying ...
2
votes
0answers
18 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...