Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
3answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
3answers
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
2answers
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
1answer
32 views

Automatically place numbers in cell Microsoft Office Excel 2007

| | A | B | C | D | |---|--------|-----------|-----------|-----------| | 1 | Number | First | Second | Third | ...
0
votes
1answer
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
1answer
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
2answers
80 views

Excel 2007 IF AND function calculation not copying across

I'm using an IF AND function, which is: ...
0
votes
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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?