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 excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
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
2answers
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
1answer
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
3answers
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
3answers
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
1answer
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
4answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
2answers
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
0answers
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
1answer
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
0answers
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
0answers
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
2answers
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 ...