**0**

votes

**1**answer

6 views

### In Excel 2013 show cells as empty or blank until data is entered in other cells

What formula do I use to show Column C as blank until data is entered into Column B5,B6,B7, etc.? The formula I now have shows:
DATE AMOUNT PD BALANCE
8/14/2015 $572.82 $572.82
9/17/2015 ...

**0**

votes

**0**answers

11 views

### Create Round Robin Crosstable With Excel

I have a very large crosstable (120x120 at least) in Excel. The data is contains win or loss info. So, all data on row 5 and column E (which I label as column 5) contains data on the games the person ...

**0**

votes

**1**answer

16 views

### Excel VBA localisation issue - WIN 8.1 Enterprise, Excel 2007

I have a problem with file using VBA macros created in GER version of Excel. This macro is testing the pivot table item for "Alle", but when someone opens the file in EN version, the pivot table item ...

**0**

votes

**1**answer

6 views

### Error running macro after trying to run it from pesonal workbook

So I wrote a macro. The scenario of use is:
I open a fresh and new CSV file downloaded from somewhere
My macro runs and does some magic with the data
Since I don't want to copy-paste my macro to ...

**0**

votes

**1**answer

12 views

### Migrating Images from URL in excel

Reference to this discussion about migrating images from URL in excel How can I display a URL as an image in an excel cell?
The VBA code looks perfect and working, my question here is that how can i ...

**1**

vote

**1**answer

26 views

### Concatenating multiple characters with different formats in excel

I need to create a large series of multiple machine numbers with the following character formatting: Machine Number(first 4 digits)_Date(last 6 digits) as provided in the sample image below:
One ...

**0**

votes

**2**answers

18 views

### Excel : Merging Data sets

I want to merge two data sets (that each have two columns). Column A is a name, column B is a number in both data sets. Column A of both data sets will have several names that are identical, some will ...

**0**

votes

**1**answer

24 views

### Excel - For each unique ID, every time a particular column turns one, it needs to be cumulatively added

I have a big data set. What I want to happen is for each customer number occurrence, when the transaction type column has an entry CC or SO, it needs to be calculated as a donation. So for each ...

**1**

vote

**2**answers

43 views

### How would I track loan payments in Excel?

I'm going to lend someone money, using a standard amortization model. There are a billion (well, like six) templates in Excel to calculate the amortization schedule.
But this is for a loved one and I ...

**0**

votes

**0**answers

25 views

### Group data by second?

I have data that looks like:
No. Time Source Destination Protocol Length
1 0 192.168.6.132 192.168.6.149 RTPS 110
2 0.000008 192.168.6.132 192.168.154.1 RTPS 110
3 ...

**1**

vote

**0**answers

37 views

### How can I display hidden characters in Excel 2013?

Apparently in earlier versions of Excel, there was an option "Show Control Characters" which seems to be missing from 2013. Is there a way to display hidden characters in a worksheet?
I have a ...

**1**

vote

**1**answer

16 views

### Excel automatic “date changed” field for each column of data

I'm using Windows Excel 2007, if that matters, and I'm trying to have a date field update to today's date automatically only when a cell in that column gets changed.
I add new data entries per column ...

**0**

votes

**1**answer

25 views

### Convert a column B into a comma separated list , “ORDER BY” Colum A

trying start with VB in excel
just need understand how it works , this task can be done in SQL,
but I really want to know how can be easy done in excel
column A contains par numbers , column b models ...

**0**

votes

**0**answers

14 views

### Map 2 spreadsheets

I have two spreadsheet.
Both spredsheets have an email field. Spreadsheet 1 has 400 email fields and the other has 1000 email fields. The 400 emails are in the 1000 email spreadsheet. The 1000 email ...

**0**

votes

**1**answer

26 views

### how to run a macro on multiple worksheets

i want to run a macro on multiple worksheets. the sheets are named A,B,C...X,Y,Z. when i get to Z, then the sheets start of as AA,BB,CC...XX,YY,ZZ, then AAA,BBB,CCC...XXX,YYY,ZZZ and this repeats all ...

**0**

votes

**0**answers

28 views

### Inventory list in Excel

I'm posting this as a new question, because the first one I posted wasn't very clear.
I'm making an inventory list in Excel, combined with a giveaway/borrow list. There are 3 spreadsheets containing ...

**-1**

votes

**0**answers

14 views

### Excel 2013 VBA Macro , when any workbook is added or closed to the active workbook the Visibilty status of the application is effected [duplicate]

Excel 2013 VBA Macro , when any Workbook is added or closed from the Active workbook the Visibilty status of the application is effected i.e makes Application.visible true.
This causes the workbook ...

**0**

votes

**0**answers

10 views

### Excel 2013 VBA Macro when another workbook is opened and closed will leave the empty Excel Window

Excel 2013 VBA Macro,when another workbook is opened programmatically from active workbook, it will open in different excel window (due SDI behaviour).
When that workbook is closed from the active ...

**1**

vote

**2**answers

24 views

### Calculate the minimum starting from today (excel)

I am trying to get excel 2013 to display the minimum for a structured table but only from rows that are dated today or after.
The table is a standard structured table, and most of the formulas I have ...

**-1**

votes

**1**answer

16 views

### Excel List Lookup

I have two lists. I'm trying to write a formula, so that excel will look in one list to see if it can find any of the information in the other list, and if so, it will display X. So that if anyone of ...

**0**

votes

**1**answer

26 views

### Using VBA macro to copy and paste to a different sheet with 2 rows of header

I've taken a few programming classes in college but am a complete novice at excel (this is my very first excel program). My boss asked me to create an excel program to track pie orders.
The first ...

**0**

votes

**1**answer

17 views

### Excel Chart Axis Formatting

I want my axis on my charts to display numbers to the tenth. So instead of 2 or 3, I want the axis to read 2.0 and 3.0. Please help. I have already rummaged through the format setting and am lost.

**0**

votes

**0**answers

20 views

### How to change the x-axis values on Excel 2011 for Mac?

So I'm graphing sea levels during one month, that go up and down continuously.
Since I only wanted to plot the maximum and minimum points, I made a table with the hours as the x-axis and the sea ...

**0**

votes

**1**answer

19 views

### How to compare the Values in two different columns if the Values are same get the values

Column B has Values of customer Number (multiple times) till Row 1000 and column A has the sales orders information like below.
Column A Column B
ORDER1 KRISHNA
ORDER2 RAVI
...

**0**

votes

**0**answers

14 views

### Windows 7, office 13

I have successfully written macro for excel for indexing number in a cell for printing invoice/work orders. Problem is it doesn't remember where it stops and always starts back at 1. How do I slolve ...

**0**

votes

**0**answers

20 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

33 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

21 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

35 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

13 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

36 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

25 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

14 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

12 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

53 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

30 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

7 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

23 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