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
50 views

Display the content of Column A when I put a 'X' in Column B

I have a workbook that contains the projects that I'm working, in many tabs. Each tab has one column that contains the name of the project and another that is an 'on going' column which I mark with a ...
0
votes
1answer
36 views

How to delete 1 or more rows of 2 sheets at the same time excel 2010

I'm trying to finish last step of my EXCEL spreadsheet. I Need to erase one full row or selection of rows in sheet1 and have excel automatically erase the same row number or selection in sheet2 ...
0
votes
0answers
18 views

How to import excel data into power point with scrolling

Hellow Guys i need help about Power point I want to import data from excel into power point but i have a 1000 row data. if im import data using object or paste the data into power point it become ...
2
votes
3answers
32 views

How to get unique values from data range in Excel?

I have a column whose rows are: Facebook, Skype Facebook, Skype Facebook, Twitter, Skype Facebook, Twitter Facebook, Skype Facebook, Skype Facebook, Twitter, Skype Facebook, Skype, ...
1
vote
1answer
25 views

In Excel 2010, how do you show the last time a row of cells was updated?

I have a project table that my whole team has access to. Each row is a specific project and they update the appropriate cells in the for those projects. The problem has become that the Last Updated ...
2
votes
2answers
72 views

Calculating time between two dates excluding weekends when an input is during the weekend?

I am attempting to calculate the time difference between two dates to exclude weekends and holidays in Excel. The issue I am running into is that sometimes an event happens during a weekend. For ...
2
votes
3answers
35 views

Prevent excel from reformatting values

I have a column of data. I marked the column as "Text". The data resembles the following: 5,5 6,5 5,5 8,5 4,5 ... With batch replace operation, I want to convert commas to dots. However, Excel ...
0
votes
0answers
39 views

Excel formulas to handle conditional number of results [closed]

I need help with this Excel formula: Quantity B1=500 Frequency B2=4 Cost B3=1000 Shipment# B5=Shipment# 1 Cost of Goods Sold(COGS) B4=(B1*B3)/(12/B2) and then spread that B4 into the next 3 ...
0
votes
1answer
31 views

MS Excel for Mac - conditional formatting

I would greatly appreciate help in writing the code to do the following: cell B7 is the sum of H7+I7+J7 when the sum in B7 is greater than 2 and less than 5 (i.e. either 3 or 4), I would like B7 to ...
1
vote
0answers
42 views

Using Microsoft Query in an Excel sheet with dynamic file location

I have two tables in the same Excel 2013 workbook and I want to create a new table within the same workbook that performs left outer join between these two tables using Microsoft Query. I was able to ...
0
votes
1answer
25 views

Excel Index Match for multiple conditions evaluates correctly with F9 but not in cell

I have an index match formula that evaluates correctly if I use F9, however when I actually press enter it returns #N/A. The formula is designed to perform a vlookup on two conditions: ...
0
votes
2answers
18 views

Data with hyphen copied from sql to excel is displaying incorrectly

Below is the data: 1) +9180 33575586 - Copied shows correctly on excel 2) +9180-33575625 - Copied shows just -33566445 on excel. On read tab looks like =9180-33575625. Please advice this is ...
0
votes
2answers
27 views

Adding a Secondary Axis to an Excel Chart creates gaps

I am trying to lay a line graph (on a secondary axis) over an area graph in Excel. When I have just the area graph, the graph uses the full width of the graph area. When I add the line graph and move ...
0
votes
1answer
20 views

VBA to prevent the global shortcut from running the wrong code

The article at the following site provides a tip for preventing a global keyboard shortcut from executing the wrong VBA code when two different macros in two different worksheets are assigned the same ...
0
votes
1answer
28 views

Force cells to be negative?

So, I have a spreadsheet that has a dropdown list to choose from cash, deposit/refund, check, etc. Then I have several columns that will tally both at the bottom and at the right. I need the cells of ...
0
votes
0answers
22 views

How to update chart on cell click event in Microsoft Excel?

I want to create mark reports for N number of students. Each student's daily based marks on three subjects(Subject1, Subject2, Subject3) should be recorded. Each subject has two types of marks such as ...
2
votes
1answer
50 views

Custom Pattern Fills in Excel 2013

I would like to be able to add my own custom pattern fills for projects I am working on in Excel 2013. For example, I would like to have a brick-like pattern, and a horizontal hash line pattern. ...
1
vote
1answer
34 views

macro for arranging data into a column

I have List of files with product price data in it, I converted pdf files to xlsx format while converting data is dislocated, the price data is dispersed in J,K,L columns, is there a macro in excel ...
-2
votes
1answer
76 views

How to calculate estimated moments with 8 hour work days

In my worksheet, I want to calculate estimated end times of processes taking into account workday timeframes. Assume working days of 8:00 - 17:00 and omit Saturday and Sunday. So, for example, when ...
0
votes
3answers
71 views

Excel Macro insert value into another cell

Okay I'm needing some help with excel i'm new to it. I have a spreadsheet that adds all these value together and puts them in cell M3. However this is a daily spreadsheet I will be using so I want to ...
2
votes
1answer
34 views

Summing a single cell Across Several Worksheets

I can easily sum a given cell, say B9, across multiple worksheets with something like: =SUM(Sheet7:Sheet11!B9) This is the equivalent to : =Sheet7!B9+Sheet8!B9+Sheet9!B9+Sheet10!B9+Sheet11!B9 ...
0
votes
1answer
31 views

Using vlookup / index match for this circumstances

I have some data which are grouped like this: 1st group of data(gender): Male, Female 2nd group of data(age): 12,13,14,15 3rd group (score + grade): For each gender and their corresponding age, ...
0
votes
1answer
20 views

Function to find if a value comes before another value in excel sheet

Excel sheet How can I know if a value comes before another value in a row in excel? For e.g. I want to know name of persons who have value "EL" before value "CL".
-2
votes
1answer
16 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
16 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
37 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
26 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
26 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 ...
0
votes
1answer
8 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
11 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
18 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
16 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
4answers
41 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 ...
0
votes
0answers
25 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
52 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
27 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
38 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
17 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
19 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
37 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
45 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
24 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
16 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
61 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
16 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
65 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
34 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
16 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
49 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 ...