**0**

votes

**2**answers

21 views

### Multiple data tables in excel

I'm having problems building a data table off values that come from another data table. For example, with a black-scholes option pricing model, I first get the value of options at different strikes ...

**0**

votes

**3**answers

76 views

### Excel multi-criteria VLOOKUP

I have a really simple question for someone that uses excel regularly...
I have a data (Data) sheet and a report generation sheet (Report).
I'd like to grab a cell value from the data sheet and ...

**13**

votes

**2**answers

645 views

### Excel does not honor the delimiter setting for reading or writing CSV files

When saving/opening CSV files in Excel, the default separator is a semicolon (;), as I need it to be a comma (,) I tried to change it by changing the Language and Regional settings following several ...

**0**

votes

**2**answers

20 views

### Applying Conditional Formatting in Excel

I have a column called Result in my excel sheet. For this column 'K', i have applied Data Validation and now the entire column can take only 2 values i.e Pass, Fail.
Now using conditional formatting ...

**-1**

votes

**1**answer

28 views

### How to make COUNTIF only count subtotal for visible records when filter is applied

I would like a formula to COUNTIF the Brand 3 column and if filtered the COUNTIF changes to filtered criteria.
TOTAL COUNT 0 0 3 COUNTIF(H3:H5,"VoID")
Area ...

**1**

vote

**1**answer

21 views

### Excel 2010 PowerPivot: How do I avoid apostrophes being displayed as â€™?

When I import a text file to PowerPivot containing apostrophes, they are automatically converted to â€™.
I've been manually correcting the few that I find in the PowerPivot window, however when I do ...

**0**

votes

**1**answer

20 views

### Excel lookup by cell value in another broad cell

I have two different excel tables. one table column contains first name of employee and another table contains multiple first names in one cell and their other values.
for Example.
first table
...

**0**

votes

**2**answers

42 views

### Find partial text in Excel 2013

In Excel 2013 I would like to find the value in column B in the row where a string matches a string in column A. What complicates it is that the strings in column A are allowed to be shorter than the ...

**1**

vote

**2**answers

27 views

### Copying the background image in Excel

I use Excel 2003. I have an Excel document, and I need to extract the background image from a sheet in order to put it in other sheets of this document. How can I do that?

**4**

votes

**2**answers

73 views

### Transferring information from a row of data in an excel document into a web form

I spend hours on end every week transferring information from an excel file into a webform. Right now I am copying and pasting each cell individually. What I would prefer to do is select a row in my ...

**0**

votes

**1**answer

16 views

### Excel 2013 Data Validation List no longer works in my workbook

I am using Microsoft Office Professional 2013 with Excel 2013 on a Window 7 Enterprise Laptop.
I have run into a problem that I cannot correct. I have a worksheet that I have been tracking data in ...

**-1**

votes

**4**answers

63 views

### Splitting up an address into different cells

I have column of addressed in this format:
120 Lemon Street Columbus OH 92738 (Basketball Courts)
And I need to split it up into: street address (120 Lemon Street), city (Columbus), state (OH), zip ...

**0**

votes

**3**answers

51 views

### Excel last appearance of a given string in a column

I am using the LOOKUP function to find the last appearance of a given string in a provided column, like this:
LOOKUP(A3;Runs!D3:D6;Runs!A3:A6)
However, the bounds in the vector are hard-coded: ...

**0**

votes

**1**answer

19 views

### Separating a cell by first occurrence of a number

So, I have a bunch of cells like this:
Freddie’s Restaurant 102 Super Lane San Diego California
and I want to pull out the name, which is always preceding the start of the address (102 Super...). ...

**1**

vote

**0**answers

13 views

### Multi Series Graph on Excel for Mac

I'm trying to fit twelve different series on a scatter plot with x and y variables. Excel doesn't seem to recognize this. How do I design this graph? All I keep getting is this:

**0**

votes

**1**answer

71 views

### Auto Sequential numbering based on cell criteria - create two independent automatic numbering sequences

How to make the numbering in column A skip any rows that have the Word "TOTAL" in column C but pick right up again in the next rows? At the same time can the rows with the word "TOTAL" in column C ...

**0**

votes

**1**answer

38 views

### How can I list data and create a summary table?

Let's assume I have a table with sports results somehow like this:
player A | player B | 2 | 1 | player C | player D
player C | player B | 1 | 2 | player E | player A
As shown in table, there are ...

**-1**

votes

**1**answer

48 views

### Time Range Checking

Table A
Agent login date logout date working time(hrs) Actual working time(hrs)
B 10:00 AM 12/1/14 11:00 AM 12/1/14 1:00 0:30
A 3:00 PM 12/1/14 ...

**1**

vote

**1**answer

21 views

### Why does Excel only invoke the Text Import Wizard for .txt files?

Excel ignores comma delimiters in .csv files, but invokes the Text Import Wizard for .txt files that "appear delimited". Surely it should behave the same way for .csv files?

**1**

vote

**0**answers

9 views

### Windows Xperia excel 2010

I have 50 work books each work book is for 1 subcontract operative. Also each operatives work book has 52 sheets one for each week. I need to extract the same cell (£ payment total) to list the weekly ...

**1**

vote

**1**answer

18 views

### Searching for a Specific Text Font in Excel

Is there a text font in Excel for which all words with the same number of letters share the same space horizontally? For example, one of my column is
AAACCEINPU
AABBEILMTT
AABCEILLMP
...

**1**

vote

**1**answer

19 views

### Excel select to end of adjacent column

I'm using Excel 2010 on a Mac. If I hit CMD + shift + down arrow, the current column is selected to the end of the column. Is there a keyboard shortcut that, instead of selecting to the end of the ...

**0**

votes

**1**answer

31 views

### similarity as a percentage

I'm currently trying to find an Excel formula that will give me a percentage of words correct.
Example:
Cell A1: sit ubu sit good dog
Cell B1: sit obo sit good dog
Formula cell should reflect 80% ...

**1**

vote

**1**answer

20 views

### Transposing data from single column list to multi-columns

I have an Excel spreadsheet which is tens of thousands of entries long but it's not organized. All the data is in a single column with each entry taking up 3 rows followed by a space.
For example:
...

**0**

votes

**0**answers

18 views

### Excel power view error;E_FAIL

As mentioned on this youtube video tutorial, I want to use excel 2013 power view but got this error;
Error HRESULT E_FAIL has been returned from a call to a COM component.
The E_FAIL code means the ...

**0**

votes

**1**answer

14 views

### How to marry 2 slightly varying data sets into one workable file

Hopefully I’m thinking about this logically….
How does one match up two different data sets but yet similar into one workable file. For example, I have a master data set list out a hospital name, ...

**0**

votes

**1**answer

33 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

29 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

**2**answers

21 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

20 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

23 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

16 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

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

**1**

vote

**0**answers

14 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

13 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

17 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

33 views

### Counting zeros in a filtered column of numbers [duplicate]

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

30 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

**1**answer

27 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

52 views

### Way to learn Excel without buying it [closed]

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

37 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

45 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

21 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

24 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

17 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

16 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

25 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

44 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

18 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

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