**1**

vote

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**4**answers

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

**0**answers

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

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

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

**0**answers

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

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

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

**0**answers

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

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

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

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

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

**0**answers

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

**1**answer

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

**1**answer

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