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
20 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
23 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
64 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
36 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
31 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
47 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 ...
0
votes
0answers
12 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 ...
-1
votes
0answers
33 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
17 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
22 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
20 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
37 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
58 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
31 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
18 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
39 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
40 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
35 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
8 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 ...
0
votes
0answers
15 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
29 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
21 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
33 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
38 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
27 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
24 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
16 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
26 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
19 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
40 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
16 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
14 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
26 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
29 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
19 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
8 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
25 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
38 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
23 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 ----- ...
-1
votes
1answer
23 views

Excel formula: identifying highest weights

I need some help with the following assignment: Task: In the product Weight tab, you can see each product is weighted with a value per customer. Please create a Product Code for each customer based ...
0
votes
2answers
19 views

Delete previous word in Excel

In almost any other application, Ctrl+Backspace deletes the previous word when editing text. In Excel 2013, it jumps the view to the active cell. Is there an alternate shortcut for "delete previous ...
1
vote
2answers
144 views

Excel: How to Superimpose 2 Stacked Column Charts

I have two stacked column charts (with no gaps between the columns) that have identical X- and Y-axes with same intervals. One graph is displayed in red, while the other graph is displayed in blue. ...
0
votes
1answer
24 views

IN EXCEL, how do you add 2 columns then blank one of the columns without effecting the balance?

inventory # EX col A -10 B 25 currently Question: If col A changes next month to -5, how can you blank out A-10, replace it with A-5, without effecting B. A - ...
0
votes
1answer
14 views

Excel column entries modification

I have a big Excel file containing a column where I have entries of the type A3F44 and I would like to transform them into A3F4 - 4 in order to match them with the entries in another file. ...
0
votes
2answers
51 views

Adding together values from multiple spreadsheets (VBA)

In my Excel workbook, I have three separate spreadsheets. The spreadsheets are identical in format and represent count values for different categories (passenger cars, trucks, etc.). I need to combine ...
0
votes
1answer
25 views

Using VLOOKUP in an IF Statement

Is it possible to use VLOOKUP in an if statement so that if VLOOKUP returns a certain value some action should be taken? I tried: =IF(VLOOKUP(A2,G$4:$H$147,0)<>0,1,0) and ...
0
votes
1answer
22 views

Excel: How to find a range, from a list of ranges, that a value is in?

I hope someone can answer my question! I have lots of values and need to know which ones lie within a list of ranges and if so which range do they lie in. For example: worksheet 1 contains my ...
0
votes
1answer
96 views

Insert text to the beginning of every Cell in a Column

I'm trying to find a way to insert text in to every Cell in a specific Column. e.g. Column C has 50 rows: I need to insert 0049 to the beginning of every Cell. I didn't had any luck finding/creating ...