**0**

votes

**0**answers

7 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

10 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

5 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

21 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

**2**answers

28 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

15 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

22 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

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

**1**answer

26 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

10 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

49 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

25 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

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

**3**answers

35 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

**1**answer

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

**0**answers

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

**1**answer

26 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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

19 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

**1**answer

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

**1**answer

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

**0**answers

29 views

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

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

**1**answer

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

**4**answers

32 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

**4**answers

67 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

**1**answer

32 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

**2**answers

27 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

**0**answers

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

**4**answers

50 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

**1**answer

10 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

**1**answer

26 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

**0**answers

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

**1**answer

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

**2**

votes

**3**answers

53 views

### How to round off an hour value?

I need to round some hour value in excel at the first quarter after):
9:01 ==> 9:15
9:10 ==> 9:15
9:15 ==> 9:15
9:16 ==> 9:30
and so on

**0**

votes

**2**answers

15 views

### Month by Month Pivot Table

I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...

**0**

votes

**0**answers

23 views

### Parse .docx, Put data into excel? [closed]

I already have an idea on how to do this (using python-docx and openpyxl), but I wanted to see if there are any other more efficient / faster / easier ways to do this.
I am using LiClipse as my ...

**0**

votes

**2**answers

27 views

### Excel - Dynamic Cell Update using multiple criterias

I would like to know if there is a way in Excel to create a cell that will display a value using a formula that will calculate the latest entry by date and campaign.
If I have 3 columns DATE | ...

**0**

votes

**1**answer

24 views

### How to create a reference table in MS Excel?

I would like to create a reference table in Excel like this:
So everywhere in my workbook or worksheet I type X111, Excel shows the value of 2400.
How could I do that?

**0**

votes

**1**answer

31 views

### How to search in column A for specific data and place an answer in column B (“Yes” or “No”) [on hold]

Using Excel for Mac 2008.
Column A has a long list of comma-separated data in no good order. I want to find one specific set of words (set off by commas, such as "Level 2 Supporter") in each row and ...

**1**

vote

**2**answers

26 views

### Find information about range of Excel data. Is it constantly growing or cyclical?

I am (short-term) monitoring the sizes of several UNIX files and can easily export the numbers to an Excel spreadsheet. The files will eventually be indexed by Splunk and that team wants to know the ...

**0**

votes

**2**answers

61 views

### How to convert text to date in MM-YYYY format

I have a column in Excel with the following entries in text format:
7.2013
7.2014
8.2013
8.2014
9.2013
9.2014
10.2013
10.2014
11.2013
11.2014
12.2013
12.2014
1.2015
How can I convert this ...

**0**

votes

**1**answer

34 views

### Chart created from range of dates includes dates not in source data

I have a chart and its source data is read from a range which contains dates. When I plot it out into a chart, the x-axis includes dates that are not included in the range.
How do I avoid this?
For ...

**1**

vote

**1**answer

16 views

### how do i just copy excel to txt with space and '\n' as delimiter

When I copy excel to txt, the I can't get the delimiter for different columns as space, ' ' and the delimiter for different rows as '\n'. Is there someway for me achieve that? Because I am building a ...

**0**

votes

**1**answer

54 views

### Excel colon in function

I am learning excel functions and modeling from Google and trial and errors so just want to clarify the following point to get my fundamental understanding correct:
When it comes to colon in excel, I ...

**0**

votes

**1**answer

28 views

### Excel changes my settings for column width and row height

I select the entire Column
right click and select "Column width"
enter 2.54mm
hit enter
When I check the column width, it is 2.38mm.
Similar issue with row height. I try to set it to 2.49mm; ...

**-1**

votes

**0**answers

20 views

### How to control date range for the powerpivot chart? [closed]

Is there any way to control date range for the powerpivot chart by entering those dates on the excel sheet?
When you draw the chart with the data source from PowerPivot. It will have X axis and Y ...

**0**

votes

**0**answers

19 views

### How to get selected slicer or timeline value in the powerpivot? [closed]

Is there any way to get the selected value from slicer or timeline in powerpivot data model?

**1**

vote

**1**answer

42 views

### Looking for an excel formula to match credit card purchases to batch payments reflected on bank statement for account reconciliation [on hold]

How can I match credit card batch payments from bank statement to credit card purchases in a spreadsheet?
CC Purchases Batch Payments
1 0.05 A 1,913.91
2 ...