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
0answers
3 views

how to remove identical data in field

I have an excel file of 6 colums and more than 2000 rows. Data in Colum B is identical to E and C is identical to F. However, data in a cell of col B can match with in cell of col E. Further, the ...
0
votes
0answers
9 views

Saving Excel 2010 files

I use Excel 2010 at work and sometimes when I save a document I will be prompted to save 3 times. When I answer yes to each prompt then I will have the actual file, an "idattr.xls" file, and a ...
0
votes
1answer
15 views

How can I move a cell with multiple numbers into multiple columns?

What I am looking to do is take each image list number which is 8 numbers to a set and drop them into individual rows. The first columns are associated with each image and should be copied down to ...
0
votes
1answer
15 views

Excel: combine tables

I have N tables with M lines for each table. For instance I have two tables A and B with respectively 4 lines and 2 lines : Table A A1 A2 A3 A4 Table B A1 A2 I want to create a table C, ...
0
votes
0answers
14 views

How to clear just the data from multiple Excel spreadsheets after copying using VBA

I am brand new to VBA and I have some code to transfer data from multiple spreadsheets into one master spread sheet. This works ok but at the end I need to clear the days data from each of the ...
-1
votes
0answers
9 views

Excel very slow when I copy

Recently I face problem with Excel files when I copy or past anythings take long time to copy or paste also when I want to use any functions also file Excel became very slow, although the files do ...
0
votes
1answer
5 views

excel auto hyperlink based on content

I've been looking around and can't find if this is possible. I want to know if excel is capable of hyper linking to a file based on input. I have a small inventory spreadsheet where things get moved ...
0
votes
1answer
4 views

copying a given column containing names to another tab if a different column uses a certain word

I am a school teacher that has to keep up with who is allowed to go on a field trip. On tab one, renamed "8th grade" in column A I have their names. In column M, I write the word "yes" or "no" which ...
0
votes
0answers
12 views

Combining all combinations of data from mutiple columns in Excel

I am looking at this code Mr. Fedorov provided on November 5, 2014: Combining all combinations of data from three columns in excel It is doing what I expect it to do, but my range appears to be too ...
0
votes
2answers
13 views

Excel - Matching data across 2 separate workbooks

I have 2 separate tabs (tab A and Tab B) on a Workbook that both contain the column called CustomerID - this contains a unique Customer ID number. On Tab A it is Column B, on tab B it is under column ...
0
votes
3answers
24 views

Calculate date average in excel

Is there a way to calculate date average, but just "ignoring" the year? Let me explain. I have these dates: If I use =AVERAGE(F2:F39), the result will be 12/15/2008. That's not what I need. What I ...
-2
votes
1answer
33 views

How to update the big excel file having 80,000 rows based on other excel sheets? [on hold]

Question: How to update the big excel file having 80,000 rows based on other excel sheets? Issue details: I have two excel sheets one is master and other is individual file. In both excel sheet, ...
0
votes
0answers
13 views

Running Batch files when a Pop up message appears from another app

I need to run a batch file when ever a particular Pop up message occurs. Basically I have a batch files, but I cannot directly call it from my application. but I can create a Pop up message from my ...
1
vote
3answers
20 views

Change default encoding of Excel to UTF-8?

I am using a variety of tools to regularly prepare data for the web. One stage requires me to open a CSV in Excel, make changes and save the file. Is there a way to force Excel to accept UTF-8 ...
0
votes
0answers
11 views

VBA: Restrict copy paste in drop down on PROTECTED Sheet (Figured out unprotected sheet but doesn't work for protected)

I am looking for a code that will allow me to restrict copy pasting something in a drop down menu. After some searching and trial and error I have found something that works perfectly on an ...
1
vote
1answer
18 views

Make Office ribbon to drop-down and hide on hover

How can I make a minimized Office ribbon to drop-down on hover over a tab and disappear after the mouse leaves it? Among other annoyances, one of the worst usability disadvantages of the Office ...
0
votes
1answer
15 views

Percentage calculation in Pivot Table

I need calculate the uptime of each system. I have the downtime of each issue, date and system information. I can get the total uptime of each month.. How can I calculate the uptime % of each month ...
0
votes
0answers
8 views

Keyboard shortcut to reapply sorting in Excel 2015 Preview for Mac

In Excel 2013 for the PC, you can press Ctrl-Alt-L to reapply a filter/sort on a table in your worksheet. This shortcut does not work in the Excel 2015 Preview for Mac. I tried other variations on ...
0
votes
1answer
27 views

How do I create a percentage completion formula?

I have a project plan with different tasks, each with a reference number i.e. main step, key activity and task. I have planned start date and planned end date for each in two separate columns. I ...
0
votes
3answers
36 views

How to project cell value in dfferent cell. Excel

I am looking for a way to project a cells value in a different cell. Scenerio: Column A = Value Column B = Vlookup from A Column C = I would like to be ONLY the value from B not the formula. Is ...
0
votes
0answers
17 views

Excel: Conditional formatting for column merge

I'm looking to create a timetable that is formed by combining material from several worksheets. It does not seem to be possible to automatically consolidate text from several worksheets, but it is, of ...
0
votes
1answer
23 views

EDATE minus 6 minus 6 is not same as -12

Is there some way to get 2014-06-30 minus 6 months to be 2013-12-31 rather than 2013-12-30 (i.e always end of month)
1
vote
1answer
12 views

Powerpivot install fails

My machine runs windows 7 professional (64bit) and I use MS office 2010 professional 32 bit. I'm attempting to (re)install the powerpivot plugin but i get an error stating "installation of ...
0
votes
1answer
36 views

Counting values in a column if a certain value exists in another column

I'm trying to create a Summary tab in my spreadsheet that will summarize info from another tab. Primarily, the parent tab is a list of tasks, status of the tasks (open or complete), and the persons ...
0
votes
0answers
11 views

Prevent Formula From Being Entered Into Unlocked Cell

I have a workbook in which everything is protected except for one cell which updates the filter to a table via a VBA macro on update. This is almost completely effective at hiding the full contents ...
0
votes
3answers
52 views

Excel text to convert date format

I have a batch of data with several columns which the date is formatted like this: May-31-2014. I'm trying to figure out a way to convert that into a useful date format 05/31/2014. Any ideas?
1
vote
2answers
26 views

Excel data rearranging into another sheet

I'd need to make excel copy/refer and restructure data from sheet 1 into sheet sheet 2. Sheet1 has the following structure: ...
2
votes
1answer
12 views

Excel table from Outlook: Fill Series directly

I have inserted a new table directly from Outlook, and I want to fill series as we would normally do in Excel. Is there any way of doing that from Outlook itself? Or simply we have to go back to Excel ...
1
vote
3answers
37 views

How to show negative time in excel?

Is it possible to show negative time in a cell? eg: if I need to calculate work hours balance day 1 : from 8:00 to 16:00 (8:00 hours = standard) day 2 : from 8:00 to 19:00 (+3 hours) day 3 : from ...
0
votes
1answer
15 views

How can I import a TAB delimited file with double quote text qualifier into Excel if a cell value already contains a double quote?

I am trying to import a TAB delimited file with the following format into Excel 2013 "Column A" "Column B" "tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp" "tjc0058088269r" ...
1
vote
0answers
12 views

Undoing excel default / automatic delimiting [duplicate]

I have a large data export that is going through the end user for spot-checking. The data was formatted with tab delimiter, as it contains a lot of prices and measurements containing commas. The ...
1
vote
1answer
28 views

Get a value from the most recent previous record where some text appears in either of two columns

I'm trying to more fully automate the calculation of values and summary data in a spreadsheet I keep about the results of matches in a pool league. I have a table with lots of information about each ...
0
votes
0answers
11 views

How to make a counter on the number of time a file using a certain template has been used?

I would like to make an external counter that counts the number of time I've created a file using a given template. I would like to be able to reset this counter automatically every new month. This ...
0
votes
1answer
27 views

Extract data from more than 100 hyperlinks of web page

I am using this website which has hyperlink for a number of companies. I want to extract the details of the companies. When I click the company, there is a hyperlink "Certificate" which has the name, ...
1
vote
2answers
25 views

Excel - Find ID-related Value and fill in another workbook

I'm working in a small hospital in India having following problem: For a special drug we're having a list with DATE,ID,DOSE,DURATION,NEXT VISIT which we us as a daily working list (workbook 1), means ...
0
votes
1answer
20 views

Excel 2007. I can't enable macro when I open document for second time

The document work perfectly on my computer with office 365, windows 7. But when I copy it to another computer with office 2007 and windows 7, it start normally ( I enable macro and it make everything ...
0
votes
1answer
33 views

how to separate long text data of cell into two columns

I have Name and Address two details in one cell: NKG JAYANTI COFFEE PVT. LTD. 501 QUEENS CORNER, "A" 3 QUEENS ROAD, BANGALORE -560 001.KARNATAKA STATE. ALLANASONS LIMITED, CHANCO RESIDENCY NO.1/2 ...
0
votes
1answer
30 views

Excel- find match between to columns but copy a different cell

I would like to be able to find matches between two columns in Excel. Lets say Column A and Column C. However Column A's values are linked to Column B. When a match is found in A, can it copy the ...
-1
votes
0answers
30 views

Excel VBA to color cell based on text from another cell on another sheet? [closed]

I am looking for a VBA that can color a cell in say Column A(Data) or B(Other Data) where the values are pulled from Column A in another sheet containing different Text selected from a drop down box. ...
0
votes
1answer
15 views

XPath Data Scraping From Online Community Using Excel

I recently read this article on how to scrape the Inbound.org community members profile using Excel. And you can watch the video here if you prefer it that way. Since the release of this tutorial, ...
-1
votes
4answers
33 views

Excel sort maintaining equal values in different columns in the same position

Imagine I have the following set of data A B AnthonyMorgan EvelynThomas JoePatterson RussellRobinson JohnAnderson ChristopherMiller CarolynMorris RyanStewart DorisKing ...
2
votes
4answers
69 views

Dynamic monthly excel calendar

I want to create a monthly calendar (1 month per sheet) where only the year could change (and so the date). My template of the calendar is already created. All I want is to add a formula that change ...
0
votes
1answer
34 views

Excel Adding multiple values

How do I sum the "1"s separate from the "2"s when they are in the same column? 1 2    1    1    1    1    2    1    1    1    1    1    1    1 1    1    1    1    2    1    2    1    2    2    1    1 ...
0
votes
2answers
29 views

Excel 2010 formula to delete repeated content based on value (instead of second highest the lowest)

I've read a Question topic about picking the second highest value. I need the same but a bit different: Excel 2010 formula to delete repeated content based on value Maybe it is a bit rude, but I ...
0
votes
0answers
21 views

How to update a third column from a column when two other columns match? [on hold]

Maybe the heading confuses. But this is what I want to achieve: Let's say I have a column, Col1. I have got Col2 that has got some of the items from Col1 and a corresponding Col3. I want to lookup ...
3
votes
4answers
52 views

How to identify duplicates within text in two columns in Excel

I have a worksheet where column A has various names in varying formats: A1   John Smith A2   Jones, Mary A3   Sally Gomez A4   The Gonzalez family Column B has similar data: B1 ...
0
votes
1answer
12 views

Find multiple cells with the same value in col A then search col C for a particular number

Say I have multiple cells in column A with the same value (e.g the number 22). I want to identify those rows then search for the existence of a particular number in column B (e.g. the number 10); ...
1
vote
1answer
27 views

Add an area to a scatter plot in Excel

I'm desperately trying to layer an area chart on top of a a scatter plot in Excel 2013. The scatter plot has been successfully used to visualize the deviation from the mean of different Key ...
-1
votes
0answers
7 views

How do I link other workbooks to a master file?

I want to know how to link different workbooks, which have similar names. For example, I have one master file, which needs to get populated from various other workbooks (from different worksheets). ...
0
votes
1answer
21 views

How can I return a count of a specific criteria in a range of duplicated items?

I have two sheets (tabs) in an excel document, Sheet 1 and 2. As can be seen below Sheet 1 has 3 columns [1 row], and Sheet 2 has 2 columns [5 rows]. I am looking for a formula that will return the ...