# Tagged Questions

**-1**

votes

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

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

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

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

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

**3**answers

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

**0**answers

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

**1**answer

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

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

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

**3**answers

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

**1**answer

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

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

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

**2**answers

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

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

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

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

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

**1**answer

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

**0**answers

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

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

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

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