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
0answers
3 views

Obtaining Australian Population data from ABS

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
5 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
8 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
13 views

Excel 2013 autofill not working as expected

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
23 views

Excel formular 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
20 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 appear in the middle of the column. How could i do it?
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
10 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
9 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
35 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
16 views

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

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
19 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
20 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
32 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
35 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
20 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
18 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
23 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 ...
0
votes
0answers
15 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
12 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
14 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
31 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 [on hold]

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
13 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
16 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
27 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
17 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 ...
0
votes
2answers
35 views

Check if a cell contains any of words from a dynamic list

I want to use a formula to populate the "RESULTS" cells. I need it to check if the adjacent "CHECKED CELL" contains any of the words listed in the "KEYWORDS" cells. Ideally, I would be able to add ...
0
votes
0answers
6 views

How to save .xls file to tab-delimited(.txt) and specify Shift-JIS encoding

What I want to do is save .xls file to tab delimited .txt file with specifying SHIFT-JIS encoding. I tried specifying encoding in web options however when I save to tab delimited still japanese ...
0
votes
0answers
11 views

Using IF to compare name of a worksheet with worksheets in workbook

I have two files Main file and Result. Main file have multiple worksheet like delhi, moscow, paris, scotland and each one has same type of date and same heading ie.: S_No. , Vendor, VendorId, ...
-1
votes
0answers
14 views

Picking up data in excel with the date check

Let's say I have the following data: On the first row, there (mostly) will be dates in specific format. But sometimes there can be some texts as well. Now, I would like to get the average values ...
1
vote
1answer
26 views

I am trying to use the if function to look at cells to the left and leave the cell blank if they are blank or calculate if they are not

I am trying to use the if function to look at cells to the left and leave the cell blank if the reference cells are blank or calculate if they are not. for example I have E14 that im putting the ...
0
votes
1answer
25 views

Attendance Tracker - Deduct points if no points within pay period

I have a spreadsheet where I keep track of whether or not someone called in, was late or left early. On the 1st sheet I have their names, the number of times they've called in, were late or left ...
0
votes
2answers
51 views

How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)? Let's say the choices ...
0
votes
2answers
21 views

Locate Cells With a Simple Criteria

I have data like: I need to locate (get row numbers) for cells starting with the letter A.My current approach is to use a "helper" column. In B1 I enter: =IF(LEFT(A1)="A",1,"") and in B2 I ...
0
votes
0answers
27 views

How can I import multiple excel files into one master excel file? [duplicate]

I am trying to create a master excel file that would contain all relevant information from other excel files that are added to a directory. Specifically if I have an excel file of multiple workers who ...
0
votes
0answers
20 views

Is ther any other way apart of =Text(A2,“dd/MM/YYYY”) to get date in date format , having used any formula like lookup of concatenate [on hold]

Is ther any other way apart of =Text(A2,"dd/MM/YYYY") to get date in date format , having used any formula like concatenate
0
votes
2answers
35 views

How can i delete specific multiple rows in excel?

I have five sheets in one document. First sheet has the rows which contains values in first column. I need to delete all those rows from the rest of the sheets which has the same value in the first ...
-2
votes
1answer
22 views

Add a cell content to another cell if a different cell has a specific content

How can I fill a cells value (e.g row 29 col A) with =sum(B1:Z1) but then only add the content of a cell in that row 29 if row 4 of that column says "UK IR". That way I can add all the cells together ...
1
vote
0answers
22 views

Dynamic choice dataset Microsoft Excel

I'm currently setting up a database for my thesis, but the way I am working is not efficient enough. I have got two datafiles that I currently need to link manually, but that takes too much time. I ...
0
votes
1answer
10 views

Data Validation - Require a Custom Message Flash Up [closed]

I have deployed a drop down in A2 that require the user to select "Yes" or "No". As long as A2 is blank, that is no selection has been made, a particular cell (say A3) can remain blank, however as ...
0
votes
0answers
23 views

Windows 7 breaks appearance inside office documents (word, excel)

When I scroll the excel sheet, sometimes the ribbon and even the top bar are being covered by cells. The visualization is being broken. The same thing occurs with MS Word, too. The problem occurs even ...
1
vote
1answer
18 views

Sumifs function where I want to sum a range not just a single row or column

I am stuck. I am entering timesheet date into an excel sheet: Column A - Resource Name Column B - Project Phase Column C - Resource Team... Column D to AAA is a date Therefore a single resource could ...
-1
votes
0answers
24 views

msgbox doesn't display current value [closed]

I am wondering why don't the msgbox display a new appended value from a cell rather just the declared variable. I've declared a variable called "Newentry".I am adding a string value to a cell & ...