**1**

vote

**1**answer

274 views

### Copy & Paste with Microsoft Office

I have 300 rows of data in a table with a single column ( Excel, Access or Word-table doesn't matter) and I want to resize it for printing. So the data will have size 25x12 instead of 300x1. Is there ...

**1**

vote

**1**answer

2k views

### Excel 2007 Bar Char - Wrap X-Axis Labels

I am not able to wrap the text of x-axis labels on an excel 2007 bar PivotChart. As a result, the axis labels are overlapping onto eachother. Does anyone know how can I wrap these labels?

**1**

vote

**1**answer

347 views

### Excel: I copy pasted list 200 links from website to Excel and I want to extract text from the link

The links appear hyperlinked with blue line in Excel, I want to extract the text from the link e.g. The url http:\sea.craigslist.com appears as "seattle" in excel. I want to extract the text "sea" out ...

**1**

vote

**1**answer

1k views

### Split cell value into multiple cells

How do I get Excel to split a sequence of delimited values in a cell over multiple cells?
| A | B
1| 1 2 4 |
2| |
Split over /\s+/:
| A | B
1| 1 |
2| 2 |
3| 4 ...

**1**

vote

**1**answer

1k views

### Have Excel's Correlation Function Respect Filtering

I've got a cell that's using the CORREL function to return the correlation of two rows of data in my spreadsheet. The issue is that I'd like this to update based on the filter that I have applied.
...

**1**

vote

**1**answer

1k views

### Copy & paste a cell along with its name in Excel

Is there a way to copy a cell that also has a "name", and paste it somewhere else so that the new cell also has the same "name"?

**1**

vote

**1**answer

1k views

### Excel document opens in IE 64, not in IE 32

Whenever I click on a hyperlink to a scrip that outputs an Excel 8 document, I get a prompt from IE to open the file or save-as. If I click open in IE 32 bit, the document opens in Excel (which is ...

**1**

vote

**1**answer

1k views

### Concatenate cells that change daily automatically?

I use concatenate to pull data together from different cells in my spreadsheet. Since my data changes daily, I want the formula to also change daily without having to manually input the new cell in ...

**1**

vote

**1**answer

1k views

### Why don't I have a “Web Service References” menu item in excel/VBA?

I'm trying to consume a SOAP web service from excel. Now according to This article (and confirmed by other articles and MSDN) if I do the following:
Install the web services toolkit (I've installed ...

**1**

vote

**1**answer

97 views

### How to make sure that the text in TextBox in an excel is found when searched using CNTRL+F?

i have made a flow chart diagram in an excel sheet using TextBox tool from drawing toolbar.
i've made entries into the text boxes.(No other data is present in the cells of the worksheet)
But now ...

**1**

vote

**1**answer

387 views

### Import exponetial fixed width format data into Excel

I've received a bunch of text data files consiting of Lots of records (>30K/file) of 3 fields each of 5-place numbers in exponential format: s0.nnnnnEsee (where s is +/-, n is a digit and ee is the ...

**0**

votes

**1**answer

23 views

### If Function is not working in Excel

I had made a sheet to calculate factory workers timing and payment against working and over time.
First I made it in Excel 2013 and then I changed my Windows from 10 to 7 and also changed the ...

**0**

votes

**1**answer

19 views

### Excell 2010 Formula Query

I'm a little stuck with a sheet I'm creating at work.
Basically the sheet tracks performance across 3 fields for our suppliers. Delivery, Product Quality and Supporting Documentation.
I would like ...

**0**

votes

**1**answer

20 views

### Excel Reporting Funtions

Bare with me as this question has a couple of elements to it...
I have a training matrix with Company Organisational Chart in first few columns e.g. Unit Departments and Position Titles in first two ...

**0**

votes

**1**answer

20 views

### How do I get the day name in Excel to work in a formula

I converted the date using custom and the type is dddd.That worked fine, but when I reference the cell that the converted date is in using the countif function it won't calculate. I thought there was ...

**0**

votes

**1**answer

21 views

### How to stop excel copying adjecent formatting

Excel seems to be determined to copy the format of an adjacent cell. For instance, when I have a cell that has a green background with a number in it, then when entering a number in an adjacent cell ...

**0**

votes

**1**answer

26 views

### Creation of an IF formula that will return a 1 or 0 for times between a range

I am trying to create a spreadsheet that will calculate total number of patients per hour. I have an arrival time and a discharge time. What I was thinking is to organize my spreadsheet with times on ...

**0**

votes

**1**answer

15 views

### How can I get the secondary horizontal axis to the left and primary horizontal axis to the right in MS Excel 2013?

How can we get the secondary and primary horizontal axis to the left and right side respectively?

**0**

votes

**1**answer

32 views

### Compare two unordered lists in Excel and return differences

I have two Excel files, with customer data. I need to compare the two.
I have copied the username column from both into a new sheet. Now I want to go through, and if the username is in the first ...

**0**

votes

**1**answer

29 views

### Formula to reference a cell value that contains text and retain the cell refences formatting

I have a bunch of cells containing text. The text in those cells have multiple font sizes and styles. I need to replicated those cells in a different order further down the worksheet and if I make ...

**0**

votes

**1**answer

35 views

### How to express a lone “\” in a file path in VBA?

I'm using a VBA script to save a file titled "month-day-hour-minute" inside of a folder titled "month-year"
Anyways, excel doesn't like my code,
ActiveWorkbook.SaveAs "C:\Users\" & ...

**0**

votes

**1**answer

13 views

### lookup group ID, concatenate vertical list by group, and display results

I have two worksheets. The first worksheet items has a few rows with unique IDs in column A (item), a lookup list ID in column B (list), a blank column C (choices) where I want my solution to go, and ...

**0**

votes

**1**answer

39 views

### MS Excel - I wish to count unique values based on a parent column

I am very new to Excel. I need some help in counting unique values in each of three columns (considering them only one at a time) with respect to a parent column (the first one (A) in the image). Can ...

**0**

votes

**1**answer

21 views

### Read file with multiple end-of-file flags

I have a pipe delimited file that was exported from server update. There are approximately 134 million records. I am using excel to import a small number of records (1,000 - 10,000) to explore the ...

**0**

votes

**1**answer

29 views

### Prevent Office 2010 from opening Hyperlinks in Internet Explorer

I have several hyperlinks in an Excel 2010 sheet that are .png image files. I have .png files set to open in MS Paint. In Windows 7, clicking a link would directly open the file in MS Paint. But in ...

**0**

votes

**1**answer

25 views

### Trying to create a SUMIF or SUMPRODUCT with one positive criteria and one negative criteria

I need to perform a SUMIF, SUMPRODUCT, or similar formula with TWO criteria, one a positive match and the other a negative match. Refer to the very shady table below:
A........| B.............| ...

**0**

votes

**1**answer

8 views

### Sort report with subtotals and corresponding details by category,subtotal amount largest to smalled then by vendor name

I start off with a full download of data then add subtotals by category and vendor name. The end result I need is a report that is sorted first by category, then by largest to smallest dollar amount ...

**0**

votes

**1**answer

22 views

### Remove duplicates and group by first column

I have a spreadsheet that I need:
To delete duplicates but leave them on the row they are initially on
and
Delete the 2nd row based on what was deleted in the 1st row.
Since I just confused ...

**0**

votes

**1**answer

14 views

### How do I sort merged cells linked with other data?

I'm making an inventory excel and I'm trying to sort these orders by state. However, some orders have multiple items and thus, I merged the state because 1) better viewing and 2) When I add up the ...

**0**

votes

**1**answer

39 views

### Matching postcodes on 2 worksheets. Looking up corresponding data and recording alongside postcode

Two tabs in an Excel 2013 spreadsheet. One tab is named Homes Data and the other tab is named Ratings Data. Column O in the Homes Data tab is a list of postal codes and column G in the Ratings Data ...

**0**

votes

**1**answer

20 views

### Count specific assets (one column) which belongs to unique users (depending on another column)

To get the total of In Stock. I used this formula and it works. but this formula works for specific text.
=SUMPRODUCT((A2:A6="In Stock")*(B2:B6="Laptop"))
I need simpler formula to count rest ...

**0**

votes

**1**answer

41 views

### Displaying ONLY hours and Minutes in Excel

Using Excel 2010.
I'm not an Excel neophyte as I've been using is since the late '80s, but haven't had to do this before.
I'm building an agenda for a meeting where I want to display the start ...

**0**

votes

**1**answer

31 views

### If a range contains specific value, how to produce a percentage of that range below the specific value in Excel

I'm stumped.
I am arranging a data set that contains ranges of numbers that are specified by two columns, the minimum and maximum values (sometimes these values are the same). I am interested in the ...

**0**

votes

**1**answer

39 views

### Spreadsheet formula for adding all values adjecent to multiple instances of text cells

Given a table with unique and duplicate text values in a column with number values adjacent in the following format:
A|12
B|23
C|98
A|66
D|86
E|3
B|25
A|65
.
.
.
The values are simplified for the ...

**0**

votes

**1**answer

48 views

### Excel IP address pattern

I have data set (COL A) that is mixed IP addresses, and hostnames. I have a separate sheet that is a capture of the DNS records. I would like to create a formula that will do an index match on those ...

**0**

votes

**1**answer

24 views

### Merge data from three columns

I would like to merge the contents of three columns into a single column. I need to use a nested if formula as the columns take precedence over each other. Example column A1 may or may not have data. ...

**0**

votes

**1**answer

74 views

### Excel: How to Group Dates Per Week in Line Graph

I have data that looks like this:
Actual End Date ----CP
2016-04-22------------4
2016-04-26------------3
2016-04-26------------9
2016-04-22------------7
2016-04-26------------6
...

**0**

votes

**1**answer

40 views

### How to print password protected excel files with batch script?

I have several folders with password protected excel files (one excel file per folder). On the 16th of every month I have to enter each password and print the excel files which is a little time ...

**0**

votes

**1**answer

56 views

### How to disable right click “delete” option on worksheets tab

Is there a way to disable the right click "delete" option on the excel worksheets tab at the bottom to prevent users from be able to delete a worksheet. I know that protecting the worksheet/workbook ...

**0**

votes

**1**answer

45 views

### Excel Dynamic Chart- Range Name based on IF formula not accepted as 'Series Name'

I have created a simple Dynamic Line Chart in Excel 2013 as seen below. As I change the Year in Cell D1, the Series on Y Axis changes accordingly. The X Axis series is static. When I use Excel Range ...

**0**

votes

**1**answer

28 views

### Reference cell on another sheet dynamically?

Basically I have a column of tab/sheet names. I then want to build hyperlinks to those sheets and make the friendly name a value from the target sheet. I have the first part down, thanks to a ...

**0**

votes

**1**answer

21 views

### Excel formula bar default font

It's hard to see a leading negative sign on the Excel formula bar. For example, if I want a formula to be =-A1+B2 (instead of =B2-A1) the default font makes it easy to miss.
How can I change the ...

**0**

votes

**1**answer

27 views

### How to run Sub with parameter in Excel VBA?

I have procedure in Excel VBA which is need range parameter and also will produce output range exactly in active cell.
The code looks like this :
Sub test(oSource as Range)
Dim oTarget As Range
...

**0**

votes

**1**answer

19 views

### Values need to copy from Col A to Col B in Excel without data loss

In my Excel, I have 2 columns For Ex: Col A & Col B.
In Col A I have 100 Records but in Col B having only 50 records that is scattered not in sequence.
I have to copy and paste the same ...

**0**

votes

**1**answer

44 views

### Formula or VBA for cell formatting using value based on a cell but formatting from an other cell

I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E.
If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell.
For example,
...

**0**

votes

**1**answer

33 views

### Power View Not Working Excel 2016

So I've manually added power view to my toolbar, but when I try to click it nothing happens. Is this a known issue? My understanding was that Excel 2016 was supposed to automatically include power ...

**0**

votes

**1**answer

660 views

### PC unable to find EXP_PDF.DLL

I have an Excel workbook that uses VBA to create PDFs from sheets, and send them via email through Outlook.
When I click the button to create the PDFs and send, Microsoft Visual Basic gives me the ...

**0**

votes

**1**answer

33 views

### Using ARRAYFORMULA to auto populate a column for rows that contain data

The title just about says it all.
We have a spreadsheet that has a date in Column A and then in Column B it compares the value of Column A with today's date and spits out the number of weeks between ...

**0**

votes

**1**answer

31 views

### Excel Formula to Calculate Sum of Time Duration Between a Specific Time Frame

I'm trying to calculate the total number of hours between two columns of start and end times but only those hours that fall between 9:00am and 5:00pm, Monday to Friday.
For example, my data looks ...

**0**

votes

**1**answer

29 views

### Need to extract multiple matches from a list of values

I am trying to extract data from a worksheet using an array formula but it will only return one (the first it finds) value. The formula I am using is:
=INDEX($C$2:$C$8, SMALL(IF($B12=$B$2:$B$8, ...