A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

1
vote
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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, ...