**-1**

votes

**1**answer

22 views

### How to extract numbers from duplicates and text

I have a set of data as below:
23
23
23
23
23
False
False
False
False
False
10
10
10
10
10
False
False
False
False
False
False
30
30
30
30
30
30
False
False
...
Which formula can I use to only ...

**0**

votes

**0**answers

26 views

### Filter Unique values in Columns or Cell Ranges from Multiple Worksheets in an Excel Workbook? [closed]

Excel 2010: Filter Unique values from Columns or Cell Ranges from Multiple Worksheets in a workbook?
Essentially, combining data from the 3 cell ranges/ columns in multiple worksheets
Then filtering ...

**-1**

votes

**2**answers

35 views

### Conditionally Remove Duplicates

So I have column A and column C. Both columns have duplicates. However I only want to delete based on the fact that there are duplicates if combined column A and column C have the same values.
...

**0**

votes

**2**answers

35 views

### Combine Excel tables

I need to combine two excel tables(Table 1 & Table 2) to result as Table 3. New week column will be added every week with new data.
The Table 2 could be added to Table 1 or can be combined into a ...

**0**

votes

**0**answers

13 views

### How to merge Excel PivotTable results with another sheet?

I have an Excel spreadsheet, where I have a PivotTable where the X is Location & Commodity. The Y is Fiscal Year. The cell data is a sum of Commodity cost.
The PivotTable is being generated from ...

**0**

votes

**1**answer

33 views

### How to generate all possibilities of combination for a set of values or range?

Reference to question and answer below,
how to generate all possible 3 digit combination of the numbers 0-6
I have similar case (need to generate all possible combinations) but for set of values ...

**-2**

votes

**0**answers

23 views

### Excel Nested If Function

I want to compare two columns of values and if the one column is at least 85% of the other column , return the first column value if it is not then return the other column value.

**0**

votes

**2**answers

25 views

### how to generate all possibilities of combination for a set of number or range?

reference to question and answer below,
how to generate all possible 3 digit combination of the numbers 0-6
i have similar case (need to generate all possible combinations) but for set of values ...

**0**

votes

**1**answer

37 views

### Need macro to transfer Word data into Excel

I am very new to VBA and need help ! I have VB macro in Excel that grabs the data from a Word document and imports it into Excel worksheet. Currently, the code in macro has expression that clears the ...

**0**

votes

**1**answer

37 views

### Group values in Excel

I have 500 rows of items. I need to enter these in an application where I can enter a maximum of six items at once by creating a unique Group ID for these six items.
The items in a group share the ...

**1**

vote

**1**answer

40 views

### showing negative excel axis without label

I have a graph with one negative value. I'd like to be able to
Start the graph from the lowest value (in my example, -1) instead of 0
I'd like the major axis to still show every 10 units from 0, so ...

**0**

votes

**2**answers

23 views

### How do instruct a cell to display a minimum value?

I currently have the following formula in a cell:-
=CEILING(E9*0.85, 1.25)
I would like the cell containing this formula to display a value no less than 20 but only when the value of E9 causes ...

**0**

votes

**1**answer

22 views

### How can I convert this date format to the ISO date format?

I have a spreadsheet with a list of dates in the format 25th Jan. I'd like to convert these to ISO format, ie YYYY-MM-DD. The year will in all cases be 2016. Is there some magic equation-foo that will ...

**-1**

votes

**1**answer

65 views

### Calculating Stock Profit/Loss in Excel

I'm trying to create simple spreadsheet to calculate profit/loss after every complete transaction I perform on the stock market. This way I'll be able to track my portfolio performance at any moment ...

**0**

votes

**1**answer

21 views

### How to copy range from an unactive workbook

I'm simply trying to copy and paste between workbooks in VBA without first activating each workbook that I want to perform actions on.
My code stores the active workbook and sheet in variables before ...

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

27 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

27 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

33 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

38 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

31 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

51 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

49 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

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

**0**

votes

**0**answers

35 views

### Calculate polling results in Excel [closed]

The rating is a value from 1 to 4 and determined by the results of a recent poll conducted in each constituency by a noted pollster. Apart from the candidate's rating, the pollster also supplies the % ...

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

70 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

42 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

172 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

36 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

55 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

371 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

11 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

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