**0**

votes

**2**answers

38 views

### Microsoft Excel convert Oct to 10

Can anyone help me please? I need to convert MMM to NN e.g. Oct to 10 I'm not a superuser but would really appreciate anyone's help.

**0**

votes

**1**answer

16 views

### Extract specific data from a text file and import it in Excel

I have a .txt file with lot of information, but I only need the numbers from Mean Absolute Error and Root Mean Squared Error. How can I automate and extract the numbers and put them in a Excel table.
...

**1**

vote

**1**answer

7 views

### In a VBA program to recognize a new row entry and populate a formula into a cell (gsheet)

I'd like this formula =IF(C1="TOTAL",COUNTIF(C$1:C1,"TOTAL"),ROW(A1)-COUNTIF(C$1:C1,"TOTAL")) to be automatically populated into a new row entry/ when a new row is added.

**1**

vote

**0**answers

18 views

### How to save Ping record in every single hour for 2 weeks?

how do I save the record ping "in every single hour" for a certain period, for example for 2 weeks, with the format dd / mm / ss, dd / MM / YYYY and beside it is the result of the ping.
So we can ...

**0**

votes

**0**answers

16 views

### Index/Sumproduct calculation error

I have been working on an excel problem for the better part of 24 hours. I have a formula that almost does what I want but it is not returning what I imagine it should return:
...

**0**

votes

**1**answer

13 views

### Excel histogram with discrete “bin numbers”

I have a column of data similar to this:
1
1
1
1
1.2
1.2
1.2
2
2
2.1
2.2
3
3
3
3
4
I want excel to display how many 1 values, how many 1.2 values, how many 2 values, etc. I know I should use ...

**-1**

votes

**1**answer

14 views

### Mail Merge Multiple Rows into one document

I have an excel file with different fields in each column:
Field 1__ | Field 2__ | etc.
F1 Item 1 | F2 Item 1 | etc.
F1 Item 2 | F2 Item 2 | etc
each field has a different number of items in it.
...

**0**

votes

**0**answers

10 views

### CF Cells with Different Values for Rows with the Same Value in Specific Column

I need to conditionally format cells with different values between the same columns, if their value for a specific column is the same.
How can I do this?
I have access to Excel 2010 and 2013 to ...

**1**

vote

**1**answer

23 views

### How to count blank cells at end of row in n-column table

Suppose I have a table with 50 rows and 50 columns. Each row has a certain number of blank cells, often occurring in the last few columns, with the first few columns being relatively dense. I would ...

**0**

votes

**1**answer

7 views

### Excel does not import Guids (Unique Identifiers) when importing data using the “External Data” feature

When I try to use Excel 2013 to import External Data from a SQL Server Data Source, it does not import the Guids.
The Query I'm using is:
SELECT * FROM TABLENAME
The table Structure is:
ThingId ...

**0**

votes

**1**answer

23 views

### Powerpivot; Get a datadump from SQL vs creating a data model in excel

I have a SQL table that includes sales and lead data along with detailed account information, and I have another table that just includes detailed account information.
My question is whether it is ...

**0**

votes

**0**answers

8 views

### Excel quadratic trendline formula wrong?

I made a scatter plot graph on Excel, however the trend line formula does not replicate the values shown. Currently I have have this file here. Why is the formula not replicating properly and how do I ...

**0**

votes

**1**answer

25 views

### Is there a function to get the cell your equation is pointing at as the output rather than the value inside the cell?

For example if I had an function such as vlookup that put me into a cell could I then have another function that gives what cell it found rather then the value inside the cell?

**-1**

votes

**2**answers

35 views

### How to compare multiple columns and set values based off of it

I Reference to the picture in the link below, I need to find the best way to compare which Start Month and End Month row the current month is between and then set a cell somewhere else in the spread ...

**0**

votes

**2**answers

20 views

### Excel Formats Numbers as Dates

I have several very large .csv files that I need to work with, and Excel makes this very easy (obviously). One of the fields is in the format 10/3/2013 19:00, and Excel automatically converts this to ...

**0**

votes

**2**answers

20 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

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

**12**

votes

**2**answers

570 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

**3**answers

14 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

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

**0**

votes

**1**answer

12 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

18 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

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

votes

**0**answers

16 views

### How to limit a loop until there is data in a certain range [on hold]

I'm in the following situation:
In Column A I have some Ac numbers and in column B I want to have a vlookup with their values ( listed in a separated spreedsheet), the fact is that according to 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?

**0**

votes

**1**answer

13 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

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

**-2**

votes

**0**answers

20 views

### Excel #value Error [on hold]

I am trying to get data from one worksheet to another by simply hitting +, then going to the worksheet and cell and selecting it. I have found that part of the probelm is that the cell I am trying to ...

**-1**

votes

**4**answers

53 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

**2**answers

39 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

48 views

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

Is it possible for the numbering in column A to 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 ...

**0**

votes

**1**answer

31 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

42 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

16 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

12 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

18 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

28 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% ...

**0**

votes

**1**answer

47 views

### RIDICULOUS EXCEL FORMULA, IF [#] minus [#] and > [Date] [on hold]

Im trying to create a formula for the below example:
cells A1-A15
MOS #'s 0311,0352,0341
cells E1-E15
End of Tour Dates
First I need to get the count of the MOS #'s for each SPECIFIC MOS, ...

**1**

vote

**1**answer

17 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

12 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

**0**answers

19 views

### Issues with sumproduct multiple cell look up [on hold]

I'm trying to look at the value of 3 cells and look for the answer in a corresponding table. I have this same formula set up for different variables which look at the corresponding table as well, ...

**0**

votes

**1**answer

12 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

28 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

18 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

20 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

19 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

22 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). ...