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

Excel: Subtotals by year value

I have a table in Excel-2013 containing some data similar to this: Year Month Electric Gas Water Monthly Totals 2012 Feb 115.49 40.15 82.13 202.70 2012 Mar ...
0
votes
1answer
13 views

Excel 2013 Averageifs

I want to calculate the average of time in a column of cells if the time falls within a range in another cell. E.g. If a patient comes in between say 6 and 8 pm I want to average data in another ...
2
votes
0answers
9 views

In Excel, Can I have two rows of (worksheet) tabs for my workbook?

I'm using Excel (2013). I have a workbook with numerous different worksheets, and would like to have them take up two rows of worksheet tabs rather than just one. Can I achieve this somehow? I can't ...
0
votes
0answers
9 views

New items in drop down validation menu aren't showing in Excel 2010

In Excel version 14.4.2, I have a drop down validation menu and I have added more cells with new menu items. However, these new items are not showing on the drop down menu on all the cells of the ...
0
votes
1answer
12 views

How to join neighbor cells in Excel

I have some data which I recorded in a bad way, see the picture : Now can I format this into something like this : Error 1 Error 2 (3.2 ± 1.97) E-04 (3.7 ± 1.3) E-03 (2.2 ± ...
0
votes
1answer
11 views

Chart not showing all data

I have created a very simple spreadsheet with data by half an hour for every day from Mon - Fri. I have then created a line chart and in the legend every day is shown, however the data for Monday is ...
0
votes
2answers
14 views

Excel Formating - How do I compare 2 cells and highlight one of them based on the date in 1 Col being further out then the date in the other?

I have a spreadsheet tracking multiple dates for about 150 people. I am having a problem however getting dates in Col I to highlight if they are going to be past the date in Col P. I want Col I Row ...
1
vote
0answers
9 views

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.?

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.??? I need to convert 16.329.932 back to 1.6329932. the table has a lot of values and all have changed ...
1
vote
0answers
22 views

How to recover some missing data in Excel?

I have two versions of an Excel file, one from before I did a lot of work on it and one from after. The after-version, despite a lot of productive work, also includes the results of a catastrophic ...
2
votes
2answers
15 views

How do I show only the print area in Excel and grey out the rest?

I'm trying to replicate an Excel spreadsheet that someone sent me and I can't figure out how. The print area is set, and all cells outside the print area are greyed out. The cells aren't simply ...
1
vote
2answers
21 views

How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be ...
0
votes
1answer
25 views

sumif(s), sumproduct for many to many relationship

I am looking for a formula/function that will allow me to essentially SUMIF(s) across a BOM. I know my part to FG relationship (Part, FG) and I know how many FG's I need(FG, Qty). How can I ...
1
vote
1answer
28 views

How to plot complex data as a radar chart in MS Excel?

I have some data from an experiment (which I did not design) that I'm supposed to analyze. After looking through the possible options for displaying the data to visually analyze, I believe that a ...
-1
votes
0answers
10 views

copy mixed font colors Excel

I have an Excel Document. 1 cell font colors are mixed. For example i have written in one cell < value > < struct > < member > < name> testName1 < / name > < value > 3 < / value ...
0
votes
0answers
10 views

Is the Excel “Last Modified” time adjusted to my timezone?

I'm looking at a Last Modified time stamp in an Excel Workbook: I got the spreadsheet from China, and I'm sitting in Denmark. These two countries are in two different time zones, and I would thus ...
0
votes
0answers
9 views

Using Query Function in Google Spreadsheet where {data, query, [headers]} is determined in another cell

For example in cell T2 contains the following text generated with the =CONCATENATE function DW004!$A$11:$H, "select H where (C contains """&$E2&""")", 0 This was created with the format ...
1
vote
0answers
10 views

Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone. Form example: 09:00 EST 06:00 PST Is there some sort of custom format ...
0
votes
0answers
20 views

Excel value of the digit or alphanumeric formula

How to convert a price or value of the digit which is taken as a formula to an alphanumeric? Example :p o l i c e m a n w x y 1 2 3 4 5 6 7 8 9 10 ...
0
votes
0answers
15 views

Make an Excel Graph Axis Show Two Time Zones

I have an Excel graph that displays the time of day in 24 hour HH:MM format. I need to also show the time with an offset for another timezone. How can I do this? I've attempted to use a custom ...
0
votes
2answers
30 views

Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...
1
vote
1answer
42 views

Excel: Different background colors on condition

The problem I have a Excel sheet that contains a status column. Number Status Name ------------------------------------- 1 not implemented feature 1 2 completed ...
1
vote
1answer
29 views

How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100). In cell G2 is criteria from column A. With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...
0
votes
1answer
14 views

Error outputting a string to cell

I am using a vba macro to automate part of an excel spreadsheet. The following line keeps giving me a runtime error 1004# application or object defined error Sheets("Material").Last.Offset(0, ...
0
votes
2answers
34 views

Pulling out data from a spreadsheet

I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made ...
1
vote
1answer
26 views

Excel custom auto-complete

I have a long list in a sheet in my Excel file: Number Value 123 Text 123 127 Another text 131 Yet another text ... ... On another sheet, I need to input those numbers. But as ...
0
votes
2answers
28 views

How to perform sql query on sheets of excel

I have two tables in excel(sheets) . One has 10,000 entries , another has 1000 entries . Both of them have account number column in common . I want to select only those row in 10,000 entries which ...
0
votes
0answers
7 views

How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...
-1
votes
0answers
39 views

EXCEL: How do i work out how many bike riders/skateboarders where male/female? [on hold]

I have four columns in an excel document that can be grouped into two sections; one showing whether survey respondents were skateboarders or bike riders and the other showing whether they were male or ...
0
votes
0answers
14 views

MS Excel: Send Data from PowerView to PowerPivot

I have an Excel workbook with two sheets: a PowerView sheet and a PowerPivot sheet. They both show the same data; the PowerView sheet shows data at a high level, and the PowerPivot allows users to ...
1
vote
2answers
17 views

Apply VLOOKUP to multiple sheets and ignore blanks

I would like to do a VLOOKUP on multiple sheets (for which I am able to define a strict priority order) but where I want to ignore the answer when it is a blank. I have found this answer: Apply ...
0
votes
1answer
15 views

Excel Table Row lookup

I need help in populating cell drop down, and table value lookup. Sample data in a worksheet. I have created a table and given it a name. Sample Data (Table Name: Products): Category Product ...
2
votes
1answer
28 views

Week of the month given week of the year

How would someone go about finding what week of the month a given week is knowing only what week of the year it is? I was going to try something like MOD(cell,4), but I know this will only yield an ...
0
votes
1answer
19 views

How to automatically delete rows that contain certain numbers in the ID column

I have a column of numbers in another workbook and I would like to use that set of numbers to delete rows in the main workbook. I will give an simplified example of what I'm talking about below. My ...
0
votes
2answers
23 views

VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter: Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String) Dim mlook As ...
1
vote
1answer
32 views

Windows 7 Excel 2010 annoying personal.xlsb message

I'm running Windows 7. Each time I run Excel I get this message popping up. Excel cannot open the file '~$PERSONAL.XSLB' because the file format or file extension is not valid. Verify that the ...
1
vote
1answer
19 views

Populate cell from table 1 from an auto-filled cell of table 2 with conditions

In Excel 2010, TAB1 and TAB2 are in the same worksheet. I want to populate Column D of TAB1 of an auto-filled Column E of TAB2 based on the values on Column C of TAB2. TAB1 looks like this: COLUMN ...
1
vote
1answer
23 views

Unwanted space in URLS in Excel 2010

I have a list of 23000 URLs in an Excel sheet but these appear to have extra spaces in, therefore invalidating the urls. I've tried a find and replace and excel doesn't recognise that there is an ...
1
vote
1answer
13 views

Excel formula for returning a specific weekday of a collection based on the cell referenced

I would like to use a formula to return the first day of a week for a date. I would also like Saturday to be considered as the 'first day' of a week in this formula. For example, B2 is 03/03/2014. B3 ...
1
vote
1answer
19 views

How do I allocate different text cells in a row a number and then sum total that row

I have a spreadsheet setup to monitor absence in the office. The columns are the days of the month 1 - 31 and rows are the month/employees Mon Tue Wed Thu Fri January 1 2 3 4 ...
0
votes
1answer
16 views

Drag down to change row letter, not number

Sorry for the confusing title, but I don't know how else to explain this. I'm trying to drag down this cell with the following formula: =COUNT(Tab1!B3:B32,"<>0") What I want is for the ...
0
votes
1answer
31 views

Lookup with multiple criteria and priority

I am working with different excel files which contain a lot of data from different people. I would like to do a lookup (I know how to use the LOOKUP function) but based on multiple criteria. Let me ...
0
votes
1answer
13 views

Deleting rows that contain a keyword in the column

I have an excel file that has a id as one of the columns, each id has multiple entries and follow a set of survey questions. I need to delete all of the rows that have that keyword (which is in a ...
0
votes
0answers
10 views

How to link quickly to various pdf files in Excel

I have an excel database with hundreds of products. Each products is assigned a specific security PDF sheet in a folder. Is there a way to optimize my linking routine? My way: Click insert - link - ...
0
votes
1answer
13 views

Using multiple data sources in a scatter graph

I have a script that runs something in a loop and writes its duration into a .csv file on a share. The file looks basically like this: "timestamp","duration","ComputerName" "7/8/2014 2:56:03 ...
0
votes
1answer
23 views

Microsoft Excel Custom Label Overlay on Line Graph

I have 2 tables identical. One records the progression of projects as a percentage over dates until completion. The other is a replica table but records the daily status of the projects on the ...
0
votes
0answers
14 views

Creating a quadrant graph with gradiented percentages in Excel

I'm trying to create a five-sectioned graph/diagram in the shape of a tongue (with front, back, left, right, middle) sections, in which each section represents a percentage, e.g. Front: 0.3 Back: 0.1 ...
0
votes
0answers
3 views

Excel 2013 - ActiveX ComboBox not accepting defined name

I have a worksheet that I'm reverse engineering to use for a project we have that is similiar. It contains ActiveX ComboBoxes that use a defined name, ComboData, to list the data within. I have ...
0
votes
1answer
23 views

Excel Formula Issue Countif to Sumproduct

Having a nightmare at the moment with some formula's I've been asked to 'fix'. It would seem the users expected them to work with closed source spreadsheets but they don't. So they end up having to ...
0
votes
2answers
31 views

Can I password protect Work Sheets in Excel

Can I password protect an Excel 2010 worksheet. I have an Excel file that contain 10 sheets according to locations. This file contains some MIS reports. The file is mailed to all locations daily and ...
-1
votes
0answers
21 views

comparing 2 columns in excel and return the same result in a group

hi m new in excel function, i have a problem like this. i have 2 lists of data DATA I NAME SCORE ----- ----- ANA 10 BUDI 20 TINA 30 DATA II NAME SCORE ----- ...