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)

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
20 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
29 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
37 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
23 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
24 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
17 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
37 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
15 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
21 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
28 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
17 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
6 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
37 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
22 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
17 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
126 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
47 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
24 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
19 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 ...
-3
votes
0answers
25 views

How can I get Excel to auto-fill a column based on text entered in another column? [closed]

I am looking to Format a column of text in excel for example A ABC123 123DGF ABC124 NMO445 B Corp Acct Corp HR I want excel to notice the text entered in column A and then ...
1
vote
1answer
92 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 ...
2
votes
0answers
65 views

Different icons for different excel files

In my work, all coding can be done in VBA only - hence, all of our tools (dbase queries, data processing, cash overviews, etc) are written as xlsm files. At the moment, the number of different tools ...
0
votes
0answers
30 views

Excel Floating Column Chart with Gaps

Use Excel to plot multiple start/stop events for multiple days in one bar chart with all activity for each day represented on the same line of the chart for that day (bar chart with gaps) Desired ...
1
vote
1answer
30 views

Excel column headers export to csv

Just wandering how I can export excel files to csv while retaining the multicolumn headers? I realize that csv does not support this however, I'm hoping that I can have the header name duplicated for ...
0
votes
1answer
28 views

Grouping by date and time, with certain layout

I have a list of dates, every date has several timestamps, and every time stamp has a value. I have to rearange this data in a specific way. here's the data and below the way it should be arranged ...
2
votes
1answer
35 views

Delete text in excel cell with certain format

How do I easily delete strings in excel cells with certain formatting.I want to get cell with formatted string deleted like the second cell The string could be anything the only thing that define ...
0
votes
1answer
16 views

How can I use vlookup for one value and return multiple corresponding values in excel 2013

Could someone please help me understand what formula or what I can do to enter in one value and have all the values populated based off that one value. Below is the excel sheet I have. 261 201421 ...
1
vote
3answers
35 views

Extending a sheet with hidden/deleted last columns in Microsoft Excel

I inherited an Excel workbook from a colleague which left the company. Somehow, this colleague managed to hide or delete all columns to the right of a sheet. For instance, currently this worksheet ...
1
vote
2answers
30 views

How to convert a Excel row to a single csv text cell (inverse of "Text to Columns)

I have a POS program that allows me to import stock items from a csv file. The problem is that it only accepts a certain csv format. I have a Excel spreadsheet that saves my stock in different ...
1
vote
1answer
29 views

How to extract the last 7 number values in an alphanumeric string

I need to extract the last 7 number values (not characters) from a string in an excel cell. The string contains a file name (which can be a mixture of letters,numbers and a dash) and then 7 numbers ...
0
votes
1answer
9 views

I want a shortcut in Excel to cells I have Hyperlinked

I've built a Series of Cells which wnen concateneted = HyperLink to a remote server. Excel Wk Sheet 2010 (File name changes Daily with date function or Date User inputs) On the same Sheet I want to ...
0
votes
1answer
21 views

Embedded IF(OR(IF) statement

I have made a formula that basically looks for a string of text inside a cell and if it finds it puts it in another cell. I needed to check three cells so I did three separate formulas (because I'm ...
6
votes
2answers
186 views

OpenOffice Calc: reduce file size when saving as Excel

I'm working on a spreadsheet together with another person, sending new versions forth and back by email. It contains nothing fancy. While he uses Windows I'm on Ubuntu 12.04.4 LTS. The first version ...
1
vote
1answer
25 views

I am unable to open corrupt MS Excel file due [duplicate]

How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. ...
0
votes
0answers
23 views

When sorting in Excel, cells with images don't follow the sort results

I have created an Excel table and in the table I am able to filter the images with no problem with each pivot table. However, whenever I try to sort the data to organize alphabetically the images will ...
0
votes
1answer
26 views

Format text list with corresponding key into spreadsheet

I have a text file with dates arranged as such. name1 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name2 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name3 2011-01-05 (i) 2011-05-05 (i) 2011-06-14 ...
0
votes
1answer
25 views

What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
0
votes
1answer
25 views

Excel: portable formula to reference data on previous (relative) worksheet

I need to create a fairly simple Excel spreadsheet (workbook). I need 12 sheets (tabs), one for each month. Each sheet references cells in the previous sheet. For example, the "May" sheet is ...
0
votes
1answer
16 views

Moving content from one workbook to the another without opening it

I have excel sheet (1) in workbook A which update the DATA in designated cells when launch. I want cells content to appear in another excel sheet (1) of workbook B in NEXT row witout opening it. ...
0
votes
0answers
16 views

Convert COUNTIFS formula to SUM(IF) to enable external workbook references?

I need to convert the following formula to one that uses SUM(IF), as I am given a #value error when the external data source is closed. ...
0
votes
2answers
32 views

Concatenating columns in excel

Need some help in concatenating columns 1 and 2 as seen in screenshot. There will be further entries in column 2, perhaps 'Blue'. I would want '1 Blue' '2 Blue' '3 Blue', etc starting off from ...
0
votes
0answers
27 views

Excel 2013: Bug when creating custom date, converts all years after 2000 to?

Data is in US date format: mm/dd/yyyy, ranging from 1991 to 2011. If I try to convert into any custom format involving date, years after 2000 are converted to either 2014 or 2000. I think I must be ...