Tagged Questions

Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
2answers
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
0answers
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
0answers
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
3answers
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
2answers
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
0answers
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
0answers
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
0answers
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
2answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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 ...