**0**

votes

**2**answers

15 views

### Checking whether a label exists between two other labels in a column

I have a column (call it A) in Excel lists off different items and their properties. Every item has the word "Type" associated with it and so there is a cell with that label in column A so that in ...

**-1**

votes

**1**answer

22 views

### Excel- SUM formula not working on IF formula converted data

In excel I used an if formula to change values to 1 or 0. This worked fine. I tried to sum the data from J2:J2103 but it always shows a zero for the total. I used auto sum and it showed the total to ...

**0**

votes

**1**answer

17 views

### Excel item value data to line graphs with labels

I have a data set like this:
Set Type x y
S1 A 1 24
S1 A 2 87
S1 A 3 33
S1 B 1 66
S1 B 2 11
S1 B 3 20
S1 C 1 79
S1 C ...

**0**

votes

**0**answers

19 views

### Excel Sort working differently on two computers, have same Excel 2010

I made a macro which relies on sort heavily due to time-constraints (has over 900,000 data points). The tool is working perfectly on my computer but when I sent it to someone and they tried to run it, ...

**0**

votes

**0**answers

15 views

### Looking up the row number of a shared identifier in Excel, and counting the number of cells in that row that meet specific criteria?

I have a sheet that contains a lookup value in columns. I want Excel to look for each value in another sheet, and count the number of instances of a certain word in the row in which it found that ...

**1**

vote

**1**answer

22 views

### Can I separate email id in spreadsheet based on domain in columns?

I have a list of 20000 email id which have emails from domains like gmail, ymail, gmx, hotmail, custom domains etc I have those list in a spreadsheet Column A. Can you help me separate them according ...

**1**

vote

**1**answer

9 views

### Powerpivot: how do I avoid measures from computing until I'm done entering multiple measures?

With Powerpivot, I have many measures (>25) to enter in a dataset that has millions of entries. When entering the DAX expressions for the measures, each time I enter one, Powerpivot takes a long time ...

**0**

votes

**0**answers

13 views

### Dynamic chart updates only when I let go of the scroll bar

I have done the usual scroll-bar to update the chart using dynamic name range. Now the problem is the chart only updates when I release the scroll bar. It does not update if I keep it pressed.
I can ...

**0**

votes

**2**answers

23 views

### how to check for a value in excel and populate column based on it

I have the following query :
My input table is
Basically I want to lookup columns for each ID.
Value3>Value2>Value1
If value3 and value column has data then ouput should show ID having value3
If ...

**0**

votes

**2**answers

34 views

### Excel Formula- Having a number automtically divide in half after 6 months

I'm tracking Transitional Housing in a Microsoft Excel- we pay a client's full rent for 6 months, and then half of that for the following 3. Is there a simple excel formula that can automatically half ...

**1**

vote

**2**answers

18 views

### Return a value given that a number is within a certain range

I'm looking for a little help on my scheduled withdrawals problem. I currently solve this with nested IF functions, but I'm getting more and more ranges and that leads to more and more nested IF ...

**0**

votes

**0**answers

12 views

### Expored XLS file opens the first time, can't be subsequently opened, even if it first opened in ReadOnly mode?

I have an application that exports a lot of various sets of data to Excel. One of our exportation routines is generating a very-basic Excel file. Our users have sent in a ticket claiming that when ...

**1**

vote

**1**answer

20 views

### Excel VBA to add cumulative total to new sheet

I am trying to create a workbook that creates a new page and puts the cumulative total from two cells to add to the new totals entered on the new page. I've been able to create a new page, but can't ...

**0**

votes

**1**answer

9 views

### Network resources being called when no connections are configured

Some users were reporting awful performance in Excel 2010 when doing simple things like clicking a cell or changing sheets for many workbooks they use.
I made sure there were no dead connections ...

**0**

votes

**1**answer

12 views

### Excel Data Validation List as Formula in “Source” Field?

I am using Excel 2007.
Is it possible to enter a short list of allowed values directly into the "Source" field in the Data Validation -->Settings Tab?
If I want to allow a cell to have one of two ...

**0**

votes

**1**answer

14 views

### Insert formula for each row in Excel or LibreOffice

I have the following data in LibreOffice:
As you can see there are 3 sets of measurement. I want to automatically feel in the D column with the following formula automatically. For example D2 will ...

**0**

votes

**1**answer

20 views

### Is there a formula I can use which when i drag automatically references +5 columns each time?

Trying to reference cells A1, then + 5 columns so F1, then + another 5 columns K1, and so on......
Is there a formula I can use which when i drag automatically references +5 columns each time?

**0**

votes

**1**answer

15 views

### Which function to use to copy data from above cell which has a value

i have below data .. and i'm not able to find a funtion by using i can copy data from above cell which in not empty
7091377 YO304RY 9110128192
9110148758
9110146133
...

**0**

votes

**1**answer

15 views

### How to Lock or password protected specific cell in excel 2010

How can I Lock a specific cell in a sheet of excel 2010 so that any one can not change or input anything in that cell?

**0**

votes

**0**answers

18 views

### excel formula required to clear many specified cells in different sheets on the same workbook -

i.e. on sheet 1 I want to instruct many different specific cells in other sheets in same workbook to clear text - so as i can rewrite into these cleared cells at a later time therefore cannot have ...

**0**

votes

**2**answers

34 views

### Excel - What's the best conditional formula when there are lots of conditions?

In Column A on my data set there are group identification numbers. They are integers ranging from 0 to 30.
In Column B is my data.
The groups form 10 cohorts, and the cohorts don't map onto the ...

**-1**

votes

**0**answers

16 views

### Excel 2010 macro that will search for multiple values in a very large worksheet, and then copy full rows into a new sheet when value is found?

I'm new here, so forgive me for the length and any rookie questions.
I have a very large worksheet, about 100k lines, filled A-AD.
Row 1 is header (I will need this in the new sheet, but can easily ...

**1**

vote

**1**answer

26 views

### Insert Filename Headers into Numerous XLSX files

I'm very new to the world of VBA, but I need a VBA script to insert the filename as a footer into Excel. Ideally, I would like to insert the first 7 characters of the filename into the footer of each ...

**0**

votes

**1**answer

20 views

### Add sum for records with duplicate titles

I have a spreadsheet with quantities that I needed added up for school names that are identical. Not all school names are identical and need to be added.
My data is 3000 rows long, below is a ...

**0**

votes

**1**answer

26 views

### Excel - creating a graph based on single column results

I'm using a mac with office 2011
I have a gender conlumn like so:
gender
------
male
male
male
male
female
male
male
male
male
female
and would like to get a graph that will show 20% females, ...

**1**

vote

**2**answers

27 views

### Appending Group Labels to Discrete Values in Excel

Is there a way in Excel to, after providing a list of groups and a column of discrete values, map a group label to each discrete value? How can I tell Excel to essentially check which group the value ...

**3**

votes

**0**answers

31 views

### Excel VBA SQL Query Handles Error

I am a beginner with VBA, but try. I have SQL that I can use in Excel 2013 to get the info from the Access database and it works using the SQL directly in a connection, but now I want to run it from ...

**0**

votes

**1**answer

31 views

### How to keep Excel line graph from incorporating dates that are not in my range

I have created a line graph based on dates and the values associated with those dates. However, it is inserting dates into a graph which I do not want. The dates run in chronological order, I only ...

**-4**

votes

**1**answer

34 views

### Need formula for basic IF statement

I am writing a basic scoring program for racing event. I need the excel function basically to make it as following pseudocode.
=If cell B1 =1, then cell C1=5

**0**

votes

**1**answer

18 views

### Compare to column in excel and return a value from corresponding third column to a new column

for example i have 3 column:
I whant the result in a new column as:
by comparing C with A return B

**-1**

votes

**2**answers

39 views

### formula to work percentage [on hold]

I am trying to find a formula that will perform a specific function.
I have two values, for example 15 and 50. 15 (b6) is the number of questions I have correct and 50 (c6) is the total number of ...

**0**

votes

**3**answers

49 views

### Need two excel windows side by side, on different monitors [duplicate]

Excel opens all workbooks in the same instance and as a result you cannot place them on different monitors (or side by side). You can extend one window across both screens and then split windows from ...

**0**

votes

**0**answers

19 views

### How to optimize Excel 2007 cell width for printing?

I have an Excel spreadsheet with 5 columns. Two columns have cells which contain very little text (e.g., dates or prices) while three columns have cells which can sometimes contain several rows of ...

**1**

vote

**0**answers

14 views

### Gantt Chart Template using dates

I am using the Gantt Chart Template and I have changed all the period numbers to dates and the plan start to dates as well. It works great until I change the periods to weekdays. It continues to ...

**0**

votes

**3**answers

44 views

### Excel auto fill a column with increment

I would like a column that increments by 1 each row, like this:
1
2
3
4
5
etc.
I would like to do this for 20,000 rows. What's the easiest way to auto-fill this column on Excel for OS X?
I can do ...

**1**

vote

**2**answers

31 views

### How to convert Excel file with multiple sheets to a set of CSV files?

I have an Excel file with 20 sheets on it. Is there a way to quickly convert the file into 20 CSV files - one for each sheet?
I can do it manually of course, but I'll have to be processing these ...

**0**

votes

**0**answers

21 views

### Custom sort selection

I would like to be able to sort a selection based on the order of another range somewhere in the same workbook. While I realize I could add custom list and then sort the selection based on this, this ...

**0**

votes

**0**answers

14 views

### Batch file can't find specified path when run from excel hyperlink

I have an excel file that has a list of IP addresses and I have linked a batch file that runs a simple ping test and outputs the results to a text log.
When I run the file from the network location ...

**0**

votes

**0**answers

14 views

### Get information from one worksheet and move it to another worksheet

Basically, I could do this manually, but I have a lot of information and it would take me a lot of time. I am trying to find the right formula.
I have 8 worksheets in Excel.
Details
Date ...

**2**

votes

**2**answers

104 views

### Combine Data in Multiple Rows into Single Row

I have a table with information about people (Name, HP No., Home No., Email etc). However, they are in different rows, and not all rows have all information.
How do I combine all information about ...

**0**

votes

**1**answer

20 views

### Date formatting from a derived/computed column

I have a column(A) in excel with data like "20141024X000000". First part before x is a date.
In another column(B) I want to format the date to become like "14-Oct-24"
What I did was use this function ...

**1**

vote

**0**answers

18 views

### Percentage increase between two data points - bar chart / Excel

Please forgive me but I simply do not know how to include these arrow lines displaying percentage increase/decrease between two points on a bar chart in excel. I wish to replicate what is showing in ...

**0**

votes

**0**answers

13 views

### Ideas on how to automate the export of cell values from 300 different excel workbooks

I have 300+ excel workbooks, containing some informaiton. I need to construct a dataset, containing information from each of the workbooks.
To clarify, let me give you an example:
-WB1.xls contains ...

**-1**

votes

**0**answers

11 views

### Why is Index and Match Formula showing incorrect value?

I am trying to pull some value from 2 combined column using this array formula.
{=INDEX($E$27:$E$35,MATCH(1,(H27=$B$27:$B$35)*(I27=$C$27:$C$35),0))}
The problem is the value shown is always ...

**0**

votes

**1**answer

21 views

### A chart where the line between points does not interpolate

I have an Excel spreadsheet showing the balance of a bank account over time. Each data-point is the balance of the account immediately after a transaction (so there might be several per day, with the ...

**0**

votes

**0**answers

8 views

### Highlight Track Changes

customize excel 2010 highlight track changes
The macro above thread doesn't have the option to undo. How to revise this?

**0**

votes

**0**answers

17 views

### Years on the X-axis on a Gantt chart created in Excel 2010

I'm trying to create a gantt chart in Excel 2010 but I have problems with the x-axis.
The chart shall show when 6 different steam engines were in service, at the workshop for revision between ...

**0**

votes

**1**answer

14 views

### Validating the “results” of the scrollbar in Excel

I have searched high and low, but found nowhere something that could help me.
Here is my problem:
I need to set a range of dates with two sliders. One slider sets the starting date of the examined ...

**1**

vote

**1**answer

71 views

### How to draw an excel chart from two columns?

Consider the following table:
1970 - 4705
1980 - 4771
1990 - 4998
2000 - 5181
2001 - 5195
2002 - 5205
The left number is x, the right is f(x). (The numbers are in separate excel columns)
I need to ...

**-1**

votes

**0**answers

17 views

### VBA macro doesn't work after reopening the Excel file

I have a sheet in my Excel where I made some "groups". I want to protect the sheet and still be able to open/close the groups (+/-). So therefore I have inserted this VBA code:
Private Sub ...