**0**

votes

**0**answers

7 views

### Excel 2013: Convert row into two rows and edits both rows

I'd like to write (copy) a module that converts certain rows into two rows and edits the original row. For example, I'd like to convert this:
6/1/2015 16:25 1:00
to this:
6/1/2015 16:25 ...

**0**

votes

**0**answers

14 views

### XLXS file opens automatically when I pass my mouse over it

If I run my mouse over a Excel file *.xlxs it will start. I don't click the file just run my mouse over the file.
After that happens I can not open any Excel file as Excel comes back that ...

**0**

votes

**0**answers

5 views

### Where is the AD Bitlocker Recovery info found in Excel using Power Query?

I was wondering where do I find the Bitlocker Recovery information in Excel/Power Query if it's stored in Active Directory?
That is to say, what is the name and data type of the field, and what do I ...

**1**

vote

**0**answers

15 views

### Pivot Table column filters

I have a list of data with dates ranging from January 1, 2014 to November 25, 2015. I want to display columns from Nov 2014 to Oct 2015, whether they are empty or not.
Currently, I have filtered the ...

**1**

vote

**0**answers

8 views

### Data Validation - List - with the source of the list is in the raw data (has multiple copy of value)

I want to make a data validation in a list format in excel spreadsheet
But I don't want to make a new sheet or any new table to put the list source first...
I want to take a list source from one ...

**0**

votes

**1**answer

23 views

### Change save file format in VBA

I read this question: Can I split a spreadsheet into multiple files based on a column in Excel 2007?
I have a question regarding the "Save in same format as original workbook" that I hope you can ...

**0**

votes

**0**answers

11 views

### Simple user & project management tool without ticketing wanted

I'm looking for a simple and easy to use tool which allows me to set up projects with work-packages and users that are assigned to those. But - I don't want to deal with tickets, start/end dates or ...

**0**

votes

**1**answer

23 views

### Excel If Function With More Condition with Match Function

i had a problem with if function with more condition and match function. May i had Solution?
Currently I try using this array formula but cannot get any result.
...

**0**

votes

**1**answer

21 views

### Excel: how to add random decimals to numbers with a macro

I have a list of gps coordinates for a map that we need to randomize a bit as we cannot provide the exact addresses. I would like to shorten the original coordinates (that is the easy part as I just ...

**1**

vote

**3**answers

21 views

### How to identify horizontal tabs in Excel and replace it

I have thousands of data in my excel file, they are scraped data from various websites, initially stored in CSV files then migrated into Excel. This data is for use of my web server.
Now my problem ...

**0**

votes

**0**answers

19 views

### Why doesn't Excel auto-adjust formula when a row is moved?

I have a simple spreadsheet with just one formula, which auto-increments the number in the first column, going from cell A6 down. So the value in A6 is hard-coded 1, then A7 contains the formula ...

**0**

votes

**1**answer

25 views

### Count the numbers of matches between a row and a column in Excel

I have a data set in which I need to count the number of matches between any ID numbers in a column and equal ID numbers in a row. I have attached a data set example image and hopefully that will ...

**0**

votes

**1**answer

25 views

### How to search for two question marks(“??”) in Excel?

As the title suggests, I need to find and replace two consecutive question marks (??) in my Excel file.
I've tried the solution at: How to search for ? (question mark) in Excel . I tried with ~?? ...

**1**

vote

**1**answer

18 views

### PowerPivot option missing Excel 2010

After Windows updates installed on a PC and a reboot, for some reason now the Excel 2010 PowerPivot option is missing from the tab up top.
I looked over these two articles but neither helped resolve. ...

**0**

votes

**2**answers

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

**0**

votes

**0**answers

15 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

18 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

12 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

14 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

28 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

22 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

35 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

46 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

27 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

45 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

15 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

28 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

**1**answer

43 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

11 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

25 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

18 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

28 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

21 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

21 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

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

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

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