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 "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
2answers
29 views

Excel: how to convert text to number?

I copied some table with products and prices from a web page to a Excel (2013) worksheet. Both the source table and my own Excel are configured with French number settings: a thousand euros and 20 ...
1
vote
1answer
29 views

Compare efficiency of excel formulas

Is there any way to directly compare for calculation efficiency side by side two different formulas for achieving the same goal in excel? Say I want to know which is more processor intensive (or if ...
0
votes
1answer
28 views

Insert pop out table into excel cell?

Is it possible to create a pop out table/dialog in a clickable cell in Excel 2010? I would then like the sum of the table to show up in the cell. Right now I am using a simple workaround, wherein I ...
0
votes
1answer
35 views

How do I set a dropdown in excel to populate different data in cells below based upon the option selected from the dropdown?

I am attempting to clean up a spreadsheet that we have that tells us what permissions to grant for certain roles in our ticketing system. I have used the Data Validation tool to create my dropdown ...
1
vote
1answer
41 views

Date range - month match formula

I need a formula to look at a date range i.e. start and end date within 1 calendar year and return yes or no if a named month (in a fixed rcell) falls within that range: ColA ColB ...
1
vote
1answer
33 views

Extracting a list of values from JSON file to Excel or a text file

I want to extract usernames from a JSON data file. [{"username": "Cobra", "user_id": 146231486, "event_type": 2, "title": null, "class_id": 4211, "war_state" : null, "superpower_expire_date": ...
0
votes
1answer
57 views

How can I pull specific rows in Excel into a new spreadsheet

I have several spreadsheets containing data I need to analyse. I have a randomized list of numbers that dictate which rows in each spreadsheet I need to code for my data sample. Is there a formula I ...
0
votes
0answers
21 views

How to format a cell to show years/months based on dividing one cell from another?

=IF(H7>11, INT(H7/G7) & "year" & IF(INT(H7/G7)<>1, "s", ""), "") & IF(MOD(H7,G7) > 0, IF(H7>11, ", ", "") & MOD(G7,H7) & " month" & IF(MOD(H7,G7)<>1, "s", ...
-1
votes
1answer
51 views

Return top 10 most frequently occurring values from an alphanumerical list in Excel

I have a list of postcodes and zipcodes – a series of alphanumerical values. I need to return the top 10 most frequently occurring postcodes from the list. Here's the data: ...
0
votes
2answers
90 views

Convert time over 60 seconds into minutes and seconds in Excel

In my spreadsheet, I have results to calculate the average of my result of endurance, which shows as: 2.71 min. But that is wrong to have 2 minutes and 71 seconds. How can I convert 2.71 minutes into ...
0
votes
0answers
30 views

Insert Excel spreadsheet data into ~200 Powerpoint slides [duplicate]

I have an excel spreadsheet for approximately 200 people in my residence hall at college. I am working on making their name tags. For their tags, I would like to have the decorations in powerpoint be ...
1
vote
1answer
37 views

Excel, Differences within Day for Multiple Dates

Im currently facing a problem trying to find variations in a Database as follows: > Date | Hour | Place 1 | Place 2 | Place 3 ... Place K (about 50) ...
0
votes
2answers
73 views

Determine week in fiscal year Excel

I am trying to get the 1st-53rd week of the fiscal year for the dataset ranging from 2/1/14-1/31/15. I am putting the first day of the fiscal year as a separate week. The =WEEKNUM() functions gives ...
-1
votes
0answers
16 views

Find Purchase qty>o with Index _ Match in excel 2003

Find Purchase qty>o with Index _ Match My questions: 1) Refer the table below - want to find Medicine names where Purchase Qty > 0 with the help of Index match function ( in excel 2003) I know the IF ...
-1
votes
1answer
43 views

Show value from every sixth column with a formula that can be filled down a column

I have two Excel sheets. On Sheet A, I have several columns of data, and the average of each column is in row 41. On Sheet B, I would like to have a column that shows the averages from Sheet A. The ...
0
votes
0answers
23 views

sum rows and columns depending on two values

I got the following table in Excel (Microsoft Excel 2011 for Mac). It is basically for controlling issues. It shows a number of persons (employees) that are assigned to specific work-packages that ...
3
votes
2answers
175 views

In Excel (or Numbers) what formula can calculate the amount of days in a certain month across 2 dates

If a guest arrived on 24th of August and left on 4th of September what is the formula(s) to calculate how many nights are spent in August, and how many nights are spent in September?
3
votes
2answers
59 views

Which delimiter allows major spreadsheet programs to open CSV files by double-clicking?

I'm writing an iOS 8 app that allows you to export data to be sent as an email attachment. Currently, I'm exporting the data to a CSV file with 7 columns and x number of rows. When I first created it, ...
0
votes
0answers
25 views

Excel formula Help: Calculate now in excel shows the correct result but the result displayed in cell is “#value!”

The formula I am using in Excel shows the correct result if I use the "calculate now" option. However, the result shown by calculate now is not displayed in the corresponding cell; instead it's ...
0
votes
2answers
29 views

Excel removing my last significance digit

I am building from external data a table where columns can have one or two decimal numbers. For one decimal number I want 1.0 instead of 1 and for two decimal numbers I want 1.40 instead of 1.4 The ...
0
votes
1answer
14 views

How to create header in MS Excel?

How to create header in MS Excel? So they will not move while I am scrolling the page and will not be affected when I am sorting any column. Till now I use: select row, go to View > Freeze Panes > ...
-2
votes
0answers
17 views

Find duplicates in two columns , my first column contain products like 48D26l,80D28L like

i have two columns one column contains products eg: 40B19L,48D28L etc i want to search whether that products are pressent in other column
0
votes
1answer
38 views

Excel - How to check if and in how many rows a certain value/string is present in range

I have a list A of strings and I want to see if and if yes in how many rows each string is represented in range B. My data looks something like this: List A: aaa bbb ccc Range B: 1 aaa --- --- ...
0
votes
2answers
58 views

How to compare two cells in excel and output the matched cell content in specific format?

I need a formula that can do the following: compare cell A2 with All of column B if found multiple matches, then copy matched results that contains contents of cell A2 and output it in Cell D in ...
0
votes
0answers
31 views

Lookup and return values from unsorted sheet

I have a workbook set up something like this: Sheet 1 has data for some people: name, address, height, favorite color, and many other things.  In sheet 2, I want to pull all of the data for each ...
0
votes
2answers
35 views

In Excel, I need to add a zero to the beginning of a number if it begins with 1, but not if it begins with 3

I have a list of numbers. Some begin with a 3 and don’t need to be changed; others begin with a 1 and require a zero added to the beginning. I have this formula that was supplied to add the zero: ...
1
vote
1answer
29 views

Excel - Vertical scroll columns A, B, C, D, E but F, G, H stay the same?

I know I can split at column F and each will scroll individually horizontally but I want them to independently scroll vertically. Is this possible? Here is a fiddle of an example of what I want in ...
0
votes
0answers
15 views

Save filter options, specifically on a Pivot table, without copying the table

I have a bunch of data summarized in a pivot table that gives me a list with multiple filters. Normally, at this point I would paste the whole list as values, before then selecting other filter ...
4
votes
1answer
373 views

Does Excel always calculate hidden rows?

If I have Excel sheets with long filtered lists, and I recalculate while a filter is applied, when I remove or change filters, can I always guarantee that Excel will have already calculated all hidden ...
0
votes
0answers
14 views

Excel 2007 Microsoft Action Pane 3

How do I install Microsoft Action Pane 3 on Microsoft Excel 2007? When I go to XML plugins, there is none on the list... I can add some manifest xml file, but where do I download it?
0
votes
0answers
33 views

Excel: Count duplicates only once, based on third criterion

So I got a excel sheet that lists (amongst other things) organizations and the year they were active in. Some organizations were active more than once a year. It looks like this: YEAR -- ...
1
vote
1answer
45 views

Excel - function for a number of matches

If a row or a column contains the cells with the similar data, is there a way to count them up in Excel? e.g. there are 4 cells in the range. I need a function to count how many of these 4 cells ...
0
votes
1answer
16 views

Making a pivot table month filter

I'm trying to compile some reports through an Excel pivot table connected to a MS SQL database. Now the data I'm working with consists of a bunch of dates formated as dd/mm/yy. I want to make a filter ...
0
votes
1answer
16 views

Putting certain values at the bottom of sort in excel

I have a table that counts the win percentage of players, looking like this: name games score percentage name1 6 3 50 name2 10 8 80 name3 2 2 100 ⋮ ...
1
vote
0answers
41 views

Can I make Excel keep a history count when a selection is made? [on hold]

I have a drop down list people (Data on Sheet#2) and I would like to keep a running total every time these people are selected under the drop down list for the type they were selected for. Example: ...
0
votes
1answer
21 views

How can I use vlookup function for multiple table array that has different length?

I need to import the minimum value form Column C to column B for each item, but the problem is that the table array is different for every item. Since I can't upload any image, I will just type the ...
0
votes
0answers
22 views

Excel vlookup in two access tables

What i want to do is use vlookup in Excel with data from two tables in Access. Vlookup will search for a first/last name field into both those tables and return info from them. I can't seem to find a ...
0
votes
2answers
67 views

UTF-8 File is not showing Chinese characters in Excel

I am creating a CSV file with UTF-8 encoding. It displays the Chinese characters properly if I open it using Notepad++. It displays the Chinese characters properly if I open it using Notepad. But, ...
0
votes
1answer
19 views

Adding Text to Existing Data in Excel

Is there a way in Excel to add text without spaces to the ending text of contents of a column. For example: I have 600 records and I want to add the letters OP directly after the contents of all ...
2
votes
1answer
38 views

In Excel 2013, Import Text Wizard, is there a way to have multiple “Other” values?

I am using Paste/Import Text Wizard to get some output from another program into a spreadsheet. There are several standard choices for delimiters such as space, comma, semicolon and tab. There is ...
1
vote
0answers
34 views

If Data Allready Exists In A Cell Overwrite It With New Data

I have an excel sheet with IDs beside cases. When I work the case and get a reply I want the excel spreadsheet to work out its the same case and update the original without adding a new case onto the ...
0
votes
2answers
29 views

Adding time in Excel, for a bus timetable

I am constructing a bus timetable. I am starting with a base time of 9am (Cell B2), with irregular intervals: 09:05-Cell B3 09:12-Cell B4 10:14-Cell B5 10:20-Cell B6 When the bus comes back to ...
1
vote
1answer
63 views

Excel: Count duplicates only once, based on other criteria

I need a formula that counts only unique values based on a third criteria. So I got a excel sheet that lists different organizations, the location they were active in, and the year they were active ...
0
votes
1answer
25 views

Excel search character range

Is it possible to use character classes ([A-C] or [abc]) instead of wildcards in the SEARCH function of excel? I want to do something like the following: =SEARCH("[AB]"; A1) This should result in ...
0
votes
1answer
43 views

How to convert row format data into column format? [duplicate]

For example the data looks like this: Name: A Number: 1 Type: X Name: B Number: 2 Type: Y Name: C Number: 3 Type: Z And I want to convert it into this format: Name Number Type A 1 ...
0
votes
0answers
45 views

Pass command line arguments to a program saved in file

I want to pass command line arguments to MS Office programs (Excel, Word, Powerpoint) like below, "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.exe" "c:\Book1.xlsx" /e/<arg1> To able ...
0
votes
1answer
24 views

How to filter data in Microsoft Excel?

I am filtering data using the method described here but it only hides the rows, it doesn't really filter them out. E.g.: if I type in a formula SUM(A1:A1000) I get the same result on the raw worksheet ...
0
votes
2answers
38 views

Excel spreadsheet with apostrophes causing problems

I received an excel spreadsheet with credit card numbers (CC number), dates, text etc. All of the numbers have an apostrophe ' in front of them. When I remove the apostrophe from the cc number it ...
1
vote
1answer
49 views

Switch Calc (or Excel) formulas to English language

I'm not using an American/English version of Calc/Excel so, every time I want to post here (or on other "web-places") or when I want to try formulas posted by others I need to "translate" them somehow ...
0
votes
1answer
15 views

Summing the above 7 rows in same column based on a value

I have a series of values that repeat like days of the week doing down in the same column. Monday : 2 Tuesday : 5 Wednesday: 6 Thursday : 1 Friday : 8 Saturday : 12 Sunday : 4 Monday : 3 ...