**0**

votes

**0**answers

21 views

### How to make 2 Excel sheets read each other and combined into 1 excel sheet

I have 2 Excel Sheets with gas card numbers and date stamps on 1 and another with date stamps and driver names. I need to know if there is a way to have the first sheet read the second and combined ...

**0**

votes

**1**answer

35 views

### How To Return the Three Letter Month Abbreviation of a Date in Excel 2010?

I've searched here and other site without being able to find a solution. I've been able to do this in the past but can't figure it out now. I have an Effective date in, lets just say cell B1. I want ...

**0**

votes

**1**answer

20 views

### Combining SUMIF and SUBTOTAL

I have looked at each of the other posts regarding combining these two functions, but I don't understand them enough to apply them to my specific task. I have to manually create an AR aging for a ...

**0**

votes

**0**answers

11 views

### Disable Excel Data Connections Properties

We have spreadsheets hooked up to our database through the network. The only thing is the data connection requires a login to the database by an administrator. We have other people that need to view ...

**-3**

votes

**0**answers

22 views

### Excel worksheet coding needed

I need help changing this code
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim int_range As Range
Set int_range = Intersect(Target, Range("B:B"))
If Not (int_range Is Nothing) Then
...

**0**

votes

**0**answers

19 views

### Including a variable within a formula

I use this formula to do a markdown of range of values in a column.
=RC[-1]*(1-(15%))
Can I assign this percentage value to a variable which can be changed by way of user input? How?

**0**

votes

**1**answer

36 views

### What causes Excel to raise an error about one or more formula references?

Upon saving my Excel sheet, I obtain following
error message:
We found a problem with one or more formula references in this worksheet.
Check that all the cell references, range names, ...

**0**

votes

**0**answers

14 views

### Excel 2013 - color rows where neighbouring rows have the same value

I have a spreadsheet that imports data from a SQL server. When the import is done it looks like this:
As you can see some of the data in row A is identical. What I need is make rows with the same ...

**0**

votes

**1**answer

38 views

### Why do I fail to set this range?

I am trying to define a range in VBA, but for some reason my method fails. In the code sample below, the two first lines work, but the last one fails with the message "Method 'Range' of object ...

**1**

vote

**0**answers

28 views

### Find duplicates, update database with minimum value in Excel

`Sub Update_data()
Dim Bk1 As Workbook
Dim Bk2 As Workbook
Dim Rng1 As Range
Workbooks("Book1").Activate 'indicate wb name1 here
Set Bk1 = ActiveWorkbook
Workbooks("Book2").Activate 'indicate ...

**0**

votes

**1**answer

23 views

### Excel Formula COUNTIF Issue

This is what I have for my D2 cell:
=COUNTIF(B1:B50="yes",=SUM(A2)-1),IF(OR(C1:C50,"yes",=SUM(A2)+1))
Basically what I'm trying to accomplish is this.
I have =SUM(A2) in my E2 cell for it's ...

**0**

votes

**1**answer

15 views

### Comparing two columns in excel?

If I have two columns
2 11
9 4
7 8
How can I get the number of times that column #1 value was bigger than column #2 (once in this case)?

**0**

votes

**0**answers

16 views

### How disable RefreshAll button in excel 2013

I want to hide the button Refresh All from the ribbon of Excel 2013 using VBA. It looks complicated. I tried to find code example.

**0**

votes

**1**answer

23 views

### How to format stacked bar chart correctly

I'm trying to make a stacked bar chart for some transactions made within the year. Ideally, the x-axis is month, the y-axis is amount, and the stacks (layers) are vendor name. But I can't get it ...

**0**

votes

**1**answer

22 views

### How to have excel show you what numbers are not 0 out in a single column

Excel 2010. I am reconciling bank statements with at least 3200 checks. I color checks that came thru bank and intersperse the checkbook in a single column . Then I go thru column to see what check ...

**0**

votes

**0**answers

60 views

### Excel - How to calculate percentage difference between two percentages

I have two columns, both percentages based on other calculations. I want to have a third column which shows the percentage difference between each of sets of figures.
So:
H128 is 9%
I128 is 9.84%
I ...

**0**

votes

**2**answers

32 views

### Converting a flat list into table in excel

How would I go about automating the conversion of a very long list in a format like this:
Into a table like this:
I am using Microsoft Excel 2010 on Windows... because of the layout of my data ...

**0**

votes

**0**answers

12 views

### excel 2013; using if function, punctuation in true statement shows up even when value is false

In Excel 2013, when using the if function, and when the value if true contains & and punctuation, punctuation shows up even when false.
i.e.:
(CONCATENATE("Actual ",TEXT(X13,"hhmm")," - ...

**0**

votes

**0**answers

10 views

### How to reconcile various fields in excel from different worksheets

I ran into a problem in trying to reconcile some data.
(Worksheet A)
Date
Reference No.(1)
Reference No. (2)
Amount Name
(Worksheet B)
Date Reference No.(1) Reference No. (2) Reference .No (3) ...

**1**

vote

**1**answer

83 views

### Find cumulative sum of values at a point in flow chart

I have a process that can be represented by this flow:
Each "M" point adds its own value to the flow and transfers cumulative values from point to point. The points, values, and flows are ...

**2**

votes

**1**answer

23 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

**0**answers

8 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

24 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

32 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

15 views

### How to split address by block, street name, unit number using excel [closed]

How to split address by block, street name, unit number using excel
8 Holland STREET 11 #12-34
block:8
street name:Holland STREET 11
unit number: #12-34

**0**

votes

**0**answers

10 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

13 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

43 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

37 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

62 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

23 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

22 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

17 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

26 views

### Microsoft Excel. How do I make a cell always multiply by a certain number regardless of what number is entered into that cell [closed]

How do I always make sure that the data entered into a cell is always multiplied by another cell.

**0**

votes

**0**answers

31 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

30 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

17 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

29 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

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