**1**

vote

**1**answer

31 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

23 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

**2**answers

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

**0**

votes

**2**answers

51 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

30 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

**1**answer

52 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

17 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

18 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

31 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

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

**0**

votes

**0**answers

13 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

29 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

19 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

39 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

18 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

22 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

26 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

22 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

36 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

21 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

23 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

20 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

29 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

24 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

16 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

19 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

24 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

64 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

33 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

14 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

11 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

84 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

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

11 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

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

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