**0**

votes

**1**answer

504 views

### Efficient removal of duplicate records across multiple Excel sheets

I have a workbook with 2 sheets. Sheet 1 has 3 columns (1A, 1B and 1C) and sheet 2 has 2 columns (2A and 2B). Now I need to delete rows from sheet 1 if 1A and 1B match any row in sheet 2 (i.e. 1A=2A ...

**0**

votes

**2**answers

29 views

### Most Current Result

I have a spreadsheet that reports 3 number results by quarter. I would like to create a pie chart that will only use the most current information. For example it will use quarter 1 data if no other ...

**0**

votes

**1**answer

53 views

### How can excel take two seperate cells with comma seperated data and pair them up?

I have looked all over for an answer to this and seem to be stuck fast.
I have something like this:
Cell B1: 01/01/2014,01/02/2014, 01/03/2014, 01/04/2014, 01/05/2014, 01/06/2014, 01/07/2014, ...

**0**

votes

**3**answers

132 views

### Excel X Y (Scatter) Chart more than one value per cell

Is it possible to have more then one value in a cell and then use a X Y (Scatter) chart to represent the dots on the X and Y Axis ?
Here is what I mean:
Instead of having just one value per cell ...

**0**

votes

**2**answers

109 views

### Enhanced Vlookup Excel Formula

I am looking for an excel formula that I can use to automatically fill E2 in the screenshot below. The intention is to find Marc's age from column B, ie E2 should be 20. Any ideas please? I have tried ...

**0**

votes

**1**answer

27 views

### Excel: How to strip search terms from a cell (referring URL)

I have cells that contain a referring URL of visitors who entered my websites.
this URL always has a different lenght, but it's constant format is such that the search term always shows up between p= ...

**0**

votes

**1**answer

43 views

### Count Row and Column in Pivot Table

Hi I have a sheet that collects the following
++++++++++++++++++++++++++++++++++++++++++++++++++++
+ Name + Address + Borough + Postcode + Date Added +
...

**0**

votes

**1**answer

89 views

### Make formula impossible to find / read

I have developed a spreadsheet for performing various calculations which our employees will complete and then distribute to clients / competitors. To protect the "intellectual property" of the ...

**0**

votes

**0**answers

24 views

### Plotting two data sets with measurements at different scales

I'm doing research on a rock core with tools that measure different things over different lengths. One will give me a reading every foot , the other will give me a reading every 2in.
I am trying to ...

**0**

votes

**1**answer

115 views

### Group Data By Multiple Columns

I'm not sure I phrased this title correctly. Please feel welcome to offer suggested edits.
I have data formatted like so:
Token,Location,Quantity
VBD,IN,100
NN,IN,200
FD,OUT,300
VBD,OUT,300
...

**0**

votes

**1**answer

89 views

### Excel - import data from cell automatically when a new tab is created

I am working on a spreadsheet summarizing data from standard templates inserted in a joint Excel file as separate tabs.
Is it possible to automatically import data from a specified cell into a ...

**0**

votes

**1**answer

293 views

### Excel 2010 area chart drop off

I'm trying to create an area chart that shows data over a year. All the data for each month always add up to 100%.
An image is probably worth 1000 words, so here we go:
I would like the area ...

**0**

votes

**2**answers

62 views

### Conditional Matching Based on Datetime

I have a set of names and datetimes on two sheets. One sheet we'll call LargerSheet and the other we'll call Sheet1. On LargerSheet each name has multiple datetimes associated with it. On Sheet1 ...

**0**

votes

**2**answers

392 views

### Get row number for the row matching multiple criteria in Excel

I have 2 worksheet that work together. Worksheet "Application" has a DATE column, a CODE column (a single digit number), and a VALUE column with a dollar value.
Worksheet "Scheduled" also has a ...

**0**

votes

**3**answers

944 views

### Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values in column B, and depending on that value, put the answer in column C.
For example, using the table below, it searching in ...

**0**

votes

**1**answer

58 views

### Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel.
Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...

**0**

votes

**4**answers

131 views

### Countif in Excel with multiple criteria

I have an index for law and order conditions in many countries over several years. For each country I want to find out how many countries are ahead and how many countries are behind for a given year. ...

**0**

votes

**1**answer

48 views

### Excel: Grouping and sorting rows

This is an example of the data I have:
Country Score University
a 5
1
2
3
b 7
...

**0**

votes

**0**answers

51 views

### Excel: How to internally store a numerical value in a cell but make it appear differently (Ex. Alphabetical Names)?

For example, I want to name a cell "Win (+5)", but I want it to act like it just has "5" in it so I can use it for functions and etc,.
I couldn't figure out how to do it.

**0**

votes

**1**answer

37 views

### How can I use a formula or conditional formatting to format mutilple criteria?

I am trying to do an excel function, either an IF formula or use conditional formatting to do an AND formula.
I need it to produce all three results in one formula, it is:
if the date is before ...

**0**

votes

**2**answers

77 views

### Indexing a Date Range if Date is Greater Than and Within n Days of Another Date

In a previous post I asked a question about how to find the most recent date associated with a particular entity and have that value returned in Sheet2 so long as it was greater than the associated ...

**0**

votes

**1**answer

37 views

### Can I separate a list by keywords?

Say I have a list:
Something something apple
Something something orange
Something something banana
Something apple something
Something banana something
Something orange something
Something something ...

**0**

votes

**1**answer

73 views

### Excel help to lock formulas from adjust on cell insert

I have a excel workbook where there is a hidden sheet that basically pulls data from other sheets in the same workbook just using the = formula.
The problem I am having is if I add a column or cells ...

**0**

votes

**2**answers

4k views

### Calculating time difference between two date/times from two columns in Excel

I have 5 columns: Start Date, Start Time, End Date, End Time and Duration. I need to calculate the duration between the Start Date/Start Time and the End Date/End Time. I tried just subtracting the ...

**0**

votes

**0**answers

16 views

### Hyperlinks to documents have changed

I have several hundred links to documents in a folder on a network drive embedded in my excel so that if I click the link, the pdf document opens.
As of today, a lot of these documents do not open ...

**0**

votes

**1**answer

158 views

### Excel: portable formula to reference data on previous (relative) worksheet

I need to create a fairly simple Excel spreadsheet (workbook). I need 12 sheets (tabs), one for each month.
Each sheet references cells in the previous sheet. For example, the "May" sheet is ...

**0**

votes

**1**answer

704 views

### How do I merge data from other excel files to one master excel worksheet?

I have an uniform ID system throughout all the files, except with multiple entries and differing data named columns. I would like to create a master excel sheet with specific data columns from each ...

**0**

votes

**1**answer

76 views

### Expanding a cell formula resolving all its references (precedents)

In Excel I have a cell containing a formula referencing other cells, which reference other cells and so on... forming a large tree of references. I'd like to substitute recursively all the occurrences ...

**0**

votes

**1**answer

84 views

### Phone number formatting in Excel 2010

I have so many numbers in so many format like 2123244559, or 364 7890, or 02246802121.
I want to write them in the same format like 0 ### ### ## ##, but the "format cell" tab isn't working.
I've ...

**0**

votes

**1**answer

175 views

### How to re-arrange Excel database from 1 long row, into 3 short rows and automatically repeat the process?

I would appreciate help on the above-mentioned topic.
I am unfamiliar with Visual Basic for Excel, so will need step-by-step guidance (if solution is via Visual Basic).
For example :-
Row 1, Sheet A:
...

**0**

votes

**1**answer

627 views

### graph in excel to represent correlation of 3 parameters

I have some data in excel and I would like to make a graphical representation of those data. Structure of my data:
persons ID : from 1 to 485 to every person, there is one parameter like average ...

**0**

votes

**1**answer

204 views

### Excel Conditional Formatting: 3 color scale scoring fuzzy matched data for Windows [duplicate]

This question is posted as a spinoff from here - the post cited is about Mac where as this is about Windows:
Conditional Formatting: 3 color scale showing text relevance in Excel for Mac
Is ...

**0**

votes

**2**answers

273 views

### Split single column data into multiple columns based on leap year in Excel 2013

I have about 100 files of MS Excel which consist of weather data.
I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time ...

**0**

votes

**1**answer

164 views

### VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function.
The purpose of the macro is after ...

**0**

votes

**1**answer

102 views

### Excel: how do I insert changing cell values in my sum?

I would like to find the sum of A3 lots of A1 multiplied by A2, where the value of A2 changes depending on the value of A3.
For example, if A3 is 3, then I would like to find ((A1*A2(where A1 is ...

**0**

votes

**2**answers

73 views

### Creating a formula that queries data in Column B based on a selection from Column A in Microsoft Excel

I am reasonably familiar with Excel formulas but I need to construct a more complex query and am not having much success at the moment.
I have simplified what I am trying to achieve for the purpose ...

**0**

votes

**2**answers

37 views

### Removing Specific Duplicates from an Excel Array

I have a workbook that has a list of account numbers and their attributes. Assume these are the only two columns on the sheet:
12345 Equity
12345 Cash
12345 Cash
55555 Fixed Income
55555 ...

**0**

votes

**1**answer

4k views

### How do I count attendance in Excel? [duplicate]

I want to make an attendance sheet in excel. If a child is present, the teacher will write P in a cell, or A for absent, or L for latecomer. I want to get the number of P or L in a range to calculate ...

**0**

votes

**2**answers

44 views

### Two columns (pounds, kilos) convert and fill opposite column depending on which data is entered.

I'm trying to keep two columns of data. One in Pounds and one in Kilos. (1 kilo = 2.204 lbs)
The problem is that when I add a row, it might be in kilos, it might be in pounds. Is there a formula I ...

**0**

votes

**1**answer

7k views

### hide/unhide rows based on cell value [duplicate]

Based on a cell value = true or false, I conditionally formatted rows to turn black. That means that I need to scroll down to find the set of rows that did not turn black. I would prefer that all my ...

**0**

votes

**2**answers

198 views

### How do I refer to a cell in another worksheet with a long name?

As explained in this other Answer, SheetName!A1 = cell A1 in the worksheet called "SheetName" (without quotations).
Say the name for my worksheet is very long. Without shortening "SheetName" and ...

**0**

votes

**1**answer

936 views

### Excel: Remove only alphabetic characters (retain special characters)

Two datasets to compare.
6701.2345_5432 and on the second the system inserted letters. 6701E.2345_5432
I have about 8000 rows I need to compare and I can't seem to modify the VBA code to ...

**0**

votes

**0**answers

47 views

### Stanford Wrangler ideal, but imposes limits, what are other options?

Stanford Wrangle tool is quite amazing, and I solved a giant problem with it, but it limits me to very small size. My file is about 500MB, and it allows me to process less than 1MB, the remaining data ...

**0**

votes

**1**answer

348 views

### VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below).
Please note that:
Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table'
The number of columns, ...

**0**

votes

**2**answers

120 views

### Microsoft Excel Filter function

I need to filter entries containing short forms of words (for example "Rd" for "Road"), however the filter function for containing "Rd" would return me all entries with words containing "Rd" like ...

**0**

votes

**0**answers

93 views

### Don't want to include blank rows in Excel table

I have a table in excel which contains the following columns:
Brands: Cell B
Open Closed: Cell C
Case Number: Cell E
Case Summary: Cell G
At the moment these are the following formulas I am using ...

**0**

votes

**1**answer

4k views

### Use worksheet name as a variable in a lookup [duplicate]

I have 2 workbooks with 60 plus worksheets. I need to copy data from one workbook to the other but would like to capture and use the worksheet name within the cell.
This is because when I create the ...

**0**

votes

**0**answers

51 views

### Excel Printing Budget

I am trying to print an 5 page across/4 pages down sheet. The whole reports needs to be running smoothly together so when I tape them all together it is one continuous sheet. I have tried cutting the ...

**0**

votes

**0**answers

595 views

### Super slow Excel, how can I increase the performance?

I have an Excel file which is super slow, like copying a cell to another takes more than a minute which should be done in a second. When I try to copy 10 cells to another area, Excel stops responding. ...

**0**

votes

**2**answers

2k views

### Parse data in excel — space delimited — right to left

1 Exxon Mobil 452,926.0 41,060.0
2 Wal-Mart Stores 446,950.0 15,699.0
3 Chevron 245,621.0 26,895.0
4 ConocoPhillips 237,272.0 12,436.0
5 General ...