A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

0
votes
3answers
5k views

Excel: how to count number of distinct values in a range with condition?

I read and tested quite a lot, but I still not able to come up with a solution for my problem. The close solution I found is the second one proposed in article below: Excel: how to count number of ...
4
votes
2answers
16k views

Add custom colors in Excel 2010

I'm working on a spreadsheet which was created in an earlier version of Excel (2003 I think), and it makes extensive use of color-coding for organization. Unfortunately, it was built using the ...
0
votes
2answers
1k views

Change the color of a line with the change of values of X coordinate

I'm drawing a simple line graph with 3 different lines in the same graph with Microsoft Excel. What I want to do is to change the value of each of this line with the change of X coordinate value. For ...
0
votes
1answer
3k views

Excel VBA Macro to Create Custom Lists From a Selection

Hi I was wondering if anyone could help me create a macro that will add a selection to excels custom List. Typically to do this I select a a series of rows in one column, then I got to file, options, ...
4
votes
1answer
74 views

How to break a list of numbers into parallel blocks

I've 480 numbers all in the one column of an Excel file. In the same file I want to divide these numbers into 60 columns each of 8 numbers: .. sequence... column 1-->1-8, column 2 --> 9-16, column ...
-1
votes
2answers
78 views

How to total an Excel Formula [closed]

I would like to sum a column with it rounding up and or down in the same cell. Can this be done?
-1
votes
3answers
3k views

Sum within date range (changing monthly)

I would like to have the sum for dates in an specific month. The problem (differs from other questions) is that certain orders take months to be finished, and when these finally are, they are posted ...
-1
votes
2answers
210 views

Combining multiple rows into one

From input as below: Last Name First Name Job Title Date Hired Description Field Name Value SSN/Fed ID AL V Assistant 12/08/2008 Driver License Expiration Date 2/23/16 364 AL V ...
1
vote
1answer
244 views

Map Page Up, Page Down and Num Lock just for Excel with Autohotkey

I would like to map these keys to the corresponding text: Page Up ( Page Down ) Num Lock = I want to do this with Autohotkey but I'm having a hard time figuring out the script. I also only want ...
4
votes
1answer
9k views

Multiple bar charts on one axis in excel

So I have a bunch of series laid out like this in excel: I'd like to have them plotted all on one column chart but with the series separated (i.e. not clustered) so it basically is several column ...
6
votes
2answers
6k views

How to disable keyboard shortcut animation in Office 2013?

I am looking for a way to disable the animations for keyboard shortcut selection in Office 2013, especially Excel 2013. When you select a keyboard shortcut using Alt and a key sequence (e.g. ...
1
vote
1answer
2k views

Excel - Finding all values in one column for unique values in another column

I have an Excel table that looks like this: Code | Description ------------------------- A | Desc1 A | Desc2 B | Desc3 C | Desc4 C | Desc5 C | Desc6 ... I need to find all the ...
1
vote
2answers
2k views

Matching tables with unsorted data

I am trying to match the data from one table to another. The primary table has two columns (an alpha item description in column A and a numeric value for that item in column B) in an unsorted order. ...
1
vote
2answers
975 views

How do I change the color of a cell based on whether the previous cells are blank in Excel?

I have a spreadsheet with names in column A. I'm keeping attendance by placing an "X" in each subsequent column when the person is present (week by week). I'd like for Excel to automatically change ...
3
votes
1answer
1k views

Need to paste a column from Excel into Powerpoint- how to paste so they are individual slides, not one

I have a column of 50 in excel 2003. I want to paste it into powerpoint but it continues to paste as 1 whole text box. I need 50 individual text boxes. Is this possible?
-3
votes
1answer
89 views

How to open files when the sources are in a column of another file

I have a large three-column Excel file: first column is "data (Excel file) name" second column is the "data source(of that Excel file's data)" and third column is "remarks" See large image ...
1
vote
3answers
115 views

Enhance display of positional encoding for debug purposes, perhaps using Excel one-character-per-cell

I have the following problem to solve: I work with positional-encoded files. These files show characters at certain positions in the string. Each row is a record, and the meaning of a character in a ...
0
votes
1answer
1k views

Excel SUM or COUNT based on related fields from two Tables

I have two tables in Excel The small table with 50 rows...tblGroups[#Headers]= Employee ID; Name; Group. The second table with 3000+ rows...tblData[#Headers]= EventID; Date; Employee ID; ...
4
votes
1answer
171 views

Formatting legend position in Excel?

I have a bar chart with four different data sets in Excel 2010 and made a nice little figure from it. However, I now want to format my chart's legend. The legend has four entries in list format with ...
0
votes
6answers
1k views

Excel how to count the number of same words/ strings in a excel file

I have an excel sheet with data in rows for example: aa aabbcc aa, aa aa aabbcc dd, dd ee So I am looking for an output like : aa = 4, aabbcc = 2 , dd=2, ee=1 .
0
votes
1answer
32 views

Questionnaire Restrictions in Excel

I have a 10 question questionnaire. I want to restrict the answer to one box chosen with an "X". I have already coded the "X" input restrictions via DATA VALIDATION. Now I need to restrict the # of ...
5
votes
1answer
14k views

In Excel, how do you auto fill until next value?

currently I have a column looks like this: A B ... 1 A 2 3 4 B 5 6 7 C 8 ... And I want to make it looks like this A B ... 1 A 2 A 3 A 4 B 5 B 6 B 7 C 8 C ... Is there a way to finish the ...
3
votes
2answers
2k views

Working with “~” in excel

I have a data set that has names that contain ~ within them. Unfortunately, I cannot find a way to filter or incorporate these cells in a formula. For example, I tried to use a text cell that had ~ ...
0
votes
0answers
49 views

Disable printing with Excel Viewer

I would like our team to be able to view a shared network excel file without the ability to easily print it. The ideal solution would be to install Excel Viewer on each machine and have it open the ...
0
votes
3answers
328 views

Convert time format 1w1d1h1m to number of hours in Excel

I have text in the format "1w1d1h1m" in an Excel workbook. Is there any way that Excel can convert this time format into number of hours?
-1
votes
4answers
138 views

Automatic sum function in Excel

I have three columns with 1500 rows in this form: Name codenb area X1 1 12 X2 1 8 X3 2 16 X5 3 2 X6 4 20 X7 5 5 ... ... .. Xn Anyone have an ...
2
votes
4answers
7k views

How to Unhide column A in Excel and Google Doc?

Let's say I hide column A in excel or in google doc, how can I unhide it (show column A again). Column A is the most left column. I have column B,C and D etc...
0
votes
1answer
280 views

Combine Excel worksheets despite adding new sheets

I have an Excel worksheet that works as template for a questionnaire. My aim was simply to copy the worksheet into a new one while preserving the formatting and other stuff, and I could then just fill ...
1
vote
1answer
710 views

Excel data doesn't update after data injection from an access db

Description of the situation: I have a access DB where I export data with the following command to an excel: DoCmd.TransferSpreadsheet The export works and the data is exported into an existing ...
0
votes
1answer
95 views

Conditional formating not working if formula includes text

=IF(ISBLANK(H10)," ",SUM(H10-TODAY()))&" days to ship" If I enter the above formula, the conditional formatting works fine. But when I enter any text, like "days to ship" in the formula the ...
0
votes
2answers
67 views

Why am I getting a “name error” with this IF formula?

I'm trying to use this formula to output "Tie" when the result is a draw: =IF(B6>C6,B6-C6,IF(C6>B6,C6-B6,”Tie”)) Instead of giving me what I want, it gives me a "name" error. What am I ...
1
vote
2answers
1k views

How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18, Using LibreOffice Calc Using ...
2
votes
2answers
8k views

How to do a “great circle” calculation in MS Excel or LibreOffice?

I got two columns with latitude and longitude values. I need to calculate the distance between the points in every row. I'm trying to use the haversine formula as seen here: That's the so called ...
0
votes
2answers
2k views

Excel 2007 Stacked Column Chart Display Subvalues

So I have the following set of values in my excel sheet: The values on the first column (very low, low, medium, high) are simply socio-economic layer indicators. As you can see, everything is ...
1
vote
2answers
121 views

Transform numbers into hyperlinks - Excel

I try copy different links from Firefox into Excel but links-numbers are formatted like text and not like hyperlinks. Paste links from Firefox into Word - numbers-links are recognized: Paste links ...
1
vote
1answer
2k views

Insert arithmetic series in excel

I'm making a budgeting for renting equipment at a shop. Their pricing is as follow. Day 1 costs 40 Day 2 costs day1+day1/2 Day 3 costs day2+day1/2 etc. I want to put this in excel but I have no ...
0
votes
0answers
408 views

Is it possible to save or print a website (google search) via MS Excel (vba coding) as a pdf?

Is it possible to save or print a website (google search) via MS Excel (vba coding) as a pdf? I have a set of data in which I want to do specific google searches on. Instead of manually doing this ...
1
vote
1answer
3k views

Convert latitude and longitude coordinates in excel

I have about 10,000 coordinates I need to convert. The coordinates are in this format: -116.6412722 34.7459017 -116.8066783 34.7734247 I need a way to convert them into this format, preferably in ...
0
votes
1answer
514 views

How to change preset values of a row by selecting from a dropdown list

I am pretty new to Excel but need to make an Excel sheet where I can select the item name so when the selected item changes so do all the values (price) of the column. Once this changes the value when ...
0
votes
0answers
34 views

I need help writing a macro that will check a condition, and then paste a value into a different cell [duplicate]

I want to have a macro that will check to see if a specific value exists in a data range, and if that value does exist in that data range, then I want to past a line of text in a different cell. Could ...
0
votes
2answers
71k views

How do you write an Excel formula that will paste a specific value in a different cell?

So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the ...
0
votes
2answers
61 views

Manually populate a Pivot Table

This is really a stupid question because I am supposed to know the answer. I have a data file that looks like this: Tech || Workdate || Fail || Manual Joe || 2013-05-23 || 6 || 1 Joe ...
4
votes
2answers
12k views

Multiple Y-axis labels in Excel 2010 line chart

I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
2
votes
1answer
80 views

Using a custom format to parse numeric strings

I want to know how to take numbers that are 12 digits long 123456789012 and have them display as 123 456 789 012. I apologize If that is explained in the Microsoft custom formats article but I ...
-1
votes
2answers
106 views

How can I avoid having the sheetname included in a formula

The question is best illustrated with an example. Say I have: Sheet1!A1=1; Sheet2!A1=2 I want a formula in Sheet1!A2 to be 2-1=1. If I enter the formula as normal with mouse clicks I would have ...
2
votes
1answer
714 views

Excel Conditional Formatting cell's value that has number suffix, like 99th, 23rd, or 1st

So I am filling a cell with Blue, Green, Yellow, or Red based on a Percentile Rank that is returned, that is numbers like ( >=90th=Blue, >=60th=Green, >=30th=Yellow, <30th=Red ) Currently ...
0
votes
2answers
1k views

Conditional format cells that are duplicated in every column

I have a table in which every column describes a product and every row is responsible for one attribute of the product. I want to highlight cells which are duplicated in every column. I have for ...
49
votes
7answers
381k 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 ...
0
votes
4answers
427 views

How to extract the exact digits 1234 from 1234:00:00 in Excel

I have a series of IDs that are represented in a column with the [h]:mm:ss format in excel. I want to extract the [h] portion that precedes the colon and have it stored as a number. The problem I run ...
0
votes
1answer
1k views

adding 'weight' to a value

I work in customer service center where we monitor calls and grade them. We have an excel sheet where we score these calls, and my question is, we want to give a greater weight fro 10 points an agent ...