**0**

votes

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**4**answers

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

**2**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**5**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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!