# Tagged Questions

**0**

votes

**0**answers

4 views

### Finding Consecutive Values in Excel (Cluster)

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 (minimally) ...

**0**

votes

**1**answer

13 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

15 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

17 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

**3**answers

46 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

9 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

8 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

18 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

8 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

28 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

27 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

37 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

20 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

20 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

32 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

40 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

20 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

18 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

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

**0**

votes

**1**answer

18 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

12 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

13 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

19 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

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

**0**

votes

**0**answers

11 views

### Using IF to compare name of a worksheet with worksheets in workbook

I have two files Main file and Result.
Main file have multiple worksheet like delhi, moscow, paris, scotland and each one has same type of date and same heading ie.:
S_No. , Vendor, VendorId, ...

**-1**

votes

**0**answers

14 views

### Picking up data in excel with the date check

Let's say I have the following data:
On the first row, there (mostly) will be dates in specific format. But sometimes there can be some texts as well.
Now, I would like to get the average values ...

**1**

vote

**1**answer

27 views

### I am trying to use the if function to look at cells to the left and leave the cell blank if they are blank or calculate if they are not

I am trying to use the if function to look at cells to the left and leave the cell blank if the reference cells are blank or calculate if they are not. for example I have E14 that im putting the ...

**0**

votes

**1**answer

27 views

### Attendance Tracker - Deduct points if no points within pay period

I have a spreadsheet where I keep track of whether or not someone called in, was late or left early. On the 1st sheet I have their names, the number of times they've called in, were late or left ...

**0**

votes

**2**answers

54 views

### How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)?
Let's say the choices ...

**0**

votes

**2**answers

21 views

### Locate Cells With a Simple Criteria

I have data like:
I need to locate (get row numbers) for cells starting with the letter A.My current approach is to use a "helper" column. In B1 I enter:
=IF(LEFT(A1)="A",1,"")
and in B2 I ...