**0**

votes

**0**answers

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

**1**answer

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

**0**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**4**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**3**answers

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

**2**answers

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

**1**answer

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

**3**answers

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