**0**

votes

**2**answers

418 views

### Is there one simple formula for Excel that can identify a string contain non-ASCII Characters?

I know that using the clean formula, I can clean up some of the non-ASCII characters (such as additional non-printable ASCII control characters #0 through to #31, #129, #141, #143, #144, and #157 ...

**0**

votes

**1**answer

34 views

### Select cells based on other column

In Excel I have the following situation:
_ A B
1 3 M
2 8 F
3 7 F
4 6 F
5 1 M
6 3 M
7 9 F
I want to select the maximum value from column A where column B is M.
How can I accomplish that?

**0**

votes

**1**answer

55 views

### Excel 2010 IF() statement assistance

I need assistance converting this to an Excel formula or VBA script. Let me know if you have questions. It needs to run on each row starting at row 2 until row 30. This is an example of what would ...

**1**

vote

**1**answer

532 views

### Split a Data column into automatic groups based on value ranges

I have a column that contains the final output data that I am interested in processing, the data in this column gives results that fall into groups that are very close in value. Once I sort them in ...

**2**

votes

**1**answer

51 views

### Hyperlink function to certain cell on another Excel document

I want to make a hyperlink that goes to a certain cell on another Excel document. This is the formula that I have tried to accomplish this:
=HYPERLINK("[C:\Blender\H) Blender Modelling Basics ...

**1**

vote

**0**answers

94 views

### Word 2007 Merge Document - creating only one letter to recipient for multiple records

Record 1: Mary Smith, Barney
Record 2: Mary Smith, Pebbles
Record 3: Mary Smith , BamBam
Record 4: Bill Shoe, Rocky
For example, Mary Smith is listed in my database 3 times with 3 different ...

**3**

votes

**1**answer

830 views

### Toggled Hyperlink with If:Then formula [duplicate]

I'm attempting to make a formula that will toggle a hyperlink on or off depending on the argument. Basically, I want to make it argue the following:
If there is text in (Tab A, Cell A), then create a ...

**0**

votes

**1**answer

22 views

### if B2 matches U:U then return corresponding T:T

I am attempting to find matching numbers and return a revision.. basically brain stuck =)
if B2 matches U:U
then return corresponding T:T
any suggestions?

**1**

vote

**3**answers

78 views

### What does this SUMIF formula do?

I have a SUMIF formula that I can't figure out:
AB1/SUMIF(E:E,E1,AB:AB)
Column E contains text values: Other, Specific
Column AB contains dollar values.
I don't understand how the criteria ...

**0**

votes

**1**answer

224 views

### Create drop-down list from values in one column that share the value of a cell in another column

I am having a hard time articulating my need. So, I don't know the key words to use that will find a solution.
I have three columns:
Project_Number
Line_Item
New_Line_Item
A Project_Number can ...

**1**

vote

**2**answers

69 views

### Counting total number of subjects in excel

How do I count the total number of participants, if the same identifying "subject number" crops up in a column?
I.e for this case below I have 5 participants in total.
For eg.
99976
99976
106281
...

**0**

votes

**1**answer

5k views

### Using Mac Excel 2011: Can't find the Delete Duplicates for removing duplicate rows

I see lots of advice about Delete Duplicates but can't find the command at all. Looked under Tools and Data with no luck. Anyone else in the same boat - or if you know please let me know.
Thanks
...

**0**

votes

**2**answers

30 views

### Working on many columns in Excel

I have many columns in my excel sheet and I am working on them extensively (Sorting, counting etc.).
However, it's a bit complicated, for instance, when I want to move to the last column from the ...

**0**

votes

**1**answer

226 views

### Excel Conditional Formatting: 3 color scale scoring fuzzy matched data for Windows [duplicate]

This question is posted as a spinoff from here - the post cited is about Mac where as this is about Windows:
Conditional Formatting: 3 color scale showing text relevance in Excel for Mac
Is ...

**0**

votes

**1**answer

162 views

### Search Excel price grid with variable values

WIDTH
DROP 1150 1550 1850 2160 2360 2750 3000 3480 3980 4450
1200 338 348 378 413 431 450 467 513 ...

**0**

votes

**2**answers

322 views

### Paste alternate columns from one sheet to another, in alternate columns

I have two worksheets, I want to paste columns one after another from sheet1 to columns one after another. My data is like this:
Sheet1:
A B C D E F G H I J K L M N O ...

**-1**

votes

**1**answer

103 views

### How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ?
So, this...
A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB
...should split as below,
B1 ...

**1**

vote

**0**answers

157 views

### updating links in LibreOffice Calc xlsxfile results in err:509

I have just started to use Libreoffice so I am totally new to the system and immediately encountered a problem with a calc document.
The document has originally been made in Excel (but on a Mac) and ...

**1**

vote

**3**answers

1k views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**0**

votes

**2**answers

283 views

### Split single column data into multiple columns based on leap year in Excel 2013

I have about 100 files of MS Excel which consist of weather data.
I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time ...

**0**

votes

**1**answer

32 views

### Automatically place numbers in cell Microsoft Office Excel 2007

| | A | B | C | D |
|---|--------|-----------|-----------|-----------|
| 1 | Number | First | Second | Third |
...

**0**

votes

**1**answer

244 views

### Sage Line 50 ODBC Driver Causes Crashes in application when run

I can open up a connection to my sage line 50 version 2014 file via the odbc link in visual studio and see all the tables.
However, when I try to execute a query, the program comes up with "Visual ...

**0**

votes

**1**answer

44 views

### Excel - convert part of filename to mm/dd/yy date

In a spreadsheet that has the filename 05-20-14-transactions.xml ... how can I display the date in a style such as "5/20/14" or "May 20, 2014" in a field within that spreadsheet? Can a formula read ...

**0**

votes

**2**answers

80 views

### Excel 2007 IF AND function calculation not copying across

I'm using an IF AND function, which is:
...

**0**

votes

**1**answer

190 views

### How to lock a cell with formula in excel after the referred cell is filled?

I'm using "CONCATENATE" formula in excel and I would like to lock (or turn the formula into value in) the cell which contains the formula after the last referred cell is filled. Some of the referred ...

**3**

votes

**2**answers

139 views

### How to get rid of macro leftovers in Excel?

Old macro workbook from Microsoft samples gallery left items on the ADD-INS ribbon tab, highlighted by yellow:
These cannot be deleted or at least I don't know where to find them – see Customize ...

**0**

votes

**1**answer

7k views

### Excel borders are there but not shown on print preview and won't be printed

I want to print my excel document, it has box border, but I can't see them on print preview and when I print the document, borders are not printed.
Page margins are narrow enough, Page Layout tab > ...

**0**

votes

**2**answers

189 views

### Alternatives to Excel forms for data collection?

Currently I am receiving bunch of excel forms from many people each month and I need to consolidate them into one single report
Problems:
Even though I have given people a template to follow, the ...

**1**

vote

**1**answer

924 views

### Can the data validation list width be controlled in Excel 2007 and greater?

In Excel 2007, I can add data validation to a cell, and supply a list of allowed values.
However, experimentation suggests that the data validation drop-down list will never display at a smaller ...

**0**

votes

**2**answers

212 views

### VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance"
I read the documentation, and wrote this macro:
Sub add_category()
...

**0**

votes

**0**answers

166 views

### Scrolling issue with Dual Screen or external monitor (Laptop) Microsoft Excel 2013

There is a peculiar intermittent problem with Microsoft excel on one of my users' computers, when selecting a range of cells that is out of the visible area by clicking and dragging, you would expect ...

**1**

vote

**1**answer

879 views

### Set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

Is there a way to set the scale on a chart so that the primary maximum and minimum Y-values equal the same values on the secondary Y axis as well?
Basically I have a number of different stocks I'm ...

**0**

votes

**1**answer

67 views

### Convoluted Date Lookup

I found this, which is pretty close, but I don't know VB, so I'm trying to do this with a vanilla formula.
First worksheet has a series of tables of unemployment rate: 1 per US state. Each table ...

**0**

votes

**1**answer

129 views

### SUMIF with multiple match criteria in Excel

I'm trying to create a formula so that if in cell E2 it says "Market", "Limit", or "Stop" it adds the numbers in cells L2 and M2.
=SUMIF(E2, "Market" "Limit" "Stop", L2+M2)
These expressions are ...

**0**

votes

**1**answer

180 views

### Change border color of selected cell

When I select a cell in Excel for Mac 2011 it is shown with a blue border:
How can I change the color of this border?

**0**

votes

**1**answer

148 views

### How do I select rows in Excel based on logic?

I'd like to select entire rows based on rules.
For instance:
How would I select all the rows where column A is greater than 3?
How would I select all rows which contain a string in Column A ...

**0**

votes

**1**answer

61 views

### How to merge data into single output

Okay here is what I have. How would I get the three identical wishbone plays to merge and sum their data?
Yes the data is already sorted by formation. I don't mind inputing it each time as I will ...

**12**

votes

**2**answers

4k views

### Can I make Excel beep when a calculation is finished?

I have these really long calculations in Excel. I'd like to divert my attention from the screen and get something done at my desk, but be alerted for when the calculation is finished.
Any ideas?

**3**

votes

**3**answers

1k views

### How do I write a formula in excel that lets me evaluate if each value in a row is TRUE?

Basically, I want the most efficient way to do something like the following in the most efficient way possible and with a lot more columns:
=and(f2=true,g2=true,h2=true,i2=true)
Thank you.

**2**

votes

**0**answers

442 views

### Add custom error bars to multiple series in one graph

I have my data in a csv file like below, except with more columns and rows
Mean values 61 43
Sample 1 0.009 0.059
Sample 2 0.108 0.099
Sample 3 0.043 0.038
...

**0**

votes

**1**answer

113 views

### How to copy select cells in column from Excel speadsheet

When I select specific cells within a column, Excel ends up copying the entire range of cells instead of just the ones I selected. I am using CTRL + LEFT MOUSE ClICK to select the cells. How do I copy ...

**0**

votes

**1**answer

20 views

### Remove symbols while appending in excel

I'm having some parsing issues here. I have a column of Twitter handles, with '@' in front of them, and I'm trying to auto-append them in a URL on the next column.
Example:
| @Bob | ...

**1**

vote

**1**answer

230 views

### Import from Folder data source missing from PowerPivot

If I look around on the Internet, I see people have the ability to import all files from a given folder:
...

**0**

votes

**1**answer

24 views

### Can I get Copy and Paste to note transpose, exactly as happens in Cut and Paste?

When I copy and paste, then excel moves the cell references down. E.g. References to cell B2 on line 3 become references to line B3 on line 4.
With cut and paste, this doesn't happen, and references ...

**0**

votes

**2**answers

66 views

### Averageing numbers in a column while ignoring rows with headers

How do you average the numbers in a column and ignore those rows with text, or zero or null?

**0**

votes

**1**answer

55 views

### Can I create a cell with enumerated values in a csv file

Can I create a cell with enumerated values in a csv file?
For example, I want a cell that can only get the values:
a) "value1"
b) "value2"
c) "value3"
Is this possible?
PS:
I have used this ...

**0**

votes

**2**answers

892 views

### Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS.
There is a mistake in my formula but I can't find a way to have it since ...

**-2**

votes

**1**answer

46 views

### Using ms-excel to search and reduce particular repeated values to single value?

I have excel document which has IP address as
SourceIp
192.168.2.4
............
............
............
............
192.168.2.44
192.168.55.4
............
............
............
............
...

**1**

vote

**2**answers

11k views

### Excel scatter plot with multiple series from 1 table

Say I have a table as follows:
Label | X | Y |
A | 1 | 1 |
B | 2 | 2 |
B | 3 | 2 |
A | 4 | 3 |
C | 5 | 4 |
A | 4 | 3 |
C | 2 | 1 |
How ...

**-3**

votes

**1**answer

99 views

### Is there a way to disable jumping on cell border double click in MS Excel? [closed]

I'm going crazy over the jumping "feature" when double clicking a cell border in Microsoft Excel. Is there a way to disable it?