# Tagged Questions

**-3**

votes

**2**answers

22 views

### How can I scrape only word data from a website?

I want to download all the word content from a particular website. Save the results in MS Word, Excel or Notepad and check which words are repeated most often and how many times.

**1**

vote

**2**answers

19 views

### How to use validation to make sure cell value starts with specific word

I need to check if the value of a cell starts with the term superuser.
The entered value then should, for example, look like this:
superuser template
If the user enters super user template (with a ...

**-1**

votes

**0**answers

17 views

### Excel 2000 - barcode scanning error

Using a well developed barcode scanning control panel that was made by another employee at work.
Problem is, we get an error in situations where there are multiple barcodes on a box and the wrong ...

**0**

votes

**0**answers

19 views

### Is there a limit on the number of rows a sum function can calculate in Excel 2007?

I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting ...

**0**

votes

**2**answers

24 views

### Combine first letter and last word in excel

I have a spreadsheet of usernames. First and last name are in the same cell. Is there a formula to take the first letter of the first word and the whole second word?
For example;
Cell A1 has Jon ...

**-2**

votes

**0**answers

12 views

### Shortcut for expanding the Year,Month.Day in pivot

I'd like to know if there is any shortcut for expanding Year, Month and Day in a Pivot table

**0**

votes

**1**answer

22 views

### Finding Clustered/Consecutive Values in Excel

I am trying to find values in an Excel spread sheet where numbers greater than 0 will be highlighted. However, those highlighted must be clustered, consecutive numbers which should be (at least) three ...

**0**

votes

**1**answer

22 views

### Excel formula - is it possible to return a value adjacent to a list of values, depending if that list of values matches another list?

In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B.
I need to compare another list of document numbers (alphanumeric), ...

**0**

votes

**1**answer

20 views

### Sorting cells in rows to match respective column headers

I'm trying to sort the cell value in multiple rows to match the value of a column headers.
What it looks like:
A B C D E
---------
D
A C
C E
B D E
E
What I want it to look like:
A B C D E
...

**0**

votes

**1**answer

22 views

### Sheet name dynamically assigned from a cell value

I built a table in Sheet1!A1:A10:
Mike
Tim
Sue
Steve
︙
I would like Sheet2 to be named whatever I put in A1;
so Sheet2 would be "Mike".
But later I may want change A1 to a new name, e.g., ...

**1**

vote

**2**answers

53 views

### Index of N'th largest value in a range

I have a range of values that may contain duplicates. It looks something like this:
A B C D
----------
1 23 1
2 12 2
3 23 3
4 36 4
5 19 5
I want to display the 3 largest values, but I ...

**0**

votes

**1**answer

16 views

### SUMPRODUCT where the product is computed from the row

I have a range AG6:AS38. It looks like this:
AG AH AI AJ AK AL AM AN AO AP AQ AR AS
--------------------------------------------------------
6 | 1 A B C D ...
7 ...

**-2**

votes

**1**answer

17 views

### EXCEL, I need to take data from 1 column & arrange in another column so the data loops [on hold]

EXCEL, I have 4 columns. one column having part numbers, a blank column, column with group number & 123 count column.
I need to take item 1 of the 1st group copy it to blank column but in the ...

**2**

votes

**1**answer

10 views

### Excel Autofill Linegraph with Time

I must admit that I am not the expert on excel, but I need help creating a graph with some data. In column A, I have over 500 cells filled with temperature values from a probe. Now, technically each ...

**0**

votes

**0**answers

9 views

### To show data about one Excel file in another

An Excel sheet gets data from another, the source file, using DDE. How can I show, in a cell of the Excel sheet, the date/time when the source file was last amended or saved?

**-3**

votes

**1**answer

19 views

### Obtaining Australian Population data from ABS [on hold]

I am having difficulty obtaining simple population data for Australia. I need the number of people in Australia by year from 1900 to present. 2013 is a suitably close year.
Any information on how to ...

**0**

votes

**0**answers

11 views

### One dynamic named range not staying dynamic while another in the workbook is

I am attempting to use dynamic named ranges to make it so I can pre-set the column portion of the print ranges in a workbook without assuming a number of rows. So I opened the name manager and ...

**0**

votes

**0**answers

11 views

### Dynamic field names in Excel queries

As explained here, Excel queries accept dynamic values (e.g. "where name = ?" and "?" can be linked to a cell of your choice).
Alas, Excel queries don't seem to accept dynamic field names (e.g. the ...

**-1**

votes

**0**answers

17 views

### Excel 2013 autofill not working as expected [on hold]

I have a numbers in the first row. I multiply them with 2 in the second row by equation which was written in the first cell in the second row and drag it to the end of the row. the problem is the ...

**0**

votes

**2**answers

29 views

### Excel formula to identify and group figures

I have two columns A and B
In column A, I have figures in some currency say US Dollars. In column B, I have account codes to which the figures should be grouped.
A B
USd Codes
2,500 ...

**0**

votes

**1**answer

28 views

### Excel 2013: moving X-Axis values to the middle of the columns

How could I move the X-Axis values to the middle of the columns?
For example, the month values in the chart below (it's not my chart, it the state I want to reach) appear in the middle of the column. ...

**1**

vote

**1**answer

19 views

### Column of text needs “summed” based on assigned value

On one sheet, I have a table with an employee name in column A and their associated rank in column B. On a separate sheet, I have a blank master schedule with all possible shifts in column B and days ...

**0**

votes

**0**answers

11 views

### Outlines of merged cells not staying consistent when a filter is applied

I have a spreadsheet that uses merged cells for visual clarity. The merged cells are in the B column (dates), and in the A column there are various values. I use filters in column A, and in my other ...

**0**

votes

**0**answers

10 views

### event-click sub in VBA for Excel

I have an ActiveX listbox on an Excel worksheet. Can I put the listbox click-event sub in a module? If I double click on the listbox in design mode, Excel wants to put the sub on the code sheet that ...

**0**

votes

**2**answers

40 views

### How do you get excel to ignore zero or blank values in an Average?

I am making a spreadsheet to score recipe ingredients, averaging scores for quality of the ingredient, packaging, and accuracy of serving size, and then using that data to create an average for the ...

**-2**

votes

**1**answer

17 views

### How to find the unique values in 2 columns of different sheets in which the values in each sheets were not in order [on hold]

I have two sheets with same data in columns(Lets say column A) but the data insdie the columns were misplaced, i just need to find the unique data in each column of two different sheet. Help me in ...

**0**

votes

**1**answer

21 views

### How can I get a count of values for one column as compared to a second column?

I have a spreadsheet with a list of companies that submit data, the type of data they submit, and the date they submit. I need to a do a count of the number of times per day they submit, but only do ...

**0**

votes

**2**answers

22 views

### How can I prevent changes to formula results after first use?

We have an Excel 2013 workbook that we use when we create new user accounts (column A for first name, column B for last name, column C for the password, etc.).
First name Last name ...

**0**

votes

**1**answer

33 views

### How can I search for a value that's repeated in excel?

I have a spreedsheet (Sheet2) that has 4 columns:
ID | Name | Semester | SemesterAvg | Overall Avg | Period |
1 | John | 1 | 2.5 | 2.5 | 20132 |
1 | John | 2 | ...

**0**

votes

**1**answer

42 views

### Creating Folders and Subfolders from excel cell values

Im trying to create a directory named after the value in column E within a directory (c:/Site Information), then create a further directory called the concatenated value of column A,B,C, and D. This ...

**0**

votes

**1**answer

21 views

### Excel Month() function does not detect some date format

I have a simple table like this in excel:
The formula i used was =IFERROR(IF(LEN(B3)>0,MONTH(B3),""),""). I check if a cell is blank by using LEN, if so ignore, else, convert it to month no.
I ...

**0**

votes

**1**answer

31 views

### How to weight data in excel? [on hold]

I am doing animal observations and recording the frequency of behavioral events during the observation period.
Some observations are longer than others, and I don't want data from these observations ...

**0**

votes

**1**answer

19 views

### PowerShell Excel search replace issue with loop

What I'm doing here is to search excel sheet for a value, if value matches it will be replaced by first value in a given text file:
example:
search for value text find the first instance replace ...

**0**

votes

**1**answer

28 views

### Automate spreadsheet (Excel/CSV) workflow

I'm looking for a tool or process to help automate repetitive workflow tasks that require with an Excel or CSV file to be in a specific format.
For example, we work with vendors that send us a list ...

**1**

vote

**1**answer

19 views

### How do i right align an icon set arrow under conditional formatting so that both number and arrow are on right side of cell neatly together?

Cell displays a conditional format arrow Icon set which is on far left side of cell. The number in that cell is right aligned and I want to bring the arrow directly next to the number. I want the ...

**1**

vote

**1**answer

22 views

### How to use a variable once, across the equation, in Excel 2007?

okay, is there a way to declare a variable inside a cell, without calling the cell name 3 times, across the equation(?)?
I came up with this, to calculate the age from a DOB entered using the ...

**0**

votes

**0**answers

17 views

### Compare and update two worksheets automatically [duplicate]

I wonder if it's possible to do the following in Excel:
I have a spreadsheet that contains two worksheets. Sheet1 is a master sheet containing columns such as Customer Reference Number, Completion ...

**0**

votes

**1**answer

13 views

### How to delete creating automatic back up file for MS Excel?

Every time I use a file Excel it generate an automatic back up file.
How can I disable this feature?
I use MS Office 2007 with Windows 7

**0**

votes

**1**answer

13 views

### How to create a dynamic date title in excel 2010 using different tables and data

My friend has asked for help with an excel assignment and they have 2 tables, HRM and Data_Tables.
Data_Tables has corresponding month numbers from 1-12 in column I from I3-I14. In J column there is ...

**-1**

votes

**0**answers

15 views

### Add a cells content to another cell if cells at the top of the columns have only specific content

I already have a big part of this done thanks to another user, however I need it to go one step further please.
I want to add the contents of cells in a specific row, based on a SUM formula. I want ...

**0**

votes

**1**answer

17 views

### Excel Conditional Formatting greyed out

So I have a sheet open in Excel 2013. I have come to add some conditional formatting and cannot do so due to it being greyed out.
My suspicion is that it is due to this [Group] thing. I know that ...

**2**

votes

**0**answers

34 views

### align column with text and numbers [duplicate]

In Excel, I need to align on the decimal point a column of numbers that contains a mix of:
numbers, and
numbers followed by x's
For example, the following data should be aligned as:
0.100
...

**-1**

votes

**0**answers

18 views

### Convert macro to save as Excel file and not PDF [closed]

Sub SaveAsPDF()
Dim fName As String
Dim StartRow As Integer
Dim EndRow As Integer
Dim a As Integer
With ActiveSheet
fName = .Range("AA17").Value & ".RG116.150420." ...

**1**

vote

**1**answer

17 views

### Lining up sets of data in Excel (both with unique keys)

A related question asks how to line up two sets of data in Excel. I am struggling to figure out how to do this when you have values in both lists which don't exist in the other list. Ie: how would ...

**2**

votes

**0**answers

20 views

### Taking an indirect reference in excel and making it a direct reference

For many somewhat complicated reasons -- it has to do with transposing columns and rows because of third party software limitations etc. -- I have had to use the indirect function in order to make ...

**1**

vote

**2**answers

29 views

### In Excel, what is the appropriate function to use to find an item in a column that corresponds to an item in a column beside it?

Imagine that I have an Excel column
ABC
DEF
GHI
JKL
MNO
Then I have the following table
option1 | ABC, DEF
option2 | GHI, JKL, MNO
option3 | PQR, STU .... (could be hundreds of comma separated ...

**3**

votes

**1**answer

35 views

### Excel to count number of concurrent sessions based on start/end times

I have a massive set of data that I'm trying to work through. In Column A, I have a username, in Column B I have a session start date/time, in Column C I have the session end date/time.
I am trying ...

**2**

votes

**0**answers

18 views

### How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...

**0**

votes

**2**answers

36 views

### Check if a cell contains any of words from a dynamic list

I want to use a formula to populate the "RESULTS" cells. I need it to check if the adjacent "CHECKED CELL" contains any of the words listed in the "KEYWORDS" cells.
Ideally, I would be able to add ...

**0**

votes

**0**answers

8 views

### How to save .xls file to tab-delimited(.txt) and specify Shift-JIS encoding

What I want to do is save .xls file to tab delimited .txt file with specifying SHIFT-JIS encoding. I tried specifying encoding in web options however when I save to tab delimited still japanese ...