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)

-1
votes
1answer
42 views

How can I create a chart to show a possible pattern [on hold]

I have 3 columns in my table. Date Day of Week # of hours 11/27/2013 Wednesday 7 2/4/2015 Wednesday 7 3/18/2015 Wednesday 7 5/2/2013 Thursday 2.5 5/15/2013 Wednesday 2.5 ...
0
votes
1answer
19 views

How to sum up weighed normalizations of columns?

Say, I have a sheet with the following (simplified) structure with absolute values: What I want to achieve is to get a table with the normalized values (i.e. the maximum is equivalent to 1. In my ...
-1
votes
0answers
35 views

Which Excel functions are array formula friendly? [closed]

What is the comprehensive list of all Excel functions that accept arrays as an input and so are 'friendly' to use in an array formula? The unfriendly ones seem to collapse down the output into a ...
0
votes
2answers
19 views

How to create a Excel formula that finds the corresponding range in a matrix for a given value?

I would like to create a Microsoft Excel formula which finds the corresponding range in a matrix for a given value. Explained with a generic example Reference table | Name | From | To | | A | ...
0
votes
0answers
11 views
+50

Hotkey to open filter drop down menu in merged cell in Excel 2010

I use Excel 2010 and use Alt+Down arrow to open filter drop down menus. Sometimes my header contains vertically merged cells (e.g. autofilters are in the second row and in some columns cells in rows ...
0
votes
1answer
21 views

Excel: How to filter values in a pivot table so only rows with the latest date display

I have some data I collect and I use a pivot table to analyze it. I recently started collecting the data in a different way to capture a running total, but it's messed up all my pivot tables. I am ...
1
vote
1answer
26 views

Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...
1
vote
3answers
41 views

Removing Tabs When Exporting Excel to Text [closed]

When I save an Excel file as a text file every cell has a tab after it. How do I remove all of these tabs? I'm looking for a way to do this with a basic text editor, like Notepad, because I need ...
0
votes
0answers
32 views

How to Sum based on two critera, date range and name

I have a table that has timesheet data for a number of users. Column A has the resource Names. Row 1 contains each week of the year, starting with the 5th of Jan. The table contains hours booked by ...
-1
votes
0answers
21 views

Extracting columns from an Excel file

Here is my scenario: There is a certain service that creates summary reports each week. This is an Excel file with a number of rows and columns. One of these columns is an ID. Think of this as the ...
0
votes
1answer
30 views

Convert multiple rows to single row for same Material

I have multiple rows for each Material (number of rows will vary) with different values for Manufacturers & Manufacturer part numbers. I need to convert this into one row for each Material with ...
0
votes
1answer
23 views

Web Scraping Macro error

I am trying to scrap multiple pages that are a search result of a key work. I wrote this code but I am getting an error when I run it. Error: Application \-defined or object-defined error. When I ...
0
votes
2answers
38 views

How to give worksheet tab a color if range of cells contains text

I have tried code that I've found on SE, and elsewhere but they aren't working as I think they can. I'll list them below. I'm almost certain this is an easy question. What I'm trying to do: If in any ...
0
votes
1answer
28 views

Conditional sum in Excel or Libreoffice calc

As an example, in the table above, I want to populate the empty column titled 'Totals' with the corresponding sum of all the Values in the left tables 'Values' column belonging to the category ...
0
votes
1answer
16 views

Converting a column list from A2:A142 to a list with commas into cell B1; holding a format as “0000” with leading zeros

This code works to convert the column list to a concatenated list with commas, however the format doesn't have leading zeros while the VBA loops in B!. Dim i As Integer Dim s As String i = 2 Do ...
1
vote
2answers
33 views

How to list all possible solutions for missing digit?

In Excel, I want to add 2 numbers with missing digits and would like a list of all possible solutions. For example: Given 5.x1 + 2.y1 = 7.32, what are the possible combinations of x and y? In this ...
1
vote
0answers
13 views

Deleted record keeps reappearing in data file using MS Word 10 merge/Excel 10 spreadsheet

I am unable to remove one particular record from my data file. I remove it from the excel spreadsheet, but when I try to merge it is back--even after I have changed the file name after removing the ...
1
vote
1answer
20 views

How to paste static value, not dynamic value in VBA

How do I change this piece of VBA code such that instead of =datewanted in the excel cell, I get the static value of the "datewanted". ws.Range("A" & lastRowofA & ":A" & lastRow).Formula ...
0
votes
1answer
23 views

Changing cell border without affecting the surrounding cells

In Excel, how to define border of one cell without changing border settings of surrounding cells?
0
votes
1answer
31 views

In MS Excel how do I set the number of decimal places dynamically?

I have a table where I am reporting a range of correlation coefficients which range from -1.0 to +1.0. I want to format them such that if they are plus or minus one or zero, then they are formatted ...
1
vote
1answer
19 views

Splitting Large Strings in Excel an Arbitrary Number of Times

Suppose I have a 50 character string and I want to split it in to arbitrary chunks. For example I might want to split it into chunks of 4,5,3,8,2... and so on. What's the easiest way to do this in ...
0
votes
2answers
34 views

Excel sees date/time value as text

I exported some data from a database as an excel file. One column contains date/time values in the following format: 2015-04-09 14:05:11.867 where the .867 indicate miliseconds. Excel reognizes ...
-2
votes
3answers
35 views

Numbers formating to show text [closed]

How to get text instead of numbers by formatting? suppose a formula in cell gives numbers and I want that to be in text like 1 gives Excellent 2 gives Good 3 gives average other number gives Bad ...
0
votes
0answers
24 views

Styling HTML to be displayed in Excel

I'm trying to produce an HTML document which will render at least partway passably in Excel. The problem is that I can't get background colours to show up. Code: #header { background:Blue; ...
0
votes
1answer
29 views

Plotting 3000 data vs date in excel [closed]

I have 3000 data which are registration numbers and every reg.number corresponds to a date. Some dates have several registration numbers. It looks like this: Date - - - - - - Registration number ...
0
votes
0answers
15 views

Compare value from one cell with other sheets with different names

i have a workbook, where i create one sheet per employee, the sheet is named after the employee. The sheet has two columns Variable and Values. The Variables will differ for departments I create a ...
0
votes
0answers
24 views

How do I pull the ASIN code from an Amazon url in Excel?

How do I pull the ASIN code from an Amazon url in Excel? Variable length URL's, example: Want to derive the cell result : B00BQ59SYM from this ...
-1
votes
3answers
38 views

Excel : How to select cells with more than a number of characters?

Only search one column, then highlight all cells in that column with more than (a number) characters, so i change the data one by one? Thank you. Its phone number, thousands of them, many are typed ...
0
votes
1answer
40 views

How to sort sheet by groups of three rows without changing internal arrangement of groups

I created an Excel file showing a list of golfers and their scores on 18 holes. I want to sort by the Net Total, while preserving the rest of the formatting. When I try to sort the usual way, I ...
0
votes
2answers
32 views

Use INDEX to lookup multiple values in a list

I am using this formula to Look up all instances of CUCUMBERS in column B on the first sheet of my workbook: "ITS" I have identical to column B in Column X. So far this works great, just as I want ...
0
votes
1answer
29 views

Plot two columns against eachother

I don't think this should be difficult, but I'm pulling my hair out trying to do it. I am trying to make a chart of age vs BMI. I have a column with age and a column with BMI. The table looks ...
0
votes
2answers
22 views

Insert spaces in excel number sequences

I am trying to format cells so when I type in phone numbers it automatically formats them as follows: - Landline Nos e.g. 02012345678 to appear as 020 1234 5678 Mobile Nos e.g. 07123456789 to appear ...
0
votes
1answer
32 views

What prevents Excel from staying current with the years. For instance, why aren't I using Excel 2015? [closed]

Just curious on why Excel (along with other Microsoft applications) are not "up-to-date".
0
votes
1answer
25 views

Copy named ranges to another workbook

I have this VBA code to copy my named cells from one workbook to another, but it gives me Error 9: Subscript out of range. Any ideas please? Sub namexfr() wbs = ...
-3
votes
0answers
25 views

Need A VBA Code To Pull Data from Multiple excel files in to one [closed]

Sub Beachson() Dim z As Long, e As Long, d As Long, G As Long, h As Long Dim f As String d = 2 Cells(1, 1) = "=cell(""filename"")" Cells(1, 2) = "=left(A1,find(""["",A1)-1)" Cells(2, 1).Select ...
0
votes
1answer
20 views

Excel 2011 plotting difference between logged sent-time / acknowledgment-time

I have an excel sheet which is a log containing the time that a message has been sent and the time that the corresponding acknowledgment for that message was received. It also contains the time ...
0
votes
0answers
21 views

Mysterious “Reference not valid”

Error dialog: Reference not valid I have a big sheet with 30+ pivot tables made from the same 3 named tables. Every time i run refresh all I get the Reference Not Valid-error. I have no idea which ...
0
votes
2answers
28 views

Google Docs / Excel how to transform redundant row in columns

I have a list of redundant rows like this See my Google sheet Target FRBBED05517 Job state EXECUTION_ORDERED Target FRBBED05523 Job state EXECUTION_ERROR Target ...
0
votes
2answers
37 views

Excel: Validation rule with value that should be in the list of another column without blank

On excel, I've two tabs: one listing all people participating to an event, with a lot of details. I've a "FullName" column which is basically defined by: =[@LastName]&" "&[@FirstName] This ...
0
votes
2answers
25 views

How do I create an excel formula to pick out differences in 2 cell values?

I have a column of company names (column A), a column of the 2014 revenue (column B) and a row of the 2015 revenue (column C). I want to somehow pick out which companies had zero revenue in 2014 and ...
3
votes
1answer
21 views

Excel Conditional Goal Seek

Is it is possible to have the Excel Function Goal Seek stop when a certain is value is met or exceeded? E.g. Set cell A1 to be >10 by changing cell B1. Thanks
0
votes
0answers
22 views

Create Xbox Music Playlist from excel list (csv)

I created a few playlists in Excel (just the artist & song title) that I wanted to Import into Xbox Music. Unfortunately the only way I could find was to search for each song indivdually and then ...
0
votes
1answer
28 views

EXCEL: Additional COUNTIFS / Condition Needed for Value Ranges

I am recording multiple channels from individually housed birds, and sometimes their vocalizations bleed-through to other channels. I want them to be tagged for removal in some way. ...
1
vote
2answers
75 views

How to convert a number for a salary amount, to a specific, 9 digit, format in Excel

If I enter a salary dollar amount as 34512.15, I'd like to have a formula return this amount in a specific format as follows: M(HT)(TT)(TH)HTOCC M=Millions (HT)=Hundred Thousands (TT)=Ten Thousands ...
0
votes
0answers
15 views

Trying to create a tag system for historical expenses on Excel [duplicate]

I've imported a .CSV of historical transactions downloaded from my bank's website into excel. I'd like to create a new column in which I can list some tags associated to each transaction. For example, ...
0
votes
2answers
44 views

excel add cell if percentage or dollar amount

If I have a total column and want to add to that total a cell that would house either a percentage or a dollar amount, what is the formula? Is that possible.? For example a1 = freight b1 would be ...
0
votes
1answer
23 views

Count items in comma separated list in single cell

Is there a formula that will count the number of items in a cell, each separated by a comma? For example: CELL A1 = "Dell, Apple, Samsung, Acer" Formula would return 4.
0
votes
1answer
30 views

Conditional formatting- use a formula

I'm getting a bit tripped up with Excel. I've got 5 columns of retirement account contributions and balances over 30 years, and I'm trying to highlight the year where the year-end balance first ...
0
votes
1answer
23 views

Inserting missing values in EXCEL column [closed]

I have two columns of data in EXCEL. In one column, I have the time (say in hours), and in the second column, I have the stock price data in each time. Time stock price 09:00:00 AM ...
0
votes
0answers
34 views

Saving Images as Filenames in Excel

I have a product information sheet from a supplier that needs to get uploaded into an ecommerce platform. However, the spreadsheet contains actual images in the image column instead of filenames. I ...