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)

0
votes
1answer
29 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
42 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
31 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
14 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
36 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
38 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
25 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
31 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
32 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
39 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
43 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
31 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
24 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
26 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 = ...
0
votes
1answer
21 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
22 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
30 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
26 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
22 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
23 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
45 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 ...
-1
votes
0answers
20 views

Deleting columns from Excel [duplicate]

You responded to a question on How to delete specific columns from all excel workbooks in a particular folder. When I tried to use it, an error said that "Title" was undefined. Thanks for your help. ...
0
votes
1answer
66 views

How to use Index and Match formulas for multiple criteria

I have a spreadsheet that contains Olympic information, with the following fields in columns: A) Athlete, B) Age, C) Country, D) Year, E) Closing Ceremony Date, F) Sport G) Gold Medals. I want ...
1
vote
1answer
44 views

Excel: Get rid of gaps in line chart

I have a table that contains the data with some absent values. If I create a line chart for that, there are gaps in place of absent values, but I'd like to have the line just follow through to the ...
0
votes
1answer
36 views

How can I make a Scattered chart in excel where the dots are different colors?

I have the following info: Question | Importance | Percentage 1 | 2 | 15% 2 | 1 | 98% 3 | 1 | 35% 4 | 3 | 22% 5 ...
2
votes
1answer
23 views

Horizontal array constant definition issue

I can't understand where I fail (except following MS-original help :-D) in attempt to enter horizontal array constant (C+S+E seq) per MS guidance accessible either from Excel 2007 or 2010 help, or at ...
1
vote
1answer
25 views

Getting CHAR function to return multiple characters in Excel 2011

I'm using Office 2011 on Mac. I'm trying to write a formula to strip lower-case characters (and ideally spaces as well, but that's less important) from text in a cell. The purpose is to convert ...
0
votes
1answer
30 views

How to activate specific excel window and specific excel sheet using com objects autohotkey?

I am using following script to activate specific excel window- f5:: WinWait, Microsoft Excel - B [Compatibility Mode], IfWinNotActive, Microsoft Excel - B [Compatibility Mode], , WinActivate, ...
1
vote
1answer
38 views

How to get rid of “The following features cannot be saved in macro-free workbooks” in excel 2013?

Every time when I try to save a file, I'm getting the following error message. The list of available Add-ins in Excel I tested with a fresh file saved with simple word, closed, re-opened and ...
0
votes
1answer
33 views

csv file formatting issue in excel

I have a csv file when opened in notepad looks like this: sep=, ProgramXX, PXXXXX, .... IDXXXXX, XYZXXXXX, .... This should open well formatted as csv file in excel program but what I see is this: ...
1
vote
1answer
32 views

In Excel, How can I add values in a specific column if I have a checkbox type spreadsheet?

The Excel sheet is linear with column B being the distance walked each day. Across are a column for each participant. As they join the walking group each day, I'd like to keep a count on total ...
0
votes
2answers
30 views

SUMPRODUCT with VLOOKUP

I'm trying to get the Product and Sum of what matches in the TC Ref column and the Earn Type. For example 7926 would be (45.32 x -3) + (45.32 x -3) + (45.32 x -4) for REG and (45.32 x -4) for OT. I ...
0
votes
2answers
24 views

Calculating the deviation from range of values?

I'm trying to find if there is a function to do what I could do with several IF statements, just to make it more robust and standard I suppose (and more readable) I have a spreadsheet with 4 columns ...