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)

1
vote
1answer
22 views

Align unique values in two columns in Excel

COL 1 COL 2 A E B G C A G A D C E F D F F F I want it to look like: COL 1 COL 2 A A BLANK A B BLANK C C D BLANK D ...
2
votes
1answer
19 views

IF and then condtional format

In Column C, I Want to rename the Column A Name in order of Date Of Birth, but only if a duplicate is found. Otherwise, the name in Column C should be the same as Column A. For example, there are ...
0
votes
1answer
24 views

Calculate the difference in hours from now and next workday's 9am

How do I calculate the difference in hours from now and the next workday's 9am? If NOW() is Thursday 6pm and the next workday is Friday, the function would then return 15. If NOW() is Friday 5pm and ...
-1
votes
1answer
20 views

How can I use 2 different sizes of the same font in one cell?

For instance, I want to list a person's name in one size font, and his graduation year ('14) in a smaller font.
0
votes
1answer
29 views

Copy Active Cell Comment in Excel into a new word file

i do not know much about Macros, is it possible someone could help me out. I have a simple excel file with names of Clients that have a lot of comments on each name. is there a fast way other than ...
1
vote
3answers
31 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
25 views

Excel- SUM formula not working on IF formula converted data [on hold]

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
20 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
32 views

Excel Sort working differently on two computers, have same Excel 2010 [on hold]

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
16 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
12 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
26 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
40 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
20 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
15 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
22 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
10 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
13 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
21 views

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

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
17 views

Which function to use to copy data from above cell which has a value [on hold]

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
16 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
36 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
28 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
33 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
53 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
34 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
22 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
106 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
21 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 ...