**1**

vote

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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
...