**0**

votes

**1**answer

6 views

### Excel Copy Formulas Horizontally

On Row 1, Column A I have =Sheet!1K2, on Column B I have =Sheet!1K3, Column C =Sheet!1K3 and so on.
On Row 2, Column A I Have =Sheet!1L2, on Column B I have =Sheet!1L3, Column C =Sheet!1L3 and so on.
...

**0**

votes

**1**answer

16 views

### How to find time difference between two rows of one column in excel sheet?

I have an excel sheet containing the Entry and Exit time for users from bio metric software. I want to find how much time the user had stayed i.e. sum of difference between entry and exit times, but ...

**1**

vote

**1**answer

26 views

### IF formula incorporating sequential answers

I am trying to write an IF-THEN formula that outputs sequential numbers (See the example at the bottom). If you need further clarification on the process, just let me know. Here is what I am trying to ...

**0**

votes

**1**answer

11 views

### Copy Full worksheet including multiple defined range names using macro or VBA

I've been trying to build a workbook for my company to use to track sales.
The problem I'm running into is that I want each user to have their own workbook saved on their local computer for their ...

**-2**

votes

**0**answers

25 views

### Excel 2010 formula?

I'm trying to set a formula to check a set of conditions over different cells.
Here is what I have tried so far, but obviously does not work
=IF(OR(L26<"today",K26="Y",J26="Y"),"Complete","not ...

**0**

votes

**2**answers

35 views

### Obscure DateTime Format

I have a document with dates of the form 2014-05-14T9:15:20. Unfortunately, Excel does not recognize this DateTime format. Is there a way to tell Excel to read this as a DateTime format without ...

**0**

votes

**2**answers

26 views

### Numbering Identical Items in A Column

Suppose I have multiple, repeating names as follows:
John
John
John
John
John
Tom
Tom
Tom
Tom
Tom
Tom
Anna
Anna
Anna
Anna
Anna
Anna
I would like to find a way to tell Excel: while the name is ...

**0**

votes

**0**answers

21 views

### Email Macro Assistance [on hold]

I am not experienced in writing VBA Macros & need assistance to create the following Macro. What I am working with is 25 rows of data in Excel where I need a macro written. The request is that the ...

**0**

votes

**1**answer

37 views

### How to find number rise within 1 hour in Excell?

I have numbers logged over the period of time. In one column, lets call it A there is a time in seconds from 0 to 10000, in the column B temperature logged accordingly to the time. Temperature usually ...

**0**

votes

**1**answer

26 views

### How do I create a table with multiple header rows

How can I create a table in Excel that has two or more headers rows. I want to keep the range as a table so I can use the built in tools such as re-sizing, totaling, formatting, etc...
I saw a ...

**1**

vote

**1**answer

23 views

### Referencing cell in workbook with variable name

I have a spreadsheet with a macro that creates a copy of a worksheet and names it with the current date. name of new worksheet is captured in first worksheet. How can I reference a cell in the second ...

**-1**

votes

**0**answers

26 views

### Sending values from one sheet to another sheet in Excel using Autohotkey

I have two sheets- sheet1 and sheet2. In sheet1 there are account no of the customers in column A and the name of customers in column B, as shown in sheet1 in the following example.
Now I want that ...

**0**

votes

**1**answer

30 views

### Excel-function IF

Column C calculates the earliest date from column A and B.
What would be the shortest function to display Row A1 or A2 in Column D as per the value of Column C?
Overhaul 1 Overhaul 2 Earliest due ...

**0**

votes

**2**answers

39 views

### How can I automatically fill a series in excel, based on the value of another cell?

How do I automatically change the length of a column with the numbers 0-n, where n = a number in a certain field?
I'm thinking of something like this:
EDIT:
Seems like I was bad at explaining ...

**0**

votes

**1**answer

21 views

### Excel formula for extracting numeric input

I have a column that contains a number starting 2007***. Counting down it changes.
I was wondering if there is a formula to take out the number and show it in as a separate column.
Cell ...

**1**

vote

**1**answer

19 views

### How do I copy rows based on single cell value in Google Sheets?

I have two sheets in Excel, which is duplicated on Google Sheets. Sheet 1 is a list of names with various bits of information for example
Name Number Outcome
Colin Smith ...

**1**

vote

**0**answers

13 views

### How to use Excel 2010 VBA to set series line color, marker fill, and marker line color

I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...

**0**

votes

**0**answers

18 views

### Excel chart tooltip does not display the value for data formatted with triple semicolon

I have two columns labelled Distance and Time.
Column E is Distance.
Column E is formatted General.
Column F is Time.
Column F is formatted ;;;.
This format effectively makes the cells appear ...

**1**

vote

**0**answers

16 views

### how to plot on 2 axis with 3 data sets

I have a graph about tracking investment value. It has 2 Y axis scales.
First data set displays fine (left Y axis scale)
Second data set displays fine (right Y axis scale)
However when I try to ...

**-2**

votes

**1**answer

24 views

### How to find address of last used cell in row for use in formula

I have a row of values in a range and need to subtract the value in the last cell in the row from the value of the first cell of the row. The challenge is that the last cell location is unknown, so ...

**1**

vote

**0**answers

15 views

### Calculated Fields Reference Error (#NAME?) on Pivot Table Refresh

I'm helping a colleague fix a spreadsheet with a similar issue as stated in this ozgrid post.
The problem: Pivot table with 31 calculated fields. Some calculated fields are calculations of the source ...

**-3**

votes

**2**answers

38 views

### How do I get Excel to look up customer names from another sheet?

I have two sheets in Excel i.e. sheet1 and sheet2.
In sheet1's column A there are account numbers of the customer and in column B there are names of the customers.
Now I want that in column A of ...

**1**

vote

**1**answer

23 views

### How can I compare two linked columns from one table with other two linked columns in another table?

I need some help on getting the proper formula for validating the following.
We have Customer list with Customer name, Customer number registered in our system, Customer number in another billing ...

**0**

votes

**0**answers

12 views

### Accessing locally stored external data

I have an excel file that has an external connection in it to a SQL server DB. The external data from the last refresh is stored in Excel somewhere as i can create new pivot tables from that data set ...

**3**

votes

**1**answer

114 views

### How to automatically colour cell background with value selected from custom dropdown list in MS Excel 2010

In MS Excel 2010 Professional is there a way to automatically copy the background colour of the custom dropdown values from somewhere else in a spreadsheet?
I have some Data Validation on a row of ...

**1**

vote

**1**answer

14 views

### Excel Stuck in Developer 'Design Mode'

We have a set of spreadsheets that contain scrollbars added in developer mode. Clicking these scrollbars changes a value and a diagram in the spreadsheet.
Suddenly these do not work. The mouse cursor ...

**-2**

votes

**0**answers

7 views

### macro to collect data from number of sheets to main page and need to add the sheet name that where the data collected

Please help me..,I need a macro to collect data(Student names) form number of Sheets(Class Name).all student names collected from sheet1, then a new column added with the sheet name (i mean ...

**0**

votes

**0**answers

27 views

### How can i convert .xls to .csv when change is made on csv file automatically? [on hold]

How can i batch convert A.Xls to A.Csv When change is made in A.xls, for example when add 1 record in to A.xls
Thanks

**0**

votes

**3**answers

75 views

### How to split numbers into columns with negative and positive values, without empty cells?

Given positive and negative values in column A of an Excel sheet, I want column B to list the positive values from column A, and column C to show the negative values, in the order in which they appear ...

**-2**

votes

**0**answers

28 views

### please make excel sheet [on hold]

Suppose you have two Excel Sheets as follows and it’s more than 1000 rows and you cannot do manually:
Sheet 1, Available List:
Area tower Br# Siza Rent Sale Height ...

**0**

votes

**1**answer

19 views

### Corrupted XLSX File

So, i was copying some files after work from one partition to another. I then accidentally deleted both partitions due to being really tired. I managed to get my files back using recovery software. ...

**0**

votes

**2**answers

25 views

### Calculating column values based on positive/negative values of another column in Excel

If I am typing randomly positive and negative values in column A in Excel sheet then I want when I type any positive value in column A then counting should start in column B and if I type any negative ...

**0**

votes

**0**answers

14 views

### Using Chart BeforeDoubleClick with a chart object in worksheet

I am trying to get a macro to work on a chart in a worksheet using the Chart.BeforeDoubleClick event.
I have been able to use BeforeDoubleClick event (without the use of class modules) in a ...

**-4**

votes

**0**answers

34 views

### Still trying to find a solution [duplicate]

I need to create an Excel spreadsheet for my sales quotes. On one Tab, I want to list all of the possible services the customer could buy from me. I would simply click a box or enter a Quantitiy ...

**4**

votes

**4**answers

153 views

### Comparing the first part of a string in Excel

I'm trying to create an automated function that will determine the class identification for IP addresses after you input it into Column A's input section by checking the first section of the address.
...

**1**

vote

**2**answers

99 views

### Can't click on ActiveX control in Excel 2010 Standard

I have a .xlsm file that has ActiveX control button with a module macro assigned to it. Problem is I can't click the ActiveX button from my Excel 2010 Standard. I tried to repair and reinstall Excel ...

**0**

votes

**2**answers

21 views

### MS Excel query on conditional summing

I have the following table:
Red: 4
Green: 3
Red: 6
If i want to make excel skip rows and only sum the reds (so red sum is 10) - which formula can I use?
Thanks for your help!

**-2**

votes

**1**answer

34 views

### Automate alignment of columns in CSV

I often work with CSV files, that other people will work with in a text editor. I want to have nice alignment of columns, e.g.:
Height, Age, Whatever
11, 12, 13
For large files, this is ...

**-1**

votes

**0**answers

19 views

### Track changes on the cell and return in a counter for every update [on hold]

I am looking at a typical scenario,
I would like to check if the contents in a specific range, eg B10:B50, is updated or changed then return 0, and for every change to return +1.
I am not getting ...

**0**

votes

**1**answer

14 views

### How To Autofill (Using VBA) Until Adjacent Cell Equals a Particular Value

I want to autofill a data validation list down in column E. However I want to stop the autofill when it reaches a particular value in an adjacent column (column B).
For example, I have 50 rows in ...

**0**

votes

**1**answer

22 views

### Adding Index to Match formula

I have the formula below working correctly, it is returning the max value in column G when the other conditions apply (valumes in B and F). However now I know what the Max number I want to return the ...

**0**

votes

**0**answers

8 views

### My image wont show up when I insert picture from file in Excel

I am trying to insert a picture into an excel spreadsheet.
I follow the normal procedures, but when it brings it into the excel sheet it either says "Image cannot be displayed" or shows up a clear ...

**0**

votes

**0**answers

12 views

### VBA to paste pipe delimited information [closed]

I have been stuck trying to write a macro to paste in copied data (from unix) that is pipe delimited into excel. Is there anyway to do this without going through the process of opening up the text ...

**1**

vote

**1**answer

14 views

### OR Statement for Advanced Filtering

I'm looking to find a way to filter two different columns. Normally I would just use the filter for this, but the catch is that after filtering by one item the second filter is not possible as none ...

**1**

vote

**1**answer

26 views

### Excel return a list of stringe where 'TRUE'

Ok so I have couple of cells listing warnings:
A B C
1 Warning1 TRUE
2 Warning2 FALSE
3 Warning3 TRUE
Now I want to return list of warnings that are set to ...

**0**

votes

**0**answers

24 views

### How do I fix the error “Excel connot open file (filename).xlsx”? [duplicate]

I have several excel files stored on my system. I used these files from the same computer daily. Yesterday, when i tried to open several files in Excel 2007 then i found following error on my computer ...

**-2**

votes

**0**answers

20 views

### Pull data from excel worksheet using VBA [closed]

I have a workbook with two sheets. Sheet 2 contains a "database" of info: first name and last name and a record ID assigned to them. Say it looks like this:
1 john doe
2 mary smith
3 ...

**0**

votes

**1**answer

20 views

### Is there a way to include “workbook” event functions in my personal macros file?

e.g.
Private Sub Workbook_AfterSave(ByVal Success As Boolean)
Beep
End Sub
This only works in "ThisWorkbook," and only in 1 spreadsheet at a time, not in my personal.xlsb file.
(Inspired from ...

**0**

votes

**0**answers

27 views

### Excel 2013 crashes when saving instead of showing a pop up message “Some links could not be updated”

I need to prevent an Excel file from crashing and get a popup message instead. How can I do this? Below is the scenario:
Excel 2013 crashes, when saving, instead of showing a pop up message "Some ...

**1**

vote

**0**answers

22 views

### Can I run a VBA function whenever excel calculates, even when I don't click F9?

This is a followup question to this one: Can I make Excel beep when a calculation is finished?
The answer relies on me pressing F9.
However, even with calculations on manual, sometimes calculations ...