**2**

votes

**1**answer

24 views

### Pin line/arrow to bar-chart elements

I'd like to pin some lines in order to follow the movement of stacked 100% bar-chart elements. As you can see from the screenshot below
Right behavior
the arrow are more or less in the middle of ...

**0**

votes

**1**answer

12 views

### Different Excel notifications on opening very similar files

Template files were prepared and sent to users. The files are essentially identical (both have identical VBA code, the same passwords on VBA, sheets and workbook structure), but it's evident that one ...

**0**

votes

**1**answer

25 views

### How do I calculate the total busy time between several start-end dates

I have a table like this:
Event Start End
1 1/1/2015 10:00 1/1/2015 10:05
2 1/1/2015 10:02 1/1/2015 10:07
3 1/1/2015 10:10 1/1/2015 10:12
I want ...

**0**

votes

**0**answers

33 views

### Spreadsheet for binary calculation

I have to design some fomulars that operate with integer numbers only. Further the some masks have to been applied to the numbers. The most often required operation is calculating the next number the ...

**0**

votes

**0**answers

11 views

### How to combine multiple databases in excel into one strong and efficient database

I'm working in a highly reputed government company as a data entry clerk and my responsibility is to keep the contact information database updated by adding new contacts and making sure that all the ...

**0**

votes

**0**answers

14 views

### Code to Print List Loop to PDF

I have a spreadsheet that creates a graph and chart using a list selection. I have figured out the code to get the file to loop through the list and print each selection, however, I have not been able ...

**0**

votes

**0**answers

13 views

### Possible to have template folder that has referenced worksheets inside?

It's hard to explain what I'm trying to do, but I would like to create a folder template that would have a bunch of smaller Excel spreadsheets that are referenced to a larger, master copy that has a ...

**1**

vote

**1**answer

45 views

### Unknown symbol in an Excel spreadsheet cell

I use an Excel spreadsheet that I inherited as part of my job, and it has a feature that I'm curious about.
One of the data cells has a small right angle shape in the bottom-right corner, and I don't ...

**0**

votes

**1**answer

38 views

### How to use excel to evenly distribute groups with similar averages?

I'm working on a way to distribute caseloads to workers such that each individual worker does not exceed their caseload cap. I have eight workers: one has a cap of 125, and the rest have a cap of 250. ...

**1**

vote

**1**answer

64 views

### Excel, variable row index number in VLOOKUP

I am trying to make a model for a refrigeration cycle in excel with COPr as an output. For part of this I need lookup the entalpy which requires pressure AND temperature, so two inputs. I tried to do ...

**0**

votes

**0**answers

30 views

### Find text with multiple instances of character(s)

In this
you can see that there are two types of cells. One contains order with one pair or brackets and second one has two pairs of brackets.
For cell which has only one pair of brackets i use ...

**0**

votes

**2**answers

24 views

### Excel: Separate empty cells from having 0 value

I wanted to know if there is an option that doesn't allow empty number cells to obtain the 0 value when there is a function that takes values from these cells. For example, if I want to add the ...

**0**

votes

**1**answer

18 views

### Conditional information extraction

I have an issue extracting data from from cells.
As you can see here, I have two kinds of information:
In first cell you can see that I need to extract information from within brackets. For that ...

**-1**

votes

**1**answer

33 views

### How can I make this macro capture the lastest data?

I have a macro recorded and its working, sort of. The problem is that its capturing the absolute cell and not the dynamic cell. Let me explain.
I have an estimating page that I copy fixtures to. In ...

**1**

vote

**0**answers

28 views

### Stacked Line graph line colors do not match legend

I made an interactive chart that shows different data, depending on which ActiveX checkboxes are checked. I created a few tables that would show different data by using a few nested IF statements ...

**0**

votes

**0**answers

16 views

### Creation of Excel Sheet and Fetching Rows from that

I want to run several steps involving excel sheet through Windows Scheduler. Below are those :
Clear the data residing in the excel sheet ( sheet is located at some point)
Run a command through cmd ...

**0**

votes

**0**answers

18 views

### Conditional formatting of pivot table cells based on value of a separate field

I have a pivot table which has, for the purpose of this question, "document-ID" as a row label, "person" as a column label and "date signed" as value field. Is it possible to give each cell containing ...

**0**

votes

**0**answers

16 views

### Have Excel search CSV's and mark where he finds names

Sorry about the confusing question title, it's kinda confusing me to explain in the right way, so hopefully this text will do a better job with it.
My company has multiple CSV files pertaining the ...

**0**

votes

**0**answers

34 views

### How do I load external images into Excel cell comments?

How can I make a VBA macro to open an external image (i.e., local file, URL, etc.) in cell comments?
I am not a VBA expert, but have tried the solution proposed in other topic (How do I load external ...

**-1**

votes

**0**answers

13 views

### How to calculate change in purchase amount if the demand is satisfied 95% of the time in Excel?

I have a simulation for Easter egg ordering that uses random variables to generate 1000 possible demands given 5 order quantities 100,150, 200, 250, 300:
Optimal order quantity = 150
...

**0**

votes

**1**answer

33 views

### Calculating Median of a column for rows where 2 other columns match criteria

Unfortunately, excel doesn't allow for median calculation in pivot tables so I am trying to do something similar with a formula.
For my example, I have 5 columns of data (A-E).
My columns A & ...

**0**

votes

**1**answer

11 views

### Import table into Excel 2013 and format

I was sent 5 pages of a Microsoft Word table for my sister's wedding guest's. Each individual cell contains contains all the info for a card to send in the mail: Mr. and Mrs. John Doe, 1111 Address ...

**1**

vote

**1**answer

18 views

### Set a cell equal to another cell with a hyperlink

How do I set one cell's value equal to another cell? Ensuring hyperlinks, formatting, equations, etc. all transfer accordingly.
I know I can type "=" into cell A then click on cell B, but if cell B ...

**0**

votes

**1**answer

31 views

### excel macro - how to delete rows based on a cell value

I have the following spreadsheet
**Columns a-i**
A B C D E F **G** H I
**Row 1**
003 His Dressing 3305 S4S 0 0 **35** 35 1 ...

**-2**

votes

**0**answers

23 views

### Verify the date and modify if its in range

I have column with date (dd/mm/yyyy hh:mm:ss). I need to check if that date fall between a range of date, if yes then I need to add 1 hour to the time and modify that value and display it in the same ...

**1**

vote

**0**answers

19 views

### Hyperlinks in Excel 2013

I have an Excel 2013/Office 365 spreadsheet stored in a SharePoint Library. It contains hyperlinks created using the "Place In This Document" functionality - not a hyperlink formula. The links are all ...

**-2**

votes

**1**answer

25 views

### How to sum a column based on the value in another column

In the table provided I am trying to sum the values in the "2012" Column but only if the value in the Interview column equals Y. So the sum for 2012 should be 255 since the interview column is Y for ...

**0**

votes

**1**answer

16 views

### SumIF, while ignoring hidden rows and using extra criteria

My original formula is
=SUMIF($D$5:$D$250;"A";G$5:G$250)
which sums up all cells from G5:G250 that have a value of "A" in D5:D250.
Now I am going to hide a few rows and I want them to be excluded ...

**0**

votes

**0**answers

22 views

### Moving through large set of repeated values in Excel more efficiently

If one has repeated values in the dataset of a spreadsheet in Excel, that, when sorted, stacks nicely like sets e.g. in one column
A
A
A
B
B
C
C
C
C
Is there a shortcut to move to the first ...

**1**

vote

**0**answers

9 views

### Locked between MailChimp and European Windows for CSV export?

I have a CSV export for our application that is being used by end users (not tech-savvy).
For some European regional settings Excel expects a semicolon ; for delimiting (comma is used for decimals).
...

**-1**

votes

**0**answers

21 views

### Data Validation with if condition

I have a list of options in cell "B1" using data validation, however, i need it to auto-populate if A1 is selected with Monthly, else the drop down should remain the same.

**-1**

votes

**1**answer

21 views

### Need correct if function

I need help with below formula.
If the difference in dates mentioned in cell A1 & B1 is 60 days, we need Manager approval, if its 90 days we need Sr. Manager approval, if more than 90 days we ...

**-1**

votes

**1**answer

33 views

### How can I make the value of one cell change, based on the value of another cell?

I am writing an inventory list for my office, which is combined with a borrow list. What I want to do, is change the number of items in the inventory list, once an item has been borrowed. For ...

**0**

votes

**0**answers

16 views

### Combine data from multiple rows with same key into one row

I have a spreadsheet that contains an ordered list of data that I need to take the first record with the key and append additional records to the end of the first. Below is the source data structure.
...

**0**

votes

**0**answers

13 views

### Add series from multiple tabs to Excel 2013 PivotChart

Context: I need to produce a dynamic (based on Slicers) Resource Plan graphs for brainstorming business modeling workshop. The Resource Plan needs to present Resource Demand and Resource Capacity per ...

**0**

votes

**0**answers

10 views

### Compare 2 columns As in 2 separate sheets and if they match add column Bs from each sheet together

I have 2 separate sheets with 2 columns. I am looking to match Column A from both sheets and add the value of column B to each other and input the sums in a different column. looking for help.
...

**1**

vote

**0**answers

13 views

### Cell auto adjust height when pulling data from other cells?

I've built a spreadsheet with a summary report that auto formats fine, except in situations where the text in one cell and is too long to fit into a cell.
The report pulls info from cells under ...

**4**

votes

**2**answers

155 views

### Bizarre COUNTIF/COUNTA behavior in excel for counting text cells that are not “”

I have a column of cells filled with formula that give "" on error, and a text string if no error. In a second column I'm giving a formula with:
=COUNTIF(range,"<>")
as well as:
...

**-1**

votes

**1**answer

51 views

### Excel - Lookup value in column and return values from the same row

I was wondering if someone could help me with the following.
I have 2 spreadsheets in a workbook. From the table in sheet1, I would like to lookup everyone that's enrolled in the workshop "7 Habits ...

**0**

votes

**1**answer

21 views

### Counting words in a noncontinuous range in excel 2010

I need to count how many times a person's name appears in a noncontinuous range in excel. I used a formula on a different sheet that worked as it only looks at a column, but I need to look at ...

**0**

votes

**1**answer

12 views

### How to spread monthly values over biweekly pay periods in Excel

I have values each month of the year. They sum to 1.0.
O N D J F M A M J J A S
.05 .06 .20 .05 .05 .05 .05 .05 .18 .16 .05 .05
I want to spread these out proportionally over ...

**0**

votes

**1**answer

22 views

### Changing Excel Cell colours once a word/value in another cell is entered/changed

I currently have a spreadsheet with a list of deadline dates in row C and status updates in row E.
I need the cells in row C change to green once the words Complete/ Completed is written in any of ...

**0**

votes

**1**answer

30 views

### finding two adjacent cells using vlookup()

In preparing my data for an interpolation within an interval, I am using the MS Excel vlookup() function to find a pair of values that will define the interval for my interpolation.
The default ...

**0**

votes

**0**answers

18 views

### List of Events - Excel

Suppose a game involves rolling of 2 dice.
First Player rolls dice, the second player must roll the higher number (sum of dice), and then the first player must roll the higher number to stay in the ...

**0**

votes

**1**answer

20 views

### Excel Conditional Formatting for Date colums

I have 2 columns with dates and I want to apply conditional formatting to all values where the date in one column is bigger than the date in the other column.
So, when the dates in "Actual End ...

**0**

votes

**3**answers

56 views

### Excel mobile aggregate conversion of a code

I use this code
=INDEX(B:B,SMALL(IF(A2:A1000<1, ROW(A2:A1000)),RANDBETWEEN(1, COUNTIF(A2:A1000,"<1")))) to pick a random cell from the b column that doesnt have 100% set in the a column. This ...

**0**

votes

**0**answers

17 views

### How do I combine two pivot tables on a shared column in excel

I have two pivot tables that share a column of data. I would like to combine them so that the data attached to the shared column is lined up with the appropriate item in the shared column in one ...

**0**

votes

**0**answers

23 views

### How to auto fill the Data In corresponding columns of excel. Without the use of fill handel

Hi is there any other way we can fill up corresponding column automatically without use of fill Handel

**-3**

votes

**0**answers

52 views

### Use Excel IF and AND functions

I am trying to create a formula that returns a document # if certain condition are met. However using a range of cells in the condition results in the same answer being returned. What I really want is ...

**0**

votes

**1**answer

29 views

### How do I implement the VBA module to copy filtered data

I need to implement a VBA Macro that copies data from one excel worksheet and puts certain column into another one.
Sub sbCopyRangeToAnotherSheet()
'Method 1
Sheets("Sheet1").Range("A1:B10").Copy ...