# Tagged Questions

**0**

votes

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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