**0**

votes

**1**answer

12 views

### How to display a given number of names randomly selected from a list

I have a list of 148 names in Column A. I need a function that would let a user enter in a number and use that number to return a list of names in column B or C. There can be repeats. So column B ...

**0**

votes

**0**answers

7 views

### Trying to start a file upon opening Excel 2013 using XLSTART

How do I get excel to load an certain file using xlStart.
I found C:\Users\mdowney\AppData\Roaming\Microsoft\Excel\XLSTART
Added the file and its not working.

**0**

votes

**1**answer

12 views

### Lookup and match functions

I have a problem that I have been unable to solve, or find a result that works for me.
I have a sheet with data entered from a lab. The dates are based on sampling time, and each sample point is ...

**0**

votes

**0**answers

13 views

### How to make mouse scrolling in Excel behave as page up/page down?

In Excel when I press page up/page down it always scrolls at most 1 page and jump exactly to the next row that was not display fully (if the current row isn't taller than the window, of course). This ...

**0**

votes

**1**answer

21 views

### I need a formula so that if a value in column a change then add +1 to the value of another column

I have a list of product codes in column A. In column B i have a list with text values which i will call "positions" (1B 02 1 etc). In column C I give a serial number for each product code (52001001). ...

**0**

votes

**1**answer

10 views

### In Excel, will a custom default template be applied to **all** files (or only to new, blank ones)?

... where by all Excel files I mean to include, for example, those received via email from other people (who might be using a different Excel template) or an Excel file pulled off a database.
Will a ...

**0**

votes

**1**answer

11 views

### Can a “Custom View” be stored to a custom default template and thus be made available to all Excel workbooks, new and old?

Repetitive daily task:
Pull Excel sheet ("workbook") from database.
Adjust column widths.
Apply certain filters to certain columns.
Apply some conditional formatting here and there.
Objective: I'd ...

**0**

votes

**0**answers

5 views

### How can I open a PDF to a certain page from within excel?

I would like a macro code for Excel 2013 that will open up a certain page upon clicking a button in the excel cell. I am using the below code, but it is working intermittently. Please help with a ...

**-1**

votes

**1**answer

12 views

### IF Function Result not shown

I have a formula in a IF function but it does not appear as the result
=IF(J5-TIMEVALUE("00:30")
Example :
I got a start time at 10.10am and end time at 10.50am
the time diff is at 40min, the IF ...

**1**

vote

**0**answers

7 views

### Bloomberg - Excel VBA Macro to email Bloomberg <CN> screen via <GRAB>

I am looking to develop an Excel-Bloomberg macro. The excel spreadsheet will be linked to a Bloomberg Add-In and of course, a Bloomberg Terminal. The objective of the macro is to have a list of ...

**1**

vote

**3**answers

30 views

### Counting zeros in a filtered column of numbers

I have a long filtered list of numbers next to names. I am trying to count the zeros as I change the filter. Unfortunately COUNTIF includes cells that have been excluded by my filter. How can I count ...

**0**

votes

**1**answer

23 views

### Create multiple rows based on repeated columns

I have a csv (technically, an Excel spreadsheet) that has rows/columns like this:
AC-10 ECLO-1 ECLO-2
AC-11 PESL-1
AC-13 ABCD-2 ABDE-3 AGTU-5
What I'd like to do is create two columns so ...

**0**

votes

**2**answers

22 views

### Get Excel function that expects a list to use the contents of a cell

A recent question involved cells that contained a comma-delimited list of values, each if which needed to be individually selected and manipulated. The data looked like this:
Cell B1: ...

**0**

votes

**4**answers

41 views

### Way to learn Excel without buying it

Is there a way to prepare for a job requiring Microsoft Excel knowledge without having to buy an Office license? Is there a free alternative that is nearly identical, or is there a way to get a legal ...

**0**

votes

**1**answer

33 views

### How can excel take two seperate cells with comma seperated data and pair them up?

I have looked all over for an answer to this and seem to be stuck fast.
I have something like this:
Cell B1: 01/01/2014,01/02/2014, 01/03/2014, 01/04/2014, 01/05/2014, 01/06/2014, 01/07/2014, ...

**0**

votes

**1**answer

34 views

### How to fill down formula so that range references are offset by 5 rows rather than by 1 row

How can I get Excel to increment ranges arguments by more than one row when I fill down a formula?
For example, if I want Excel to keep averaging the next five numbers in a column, how do I set the ...

**0**

votes

**2**answers

18 views

### Excel Highlighting First Empty Cell Below An Entry

I've been trying for hours what I thought would be simple but clearly is not for me!
I have a column where every ten cells has the word "TRUE" in it, the rest of the cells in between are empty. So it ...

**0**

votes

**2**answers

19 views

### Difficulty with Nested IF in Excel

So, what I want this formula to do is look at cells I3, K3 and M3 and to place results in R1. If cells K3 and M3 are at 0, then I want 50% of I3 to be placed in R1. If K3 has any value above 0, and M3 ...

**0**

votes

**1**answer

14 views

### Adding another value in Excel cell/column if another cell has particular value

I wanted to be able to create a macro to change the value in Cell B to EPTBSIET if it equaled that value in Cell E - SIETCO. I've been able to compile an IF formula but would rather have the value not ...

**0**

votes

**1**answer

14 views

### Link workbooks in Excel

My code:
=OFFSET(INDIRECT("calculos.xlsm!_" & A149);14;6)
Shows "REF!", unless the linked workbook is open.
Can I get the value to show, even when the linked workbook is closed?
Thank you all!
...

**1**

vote

**1**answer

19 views

### Excel duplicates in one column based on another

Hoping someone can assist with this. We have a spreadsheet with data as below:
A B C D E F G
777142 233 4 45151 te01-ccm 0
777303 233 6 45151 te01-ccm 0
...

**0**

votes

**2**answers

13 views

### How To Extract Pattern from a folder path (VBA Excel)

I'm pretty new to vba excel and trying to reorganise a very large file structure. Basically, all our equipment has a tag in the form of [A-Z][0-9]0-9][0-9][A-Z] e.g. J452G being a compressor. Every ...

**0**

votes

**0**answers

15 views

### Excel 2013 - Table connection problems

Okay I have a real problem on my hands and have spent several hours trying to figure this out. When I add a new column to and external data table (RP_DASH) the additional columns moves the data around ...

**0**

votes

**2**answers

25 views

### Changing pricing Excel 2007

I need to update all pricing to end in .15 no matter what it currently reads.
As of right now I have formatted the cells to only show two digits past the decimal, but when I click on the number, it ...

**0**

votes

**1**answer

24 views

### Excel 2013 - need age that is input to reference numerical value

I am creating a spreadsheet of insurance rates from a number of companies. I would like to input the age of the individual once, which would then populate figures for each of the companies, retrieving ...

**-2**

votes

**1**answer

22 views

### Find salesman sales between two Excel tabs

I have a spreadsheet with over 100 salesman's sales on two two tabs. On tab 1 is the person's sales number (ex. 5233) with his monthly sales. On the tab 2 is his quarterly sales. I need to add his ...

**0**

votes

**2**answers

17 views

### Match-Search function in Excel?

So I've got 2 columns. Column "Mess" has gazillions of random numbers x digits long. Column "Check" has specific sorted numbers. Now I make a 3rd column called "boolean".
I want a function to check ...

**1**

vote

**0**answers

17 views

### Why does Excel 2013 Ignore My Keystrokes?

So I was doing some copying and pasting into this new Excel file, and all of a sudden the keyboard is not being recognized in Excel.
I also am unable to save this file. Anyone have ideas?
Here is a ...

**0**

votes

**3**answers

30 views

### How can I merge 2 sheets in excel?

I have to update a defect database in excel that is filled with data that fluctuates between 160 to 700 rows every day. This database has 19 columns, some of which are numerical and some are ...

**0**

votes

**0**answers

19 views

### How can I type one keystroke YET return something else?

I want to be able to type one character in a cell and have it return something else so I do not have to type it over and over
I am making a schedule spreadsheet so instead of typing 7/11 or 3/11 ...

**0**

votes

**3**answers

15 views

### Create custom parts for the header and footer in Excel

I have a spreadsheet with several worksheets. On each printed page of each worksheet I would like to have references to some fields that i define somewhere in the document.
More specifically, i would ...

**-1**

votes

**0**answers

10 views

### Excel - pasting text opens “save as” dialogue box

I'm copy/pasting text in Excel. Whenever I use Cntrl-V or paste - it opens the "save as" dialogue box. This freezes the spreadsheet. How do I stop this from happening?

**0**

votes

**0**answers

10 views

### Excel referencing: Go To Box does not fully have the whole path

When I reference to another workbook in the formula line I see the whole path to the workbook. So that is good. But when I have the referenced workbook closed (the one I get figures from) and I want ...

**2**

votes

**1**answer

20 views

### How do I copy a column of numbers to another column while excluding cells with zero or blank?

I have a column containing zeros, blanks, and numbers greater than zero. I want to copy just the cells containing numbers greater than zero to another column of contiguous cells (no placeholder cells ...

**0**

votes

**1**answer

20 views

### Excel: Matching and counting records (rows) to multiple conditions and unique values

I have two sheets: ‘Data’ and ‘Report’. In the report sheet, I need to calculate some data which requires 3 different formulae.
The Data sheet has column headers in row 1 and many records of data in ...

**0**

votes

**1**answer

12 views

### Two Dimensions Generated Table

I have a two dimensionnal table. And I'd like to fill it up like a multiplication table with Excel. But I can't find an easy way to do it.
Copying-Pasting the columns or the ligns doesn't work.
----- ...

**0**

votes

**0**answers

12 views

### Horizontal/Column filtering in Excel? Should be simple

In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value ...

**0**

votes

**1**answer

17 views

### How can I return corresponding value from Master List by comparing Child List?

I have 3 columns MasterList, Value and ChildList. Now I want to compare Childlist against Masterlist and get the value from corresponding MasterList.
I have below values in worksheet.
MasterList ...

**-1**

votes

**1**answer

34 views

### How can I alphabatize the word TRUE in excel?

When I type the word TRUE in an excel cell, it centers it and when I try to alphabetize a column which includes TRUE it puts it at the bottom. How can I make excel treat the word true just as a word?
...

**0**

votes

**1**answer

19 views

### Convert Array to String with Excel Formula, is it possible?

Convert Array to String with Excel Formula, is it possible?
I know how this would be done with VBA, but I have to share my workbook, and I have to assume that other people will not be able to enable ...

**0**

votes

**1**answer

18 views

### Auto-Fill excel columns with formatting

I'm trying to create a To do list that I can easily manage in excel.
In column C, I would like to press 'd' - and the cell automatically inputs done, and changes the background to green.
The letter ...

**-1**

votes

**0**answers

19 views

### I would like a macro to find a cell, then input a number 1 [on hold]

I have a spreadsheet with names in a column and years along the top row. When I do a particular piece of work, I want to run a macro to input a 1 in the appropriate cell to show the job has been done ...

**-1**

votes

**0**answers

12 views

### How to write expression to diplay multiple series on same graph in Excel?

I need to plot 3 series to same graph. I cannot select by mouse because it's opened from onedrive.live.com I successfully map one series like that:
=Sheet1!$C$12:$C$19
I need to map also ...

**0**

votes

**2**answers

29 views

### Find most frequently used value

I know that that question has been asked before but my question needs more scalable solution!
I have a column G with States, there are 10,000 States in that column.
I need to find out what is most ...

**2**

votes

**1**answer

24 views

### How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows:
Unknown
Very High
High
Medium
Low
Very Low
None
I like the visual cues provided by ...

**0**

votes

**2**answers

29 views

### Excel: Do not open files in multiple instances

How do I open all excel files in the same instance/window by default (happens only when I open from the menu, but not from the windows explorer)?
I have this option unchecked, but is still not ...

**2**

votes

**2**answers

26 views

### Dynamic formulas based on other cell formula results

I have 10 years of monthly data for 300 plants. While Excel can do moving averages for various time periods I am looking to do a moving median value for this data set.
I can obviously figure out the ...

**0**

votes

**1**answer

33 views

### How to disable specific Excel 2010 add-ins at startup?

I want to disable specific add-ins from loading in Excel 2010 every time I open up a new workbook or instance. How do I achieve this?
When I disable the specific add-ins by unchecking them in the ...

**0**

votes

**1**answer

32 views

### Word document loads incredibly slow

I have a word document (286kb) which takes almost 2 min to load. The document contains a large number of excel objects (as links from the same workbook).
This is what I've tried:
Remove the "old" ...

**1**

vote

**0**answers

15 views

### Feeding Data from SQL Server to Excel Template with visual studio c++ program [on hold]

I started a projet of automatic reporting.
To realize this i am using Microsft Visual Studio 2010 C++ (Ultimate edition)
Right now the project is almost finish, but i am getting stuck at the last ...