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)

1
vote
1answer
6 views

How to match cell value to sheet name then return value based on that

I would like to match cell value to sheet name then return value based on that. How can i do that? For example, there are 2 column (A and B) If the value in range A1:A5 = other sheet name Then ...
0
votes
1answer
8 views

Pull column data from one sheet to another, only when there is an X on first sheet

If I want to pull data from Cell 2 into another sheet when there is an X in Cell 1, but I want this to be true for the entire column, and then display it in another sheet, what is the best way to go ...
0
votes
0answers
8 views

Mode of text in excel

I have a spreedsheet with team numbers and some info about them (as text). Teams appear several time, and in a different sheet I have a summary for each team. I want to find the mode for one team. I ...
0
votes
0answers
2 views

Data Entry Form Button to Fill Next Blank Row in Multiple Sheets in Same Workbook (Excel)

I have made a form to enter data one time (Data Entry) and need a button that when pressed will perform the following: Copy "Data Entry A8" and paste it into next blank row of "Data C"; Copy "Data ...
0
votes
0answers
9 views

copy column H from multiple spreadsheets into new spreadsheet in Excel

I have 50 spreadsheets in the same folder. I need to copy column H from each of those spreadsheets and paste them into a new spreadsheet. Open to any answers using Linux or Windows.
1
vote
1answer
16 views

Split cell between specified characters in Excel

I have a cell containing: GB10_4.12.2014 I need to split into a new cell the number(s) to the right of the second character and to the left of the "_", which in this case is 10. Another cell ...
1
vote
1answer
22 views

How do I align two tables based on a unique column with Excel?

I have two tables in excel, the first is a complete list of products with some basic info, the other has only selected products in and more information about them, but is lacking some of the ...
0
votes
0answers
10 views

Automated weighted counts in a Pivot Table (Excel)

I have data for sales people who work with different clients. Sometimes the sales person has multiple deals with the same client. I want to be able to work out the count for each sales person for each ...
1
vote
1answer
19 views

MS Excel HyperLink a cell value to a corresponding cell with the same value

Lets say I have a Column of data, at the top of the column I have all my math calculations and I pull up important data points to the top of the sheet, such as (Max and Min data points based on a ...
0
votes
0answers
14 views

Complex coutif formula

I hava a dataset that on the headers has: (String Employee Name, String Day off, time Check-in, time Check-out). What I want to do is get a table that has row labels from Monday through Friday, and ...
-2
votes
0answers
11 views

How to compare two columns and find a value excel

I want to reference this data a: BB51 b:CD42 c:45 a: BB51 b:CD41 c:35 a: BB50 b:CD41 c:50 a: BB50 b:CD41 c:50 a: BB51 b:CD47 c:65 How do I search or match past data to find the value ...
0
votes
2answers
32 views

Excel Formula To Get LAST Non-Zero Value in Row and Return Column Header

I currently have a spreadsheet of transactions, and I want to write a formula that will help me extract from each row a customer's most recent transaction. Additionally, I want to then pull the ...
0
votes
0answers
13 views

Excel, pair 2 columns, then find all rows where column J is in two different Column D

SO I would like to have a formula or macro, to look at a table in Excel, pair two columns say J and M. Then find rows where M is connected to more then one value of Column J, Column J is Super Group, ...
1
vote
0answers
15 views

Align rows from different columns (that contain some cells with identical values) using simple formula in Excel

I have 2 tables in Excel and I am trying (via Excel formula) to match/align some rows (ones that contain identical letters for the sake of the example included below). Btw, I don't mind aligning Table ...
1
vote
1answer
22 views

How do I delete specific text in multiple cells at once?

I have a massive list of email addresses; but just to make things simple i am dealing with 3 - 10 email addresses that are typed up in 1 cell and i cant seem to MASS delete specific ones. Is there any ...
1
vote
1answer
11 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
3answers
44 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
0answers
4 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
1answer
19 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
1answer
38 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
0answers
25 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
0answers
29 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
1answer
34 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
0answers
20 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
1answer
17 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
2answers
41 views

Microsoft Excel 2010

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###' ...
0
votes
1answer
22 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
1answer
24 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
1answer
37 views

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

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
0answers
24 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
1answer
23 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
1answer
34 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
1answer
29 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
1answer
17 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
0answers
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
0answers
21 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
2answers
33 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
1answer
20 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
0answers
24 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
0answers
21 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
2answers
69 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
1answer
21 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
1answer
26 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
0answers
11 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
0answers
17 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
2answers
37 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
1answer
18 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
0answers
14 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
1answer
22 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
1answer
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 ...