**1**

vote

**0**answers

8 views

### Vertical line excel chart

How is possible to draw in MS Excel (starting from 2003) charts like this
Seems incredible that basic things like this be hard to do in Excel

**0**

votes

**2**answers

13 views

### Extract CAPITALIZED Words or words with numbers in it (Excel)

i have a database with articles and i want to extract capitalized words and words with number in it , to create a list , here is an example :
" I. Duroux-Richard et al. will thus explain how ...

**0**

votes

**0**answers

10 views

### How to show most common multiple data across values in excel

I have a worksheet like this.
Let's call the values in the orange box a recipe
and value selected (太刀・三日月宗近) is the result.
How to find most common recipe for (太刀・三日月宗近) result?
If there is exist ...

**0**

votes

**0**answers

14 views

### How to combine two sheets based on their dates?

I have two sheets: one is stock index, one is air pollution value. I want to match the air pollution value to each trading day. How can I do it on Excel?
the first sheet looks like:
01/01/1997 39
...

**0**

votes

**0**answers

16 views

### Excel pivot table with the categorical variables in multiple columns

My data consists of a series of registers (patients) with some properties (Age group, Sex) and the result of four observations of the same categorical variable (Healthy or Sick):
Subject_Id ...

**0**

votes

**2**answers

58 views

### In Excel, how can I check and output the list which are different between two columns?

Eg. I have List A and List B.
List A includes (1,2,3,4,5)
List B includes (6,2,3,4,0)
I want the output which are not in the list A: 6,0
Without returning error like in vlookup.
Thanks in advance! ...

**0**

votes

**1**answer

19 views

### Changing existing Excel data

I have a list of telephone numbers already in Excel. None of them have a 0 in front of them .I need to out a zero in front of them for my touch dialling phone system. Is it possible to create a rule ...

**0**

votes

**1**answer

19 views

### Function excel for split a cell, vlookup into a column and concatena

I've one range with the value in column 1 and I want to look for the cells in Column 2 if they are in the range of col 1. When they are in the range I want the function to give me the value is col 2 ...

**1**

vote

**0**answers

6 views

### Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time?
See the PivotTable below as well as the source data (both excerpts).
If it is in fact not possible to ...

**0**

votes

**0**answers

13 views

### Excel error when linking to Access table with calculated field

When I try to link to a table in Access which has a calculated field (with result type "Short text") from Excel, I get a connection error (as shown below, pretty generic error if you ask me).
Tried ...

**3**

votes

**2**answers

35 views

### Round cell values on end of edit in Excel

I want to build a worksheet that when numbers are entered into a cell and the user ends the edit on that cell they are automatically rounded to the nearest 0.25. I do not want to have two columns, one ...

**0**

votes

**1**answer

16 views

### Remove word(s) from a value derived from a formula

I have the following formula to pull in the name of a stock based on the given Ticker Symbol...
...

**0**

votes

**0**answers

12 views

### Which versions of MSExcel support the 'WEBSERVICE' function?

Pursuant to Excel formula to take out quotations ,
I saw that it's possible to use a form of web-querying in certain versions of MSExcel. Incidentally, what I saw was:
...

**0**

votes

**1**answer

20 views

### Generate string from table cells

I am using Excel 2008 for Mac. I would like to have a cell generate a string based on the contents of the other cells on the same row.
For example, say I have the following table headers:
bob, ...

**0**

votes

**1**answer

13 views

### Error: Text date with 2 digit year

For some reason the dates I enter into my Excel 2013 spreadsheet show up with "Error: Text date with 2 digit year" for other Excel user on another computer.
This breaks some formulas in my ...

**-1**

votes

**1**answer

34 views

### Formula issue Microsoft Excel

I need help urgently for a work problem.
So basically, the summation of opening stock and production give total stock.
While closing stock is ((opening stock+production)-sale)) and stock cover is ...

**-1**

votes

**0**answers

25 views

### Excel Sort multiple rows at once

How do I sort all the cells of each row in a worksheet?
I have 3 columns: Option 1 > Option 2 & Option 3;
Not all rows (60+) are sorted A, B, C
I can sort each row but due to the number of ...

**-1**

votes

**0**answers

22 views

### Macro in excel to manage more than one worksheet? [on hold]

I need to set a macro to manage the "footer elements" in many excel files, and each file has many worksheets.
I set the macro both with relatives reference and not, but I can view the modify only at ...

**1**

vote

**2**answers

39 views

### Need a batch script to copy data from A.csv to B.xls

I'm a newbie to batch scripting and need help.
I want to copy the contents of a csv file A.csv to the first worksheet named "GenData" in a existing XLS file B.xls.
B.xls contains some macros in it's ...

**0**

votes

**0**answers

20 views

### Save worksheet as a seperate file [on hold]

I would like to know if there is an option in Excel 2010 where you can save a specific worksheet in an Excel file into another file, without having to open the destination file. Thus without having to ...

**1**

vote

**3**answers

31 views

### Adding a space to the beginning of every cell in excel [on hold]

I have a column of data, and I would like to simply add a space to the beginning of each cell. How can I do this?
It should be like this:
Original:
1
2
3
4
After:
1
2
3
4

**0**

votes

**0**answers

19 views

### Summation series in Excel

I have been trying with no success to implement a summation formula in Excel
I want to perform a summation from n=1 to X [ xPn ] where P is permutation and X is a fixed number in a cell.

**2**

votes

**1**answer

43 views

### Excel formula to take out quotations

Does anyone know a way to get excel to not include quotations in a value?
I have the formula:
=WEBSERVICE("http://finance.yahoo.com/d/?s="&A3&"&f=p2")
so that I can pull the % ...

**0**

votes

**0**answers

16 views

### Merging all Data into one sheet with their respective sheet name in Excel

I have a excel file with near about 80 sheets. what i want is to merge in one sheet with their sheet name in column like this
Any Workaround for this task...?

**-3**

votes

**0**answers

16 views

### Preventing Multiple Letters to One Person in Mail Merge

I'd like to use Mail Merge in Word using an Excel sheet to send the following letter to people who have borrowed my gardening tools:
«GreetingLine»
My records indicate that you have borrowed a(n) ...

**0**

votes

**0**answers

10 views

### Regroup rows based on a column value

I have the following data:
Last Name | First Name | Division
Doe | Jane | A
Doe | John | B
Does | Michael | B
So, every user is assigned to a group. Now what I would ...

**0**

votes

**1**answer

17 views

### Excel changes typed formula

Why does excel change cell entrys
Example:
Initial entry +20+20
Next time I click on cell the contents of cell now is 40
It is not consistent on all cells

**0**

votes

**0**answers

14 views

### Excel 2010 key board shortcuts extremely slow [duplicate]

I'm using Excel 2010 and I'm getting some strange behaviour when i try to use the keyboard short cuts. For example if I type Alt-E-S to bring up the paste special window it can take anything up to 10 ...

**0**

votes

**0**answers

16 views

### Excel recover read-only edited file

I needed to edit a file which was sent to me as an attachment in email.
I opened Outlook and then opened the attachment in Excel. The Excel window appeared probably in read-only mode which I didn't ...

**0**

votes

**0**answers

12 views

### LWD, WTD and MTD Split

All,
I have a list of data and I would like to do a summary table that automatically calculates entries for the last working day, week to date and month to date. Sample below. So in my summary ...

**0**

votes

**0**answers

11 views

### Error in importing the numbers in scientific notation

I am importing values into Excel from R Console which are in scientific notation (1.920943e-10, 7.580894e-05). Excel is not treating them as numbers instead text. How to resolve this ?
Thanks

**1**

vote

**1**answer

20 views

### Dealing with absolute references in a conditional formatting macro

Say I have the following simple data in Excel:
A B C D E F G
2 1 3 2 5 4
2 4 2 1 3 2
5 2 1 3 2 4
I want to set up ...

**1**

vote

**0**answers

50 views

### Convert single row to multiple columns in excel

In Excel, how can I convert:
A 1
A 2
A 3
B 1
B 2
B 3
to:
A B
1 A 1 2 3
2 B 1 2 3
Where characters are in first column and numbers are in second column.
Any help would be ...

**1**

vote

**1**answer

21 views

### After pasting data, how do you navigate cell contents with keyboard arrow keys in MS Excel?

Using MS Excel 2010
I can copy ASCII plain text from a separate text document and paste the text into a cell (I first enter cell edit mode before pasting with Ctrl+V or Shift+Ins). After pasting, ...

**0**

votes

**1**answer

16 views

### How to transpose two cells data at a time from 2 cells to multiple rows

I have Excel data in the below format:
Excel Std Row: A B C D E F G H I J
1st Row Data: 1 1 2 2 4 4 5 5 6 6
Now I need output as below:
A B
...

**0**

votes

**1**answer

29 views

### Visual Basic and Excel data streaming in real time

I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch ...

**0**

votes

**0**answers

18 views

### All Data Option Filter Validation

I am creating a dashboard that has five inputs that filters my data by the custom data validation combination. My dashboard updates correctly based on the custom combinations, but I am unable to add a ...

**1**

vote

**1**answer

27 views

### Copying cells to another sheet and inserting rows for the copied cells

I am trying to create a sub that copies information from one form (which has four cells) to another sheet.
When it copies the information it also creates a new row.
Each form has a maximum of ten ...

**0**

votes

**1**answer

49 views

### What is need to improve percentage [on hold]

I work in a school and attendance is something we wish to focus upon. I would like to be able to calculate the following:
If a student's attendance falls below 90%, I would like to calculate in ...

**1**

vote

**1**answer

21 views

### Microsoft Excel 2013 Changing Date Automatically to current Date

I have an excel formula that I am using to automatically add the date to the cell next to the cell.
I use a drop down menu to select a value. Is there a way of then stopping this date from changing? ...

**1**

vote

**1**answer

39 views

### Finding Common word from two columns and returning value

I've two collumns in excel and I want to see if there is a common word(s) betweeen my cells, for instance:
Cell A1: 76A08, 26A65, 22A26, 2A01, 12A05
Cell B1 I've : 26A65, 22A26
In cell C1 the ...

**1**

vote

**2**answers

29 views

### Need to count the amount of times -1 appears above a certain cell

I have the following Excel Spreadsheet -
Hy Newcastle 042216 -1 Not Matched 1000
Hy Newcastle 042216 6461735 Khanyile;Florence Success 1000
Hy Newcastle ...

**0**

votes

**1**answer

15 views

### How to compare differences for multiple possible pairs of cells in Excel

In Excel, I have 7 columns of data (numbers) spanning 100 rows. For each row, I want to check whether at least one number exceeds all other values by a certain value (say 0.2 or greater). If so, the ...

**-1**

votes

**0**answers

21 views

### Copy paste to excel [on hold]

I am tring to copy from browser and paste to excel it is taking 7 min, can any one say what is the problem
The same if I am working with production url it is taking 1 min.
Please I don't want to use ...

**0**

votes

**1**answer

34 views

### How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...

**0**

votes

**0**answers

13 views

### Excel Solver - Can't set integer constraint on certain cell

I have a production programming exercise that I'm supposed to solve by using the Excel solver. However, I am not able to set an integer constraint on a certain cell that I need to be integer only.
I ...

**0**

votes

**0**answers

30 views

### Update Table based on Range start value and end value

I have a set of data that uses a primary key of month of the year by numerical value, e.x. Month 1, Month 3. I am trying to update my table and its values from the raw data set based on a user entered ...

**2**

votes

**1**answer

16 views

### Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function.
I also have a scatter plot where the selected data is like this:
=SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1)
I want to replace $F$4 in ...

**2**

votes

**3**answers

33 views

### How to convert integer column to time column?

I am trying to format an integer column to a time column, but the values all end up as 12 like this:
12
12
12

**1**

vote

**1**answer

24 views

### Is there a way to configure Currency or Accounting dropdown in Number Ribbon?

Is there any way to configure the list of currencies showed in the Ribbon (see screen shot)?
My most used currency, $, is not available in the default list and I can't found out how to modify this ...