**1**

vote

**1**answer

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

**1**

vote

**2**answers

96 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

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

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

**4**

votes

**2**answers

11k views

### How can I create a properly aligned curly brace that spans multiple rows or columns in Excel?

I would like to group a couple of columns or rows together and add a note to them. When I try that with normal letter-resizing, it gets ugly, misaligned to the rows, too bold and the centered text ...

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

**0**

votes

**2**answers

34 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

**1**answer

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

**-1**

votes

**2**answers

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

**1**

vote

**1**answer

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

**5**

votes

**5**answers

10k views

### How to tell if an Excel cell has a formula or is hardcoded?

Does anyone have a special tip (non-VBA strongly preferred) to tell systematically if a cell has a hardcoded value or is a derived formula?
Am dealing with some data that has messy subtotals embedded ...

**1**

vote

**2**answers

5k views

### How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel?

Usually I would just calculate the difference of each row like this: =B1-A1
Then I would sum up the values of the column like this =SUM(C1:C10) and get my desired value.
I don't want the C-column. ...

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

**1**

vote

**1**answer

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

**0**

votes

**1**answer

37 views

### Can I use a worksheet as a function in Excel?

I have a worksheet set up such that I can input a value, do some math to give me a bunch of values, repeat math a few times, and add up all the values and return an output value. It is complex enough ...

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

**18**

votes

**7**answers

132k views

### In Excel, how do I check if a cell is in a list of values (a range of cells)

I've got a range (A3:A10) that contains names, and I'd like to check if the contents of another cell (D1) matches one of the names in my list.
I've named the range A3:A10 'some_names', and I'd like ...

**2**

votes

**1**answer

4k views

### COUNTIFS over multiple worksheets

I am trying to make COUNTIFS go across two worksheets in the same excel file (Final Driver Forecast Model), just on different tabs. I need it to count if a driver returns between a certain time, then ...

**0**

votes

**2**answers

4k views

### Copy drop down list from excel 2007

How can i copy a entire drop down list from excel 2007 one document to another excel document, i have tried copying and pasting special, some forms told me to copy it through data validation process ...

**2**

votes

**0**answers

40 views

### How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook.
Is it possible to publish this workbook to ...

**0**

votes

**2**answers

2k views

### Complex rota hours calculation in excel

OK so there are a number of different shifts in operation here and I want a total hours formula.
problem is the rota is written using a number of different notations for different shifts
some are ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

601 views

### Excel macro to look up data from a database and copy it to another Excel file or sheet

I have an excel file which looks up and calculates data for a given date. It works as follows:
You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...

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

**2**answers

7k views

### Is it possible to create a broken X axis in Excel 2007?

I'm trying to find a solution to a problem that I have with my data.
In my data series, I have Temp over Time plotted on a scatter graph in excel. The data plots a period of around a week in the ...

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

**0**

votes

**1**answer

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

**5**

votes

**5**answers

9k views

### How can I convert a hex number to a decimal number in Excel?

I have a cell containing this value:
0x00006cd2c0306953
and I want to convert it to a number.
I tried:
=HEX2DEC(C8)
where C8 is the cell containing my hex value.
I get a #NUM error.
What am I ...

**3**

votes

**1**answer

76 views

### Match formula excel case sensitive

I have an if(iserror(match formula in excel. Just when I thought I was finished with my sheet I found out that the formula isn't case sensitive. Does anyone know how I can make my formula case ...

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

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

**0**

votes

**1**answer

6k views

### Excel vba code for adding a value to existing cell of sheet

i have this code to add value of a cell to existing value of other cell which is below
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not (Intersect(Target, Range("E3")) Is Nothing) ...

**1**

vote

**1**answer

5k views

### Automatic copy rows with matched column to other worksheet

Now I have a worksheet named sheet1 like the left side of image
I want to automatic copy all rows of sheet1 that have the column C = NO to worksheet sheet2 like the right side of image. And each ...

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

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

**2**answers

12k views

### How do I group rows in a spreadsheet and keep them together after sorting?

I have a spreadsheet with the information set up as such:
ORDER PLU/Recipe # Name/Desc Components
2 27905 CINNAMON CRUMB CAKE SQUARES
2.01 ...

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

**1**answer

18 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

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

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

**0**

votes

**0**answers

81 views

### Excel chart copying whole sheet into a new workbook - references to hidden rows are copied as absolute link

When in Excel 2013 I copy and rename whole sheet containing a chart into a new workbook, my references to series value ranges, axis labels etc., that have data in hidden rows, are not copied as ...

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

**1**answer

4k views

### Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2). My problem is the percent change from -4 to +4. A change ...

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

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

6k views

### MS Excel 2010 - Using DSN + 32 bit drivers

I need some advice as im running into a problem and so far i have been unable to find a solution.
We have a set of reports developed in MS Excel that use DSN file to connect to data sources to ...

**0**

votes

**2**answers

3k views

### Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...