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

Custom format that depends on cell value

I'd like to have some cells displayed according to the following rule (let x be cell value): x = 0 -> string "FLOOR" 0 < x < 1 -> percentage (e.g. "53%") x = 1 -> ...
1
vote
0answers
33 views

Excel: how to create multiple rows from one

I have many rows in a document in which I need to insert a certain subset of rows with others. In particular, I need one row for each month considered. If I have the row starting with July and ...
0
votes
0answers
34 views

vba macro - assign value of cell from another workbook to a variable

I have workbook that have this button. And I also have another workbook that contains some values. I have the code below to open the said workbook and then assign the value of some cell there to a ...
1
vote
2answers
35 views

Excel: combine multiple rows with

I work on a project, and I have to reformat a large data set of lab results. Now, each lab test is connected to the ID of a study participant - one row per test. I need to have the data reformatted so ...
0
votes
1answer
27 views

Shading groups of rows based on changing text values

I would like to alternate the shading of a group of rows each time the text value of a column changes. So all rows with "abc" in column B, will be shaded blue, when the value of column B changes to ...
2
votes
0answers
38 views

Excel “Smart” Dropdown / Data Validation

In Excel, is there a way to create a dropdown menu or data validation field that Allows the user to enter a value that is not currently on the list (like a combo box) Save that value in the dropdown ...
-1
votes
0answers
9 views

how do i use a command button so when I press it the information i have captures goes into a central store?

I have a rather large spreadsheet with 109 pieces of information that need to be captured. I've set this up as a scorecard - at the bottom I have created a button called submit (its a command ...
1
vote
0answers
17 views

How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel ...
-1
votes
2answers
49 views

Why does Excel allow me to select the same cell multiple times?

I was selecting cells in Excel, and accidentally selected a cell twice. With a cell selected twice I am no longer able to copy the selection, and I have to cancel the selection and do it again. Why ...
0
votes
0answers
28 views

Why won't this Excel workbook reopen after running VBA Shut down timer with no message box?

I used this shut down timer, but now have an issue with the Excel file not opening until I open another excel file -- then the first one opens. Private Sub Workbook_Open() StartTimer End Sub ...
3
votes
2answers
85 views

Can I customise the new Timeline slicer in Excel 2013?

Excel 2013 introduces timeline slicers for the first time. These allow you to filter pivot tables easily by selecting time ranges - either by year, quarter, month or day. It's nearly a useful tool, ...
0
votes
1answer
20 views

Timestamp Macro switched to different time source

I have a timestamp macro that gives the current date and time at the point in which it is ran. I also have two cells that show the Stock Exchange Date and time. I need the timestamp macro to return ...
0
votes
0answers
27 views

Formula to reference a cell but not update with that cell

My workbook has data that is automatically loaded in from yahoo finance. The data is constantly being refreshed. I need a formula that can take the referenced cell and produce the number value of that ...
0
votes
1answer
18 views

Excel positives values to red

i need custom text format to highlight positive values to red. I see that there is custom format for negative values in red, but i cant figure out what should i do to highlight positive values to red. ...
1
vote
1answer
27 views

Conditional formatting based on specific cells

Is it possible to set conditional formatting based on a value written in a specific cell? I would like to colour the rows of saturday and sunday and not colour the working days. The condition is ...
0
votes
1answer
16 views

How do i get a column not to show if there are no results in that particular columns

I am reviewing companies total capacity for 4 seperate risks, columns B-E, with cells A14-A46 being the list of companies being reviewed. If a company has a - in the cell for capacity for a risk, how ...
0
votes
0answers
25 views

Excel formula works on one sheet but not the other. Non-blank max number

I'm trying to calculate the max number between 2 non blank cells in column A, using the values in column B when B>C. There are no blanks in B:B. C is always blank unless C>B. ...
0
votes
0answers
7 views

How does SUMIFS relate to SUMPRODUCT

I am trying to sum up all the values between two points in time in a table. I wanted to use SUMIFS but it gives the wrong results. Using SUMPRODUCT with binary vectors works. Can somebody explain the ...
1
vote
1answer
36 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
16 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
18 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
17 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
29 views

copy column H from all files in directory into new .csv with Python

I have 50 spreadsheets in the same folder. I need to write column H from each of those files into a new .csv, and delete duplicates if possible. I've been able to get this far: import csv f = ...
1
vote
1answer
22 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
45 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
1answer
24 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
64 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
1answer
25 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
55 views

How to compare two columns and find a value excel

I want to reference this data |....A....|....B....|....C....| 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 Im going to add data ...
0
votes
2answers
61 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
1answer
36 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
42 views

Align rows from different columns (which contain some cells that have 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
32 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
17 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
4answers
94 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
11 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
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
1answer
43 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
32 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
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
1answer
44 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
32 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
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
2answers
65 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
1answer
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
1answer
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
1answer
48 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
0answers
31 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
50 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
41 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, ...