**1**

vote

**1**answer

16 views

### How do I match cells in one worksheet to another and print a result?

Not new to excel, but new to formulas. I have to say this is killing me.
So what I am trying to do is take strings in one column, check if any of them are in another column of a separate worksheet, ...

**-1**

votes

**4**answers

87 views

### How to capitalize the first letter in a cell in Excel

Recently i came across excel with cells filled with small cases,Is it there any easy way or macro to capitalize each word of the excel?
For E.g Consider the below image :
After conversion it ...

**0**

votes

**0**answers

10 views

### Show Pivot Table values as percentage of another Pivot Table's values

I have two pivot tables with identical axes to each other - a list of countries down and across either side. Each table has a count of different types of interactions between the countries as values, ...

**1**

vote

**1**answer

20 views

### How to sum values over timeperiod in Excel?

What is wrong with my SUMIFS? I would like to sum up all the values between two points in time. I have added a "Want" column to my screenshot to show what I am looking for.
The expression looks like ...

**-1**

votes

**1**answer

42 views

### Whats is the formula in Excel to display A2 if A1 =1

I need to display what is in cell A2 if A1 is 1. How do I do that?

**0**

votes

**0**answers

31 views

### How can i sort data with macro in different worksheet?

I use the following code for sorting a sheet in a workbook with a macro but when I open another workbook, it doesn't work.
How I can I change the code so it can run in another workbook as well using ...

**0**

votes

**0**answers

35 views

### Manipulating excel file from command line

I have written a Python script that generates an excel report file with some data. Then this file is automatically sent to a list of recipients. What I'd like to do though is to make the excel report ...

**0**

votes

**1**answer

43 views

### VLOOKUP where the column to look for is a drop down list?

I am doing a little format in which I call data from other cells, from other worksheet to fill it out. I am using VLOOKUP to do that.
So as an example I have:
Name: (Drop down list)
Sex
...

**0**

votes

**0**answers

30 views

### Excel performances: INDIRECT+ADDRESS VS CELL+OFFSET

Using Excel I can achieve the same result using two different approaches, here are the formulas:
A) =INDIRECT(ADDRESS(5+MATCH($A$16,Aliquote!$A$5:$A$15,0),1,1,1,"Aliquote"))
B) ...

**2**

votes

**1**answer

21 views

### Excel 365 Find and Replace modifies column formatting

I have a column in spreadsheet set to 'text' format that looks like this: xxxxxx057483245
I am attemtping to replace the x's with another series of numbers. 42424242 for example.
I go to find and ...

**0**

votes

**2**answers

64 views

### Generate list of duplicates in a column [closed]

I am trying to search a column of descriptions for duplicate items. The wording looks like so:
alpha b122
bravo b134
epsilon b122
sigma b134
I would like to search for the duplicate b### within ...

**0**

votes

**1**answer

29 views

### Win7 Cannot Delete File - File in Use [duplicate]

I have a file named Overview-2015.xlsx and no matter what I do, my computer keeps telling me the file is still in use.
Here's what I have tried:
COMPUTER RESTART - The only reason I could possibly ...

**0**

votes

**1**answer

34 views

### Excel IF statement from drop down menu gives error / wrong data type

I am trying to create an IF statement from a drop down menu where I have made the options Yes or No.
I have gone for: =IF(B2=''Yes'',D5,0). This is giving me an error.
However when I try: ...

**0**

votes

**1**answer

47 views

### Excel max number between 2 non-blank cells A, in column B (given no blanks in B) [closed]

I need to calculate the maximum number between 2 consecutive non-blank cells in A, but using the values in B. ie. use a formula in column C that will give me the results I manually plotted in D. ...

**0**

votes

**0**answers

27 views

### How to show the days of a month in a Excel bar chart

with the usage of http://www.smartsheet.com/blog/gantt-chart-excel I created the following Gantt chart
As you can see on the top there are some dates 3sept, 8sept etc. My question is if there is ...

**0**

votes

**1**answer

44 views

### VBA- Copy and paste error 1004

I was doing a code for vba and wondering why I received a runtime error 1004 when attempting to paste in sheets "Datasheet". It tells me the information cannot be pasted as the copy area and paste ...

**0**

votes

**1**answer

38 views

### If Column value = string then add row next to column to sum

I want to make an expense chart In Excel.
I have two Columns, one for type of expense and one for cost of expense.
I made a few categories where the types are summed. The types are Entertainment, ...

**0**

votes

**1**answer

49 views

### How to tell Excel to plot one column on x axis and another column on vertical axis?

I intend to plot y=cos(cX) in Excel, where c is a constant produced in first cell of column C using RANDBETWEEN(-50,50). Column 'A' represents X values (from -100 to 123) and column B contains f(x) ...

**0**

votes

**1**answer

18 views

### I want to compare 2 columns for corresponding data

Match is useful for number comparison but i want to compare letters, please advise.
please note that row number may not be matching data should match.
i got it for numbers =MATCH(B1,$A$1:$A$6,0)
but ...

**0**

votes

**0**answers

16 views

### Finding out total sales based on stocks traded within 90 days from a list of transactions

I have an excel sheet which is a list of stock transactions with the following details
Date,StockName,Transaction(Buy/Sell),Quantity,Rate,Total
I need to figure out a way to find 'sell' transactions ...

**0**

votes

**0**answers

22 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
I read this article but it involves other 2 helper ...

**0**

votes

**2**answers

34 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 them to create a list. Here is an example :
" I, Duroux-Richard et al. will thus explain how ...

**1**

vote

**1**answer

26 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

27 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

28 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

86 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

22 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

40 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

29 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

22 views

### Excel error when linking to Access table with calculated field [on hold]

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

48 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

24 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

19 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

23 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

14 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

39 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 ...

**-2**

votes

**0**answers

31 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**

vote

**3**answers

67 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 ...

**1**

vote

**3**answers

38 views

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

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

20 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

49 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

19 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

29 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

15 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

22 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

**1**answer

33 views

### Error in importing the numbers in scientific notation

I am importing(copy-paste) 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 ?
...

**1**

vote

**1**answer

22 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 ...