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

Generating Joint Density Function in Excel

Is it possible to have Excel calculate a joint density function based on two sets of descriptive statistics generated by the Data Analysis tool? To explain further, suppose I have two means a and b ...
-1
votes
0answers
16 views

Excel 2010: file is corrupted [duplicate]

error: Excel cannot open the file in .xlsx file might be corrupted or file format or extension is not valid please help me with this error i have tried unzip, repair,rename & recovery tool but ...
-2
votes
1answer
32 views

sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...
1
vote
1answer
30 views

Adjacent bar charts with different scalings

I have this chart created in Excel 2013: using this data: Last 4 Weeks Last 12 Months No. of Accounts 36 186 Net Revenue 149,562 ...
0
votes
1answer
24 views

Get result of formula as text

I have an Excel doc which populates a matrix using formula, for example; | A | B | C 1|=1+2 |=2+2 | 2| | |=4-1 would display as; | A | B | C 1|3 |4 | 2| ...
1
vote
2answers
26 views

Need to add missing iteration id numbers to a series in text or excel. How to get this done without coding?

I have a text, csv or excel file that looks like ||--ID-----||--Name--||--Date of birth--|| 1 Jo 1/1/11 32 Mo 2/2/12 3382 Ro 3/3/10 ...
1
vote
1answer
19 views

How to return the text left of line break

I have a Excel sheet, which contains a cell with this content: Text1: "abc" linebreak1 .... Text31: "mno" linebreak31 Text 32: ... linebreak32 ... Text50: "xyz" linebreak50 No I will ...
2
votes
1answer
32 views

Shortcut to move to next new content (Excel)

I'd like to know if there is a shortcut to move to and select the last cell in a row or coumn with the same content as the current cell. I.e. ctrl + arrow moves to the edge of the data array, but I'd ...
0
votes
1answer
24 views

Conditional formatting

What I am looking to do is have a conditional format set up so that if row G contains the value "In progress" "With 3rd Party" or "Identifying" and row H, J or K contain no value then highlight rows A ...
0
votes
0answers
28 views

Excel 2010, how to show percentage values on clustered columns chart?

I was looking for a better way to do this but no luck googling. My problem is about showing numeric values and percentage value in clustered column chart. When I use pie chart, there is an option to ...
0
votes
1answer
13 views

Average with Multiple criteria in same and different column

I have to find average number of days if status = new or open,severity= 4,area=Apps Demo table Area Severity Status Days Apps 4 new 20 Apps 3 open 10 Node 3 close 0 Device 2 new 25 ...
2
votes
4answers
246 views

Is there an efficient way to copy text from a PDF without the line breaks?

I need to get thousands of snippets of text from PDFs to a spreadsheet. They are short, seldom more than 2-3 rows, but each line break creates a new cell, and I have to repair that manually, which ...
0
votes
2answers
14 views

IF Function on excel - i need to put a formula into one cell using to < < however it isnt working

I need to put in one cell that IF the value of H3 and F3 is lower that 25000 but higher than 0 it will equal 29.95, if false 0 the formula =if(0
0
votes
1answer
26 views

Excel 2013: Drop down list with date range?

I'm trying to create a simple drop-down list in one cell where I give a range like end of each month from 2010 till 2015 to be selectable. How do I do that please?
0
votes
4answers
43 views

Countif in Excel with multiple criteria

I have an index for law and order conditions in many countries over several years. For each country I want to find out how many countries are ahead and how many countries are behind for a given year. ...
1
vote
1answer
15 views

Automatically update second worksheet when rows are deleted on the first worksheet

I have one worksheet with information and a second worksheet that uses formulas to determine values based on what is in the first spreadsheet. Is there any way that when I delete or add a row in the ...
0
votes
2answers
21 views

Formula on one sheet using indirect reference to contents of a cell on another sheet returning #VALUE

Excel 2010. Formula on Sheet1: =COUNTIF($D$9:INDIRECT($D$7),"qa") returns the count of cells that contain the text qa in range $D$9 through whichever cell is referenced in cell &D$7. However, ...
1
vote
1answer
27 views

Excel: create folder VBA script - get value from selected cell?

I am using a VBA code to create a new folder in a directory. What I want to do is get the new folder name from the selected cell. Any ideas how I can do this please? Here is the code I have so far. ...
1
vote
1answer
52 views

Excel Formula for a cell

I need a formula in excel, to copy and display a value from cell A1 to B1, if cell A1 value is changed from a positive value to zero, the value in cell B1 must not change, it must retain its previous ...
0
votes
1answer
26 views

Excel: Grouping and sorting rows

This is an example of the data I have: Country Score University a 5 1 2 3 b 7 ...
0
votes
1answer
34 views

Import number format from SAP in Microsoft Excel 2010

I would like to know if there is a method of extract 1234.00 from this comma separated number 1,234.00 which I imported from SAP. Excel does not recognise the format which this cell is formatted in, ...
0
votes
2answers
36 views

Subtracting TIME UNITS (not time of day)

How do I subtract TIME UNIT (not time of day)? Last year I ran a marathon in 48 minutes and 20 seconds. This year I ran a marathon in 47 minutes and 50 seconds. When I do this in Excel- I tried ...
0
votes
1answer
10 views

Excel Macro: Setting Character Range to Bold garbles text

What I want to do is the following: I have around ~1400 rows full of data, of which the last column contains a lot of text. Here's an image to show what I mean: image removed because I can only post 2 ...
0
votes
2answers
30 views

Excel: Percentages and ranges

I am attempting to make a bonus spreadsheet for work and am having some issues with the following. I am using this formula to determine 80, 90 and 100% ...
0
votes
1answer
59 views

Excel Formula: An Array formula containing VLOOKUP, SMALL, IF, OR

I am trying to create a formula that considers the data from three columns Y, H and V on my tab titled 'Data', returning the smallest value in A that meets that condition, once found Vlookup that ...
0
votes
1answer
29 views

Excel: Copying web table or saner way of merging cells?

I have an issue where copying information from a table in a web page to Excel doesn't copy the headers cleanly. The headers look something like this: # Line Part Part Description List ...
0
votes
0answers
24 views

Excel countif criteria to consider collored fields?

Is there a way for Excel's countif function to consider color of a cell in the criteria? Like if I have 10 cells, and 2 of them are yellow colored, the countif should only count the yellow ones. Or ...
-2
votes
0answers
23 views

Excel formula to copy text from another sheet in other cels

Hello I have this situation. In sheet 1 I have rows a1, b1, c1, d1 and pasting them to sheet2 (sh1)a1 into e8 then (sh1)b1 into e10 then (sh1)c1 to e12 and (sh1)d1 to d22. Then from sheet2 I wont to ...
1
vote
1answer
15 views

Count rows from table from date month and another text variable

I have a table that collects data based on date and area they live. So for statistics I need to be able to check the date they were added and the area they were in Example data page: + Name + ...
0
votes
1answer
16 views

Excel - shortcut to get me back after clicking a link

I have an Excel document that has more sheets and those sheets link to each other using textual hyperlinks (Insert Hyperlink > Place in This Document). When I click such hyperlink, it takes me to ...
8
votes
1answer
713 views

How do I stop the excel file being in use? [duplicate]

I'm opening an Excel file and I'm getting the File in use pop-up that says it's locked for editing by me. However, I've not got it open on this computer (I think I had it open and my machine ...
0
votes
2answers
41 views

How to sort columns in Excel so that only one value appears in each row?

Say I have a a spreadsheet with the following data: A B C D --------------------- 2 1 0 2 3 2 1 4 5 3 3 6 7 5 6 8 11 8 10 10 ...
0
votes
1answer
15 views

Excel autofill problems

I am an advanced novice at using excel and I have a problem. I am using 2 worksheets and want to refer cells from sheet1 to sheet2. In sheet1 (named "Aktuel") I have a list of all my costumers ...
0
votes
1answer
28 views

About the maximum number of arguments in Excel's STDEV function

According to Excel's Help Center you can only use the STDEV function for up to 255 arguments. 1 to 255 number arguments corresponding to a sample of a population. However, when I take the STDEV ...
1
vote
1answer
17 views

excel grid to columns

I have data in an array/grid like this: Name | Group | A1 | A2 | A3 name1 | Group1 | 14.95 | 19.95 | 0.00 name2 | Group2 | 4.95 | 9.95 | 12.95 name3 | Group2 | 49.95 | 0.00 | 0.00 And I need a way ...
3
votes
2answers
124 views

How can I merge two Excel spreadsheets with non matching column letters?

I have been using Excel for years to compile records of baseball gloves I have repaired. I was assembling an all time mega Excel spreadsheet, and found that in one of the templates I had made, I had ...
1
vote
1answer
28 views

Retrieve previous version (backup file) of Excel file?

I made some incorrect changes and clicked 'Save' in MS Excel. 'Undo' failed. Excel does not have an option to create backup files, like MS Word does. The AutoRecover option saves files in ...
1
vote
1answer
24 views

Transferring custom excel ribbons in local computer to other computers in Excel 2010

I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons. I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to ...
5
votes
5answers
367 views

Should I use MS Excel or MS Access? [closed]

I want to store my students' information such as marks, etc. And I need a way to make calculations on this information. I also want the application to make it easy to fill students' information (in ...
1
vote
1answer
27 views

How do I debug Excel / OpenOffice / LibreOffice macros - getting started

How do I get started with debugging VBA macros? This is to help to locate faults and mistakes within the code and the data it handles.
0
votes
1answer
49 views

Merging multiple excel files in to one file

This is my macro for merging all the files in one directory to one excel sheet. I am unable to find why its not working as per expectation. I have thousand rows in each file. It copies 1000 rows from ...
1
vote
3answers
42 views

Excel formulas for stripping out prefix/suffix around number

The other day I had some timesheet information in a spreadsheet ($X/hr, Y hrs), and I wanted to compute dollars spent. I wound up just editing out the "/hr", " hrs" and "$" characters, but is there a ...
0
votes
1answer
27 views

Excel 2013 wont let me save XLSX files

So, just recently when I tried to save an excel (.xlsx) file in Excel 2013, I got the following error message: I have not changed my file block settings in the trust center however. Here is a ...
2
votes
2answers
42 views

How to turn a data list into a reference table in Excel?

In Excel, I have the following (csv like extract): groupname origin destination speed winner client1 paris newyork 100 bob client1 paris tokyo 200 joe client1 paris ...
0
votes
1answer
21 views

Construction Quote Log

I'm reworking my company's log of the proposal's we send out. Trying to indicate the total dollars that we could conceivably be awarded. The challenge I'm having goes something like this: We are a ...
0
votes
0answers
5 views

Update data from external link

I have a dropdown menu to select a month and then all the sheet updates with the correct data. However, I have a few cells that don't update and I noticed that those are using data in a closed ...
0
votes
0answers
22 views

Excel: How to internally store a numerical value in a cell but make it appear differently (Ex. Alphabetical Names)?

For example, I want to name a cell "Win (+5)", but I want it to act like it just has "5" in it so I can use it for functions and etc,. I couldn't figure out how to do it.
1
vote
1answer
19 views

Using column data from another worksheet

I have a worksheet with one column and that has a list of my company names and what I want to do is be able to create a stats worksheet where I can use those company names without changing both ...
0
votes
1answer
29 views

Excel 2010 offset function returns #VALUE! error

I'm trying to use the offset function in excel 2010, but it gives me a #VALUE! error. The function works perfectly, if it's like this: ...
0
votes
2answers
31 views

Comparing dates in excel

How do I compare date in the following format with today's date and work out the no. of days in between? 31.12.2016 Formula: A1-Today() doesn't seem to work. It returns #VALUE!