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)

-1
votes
0answers
19 views

Track changes on the cell and return in a counter for every update [closed]

I am looking at a typical scenario, I would like to check if the contents in a specific range, eg B10:B50, is updated or changed then return 0, and for every change to return +1. I am not getting ...
0
votes
1answer
16 views

How To Autofill (Using VBA) Until Adjacent Cell Equals a Particular Value

I want to autofill a data validation list down in column E. However I want to stop the autofill when it reaches a particular value in an adjacent column (column B). For example, I have 50 rows in ...
0
votes
1answer
25 views

Adding Index to Match formula

I have the formula below working correctly, it is returning the max value in column G when the other conditions apply (valumes in B and F). However now I know what the Max number I want to return the ...
0
votes
0answers
11 views

My image wont show up when I insert picture from file in Excel

I am trying to insert a picture into an excel spreadsheet. I follow the normal procedures, but when it brings it into the excel sheet it either says "Image cannot be displayed" or shows up a clear ...
0
votes
0answers
13 views

VBA to paste pipe delimited information [closed]

I have been stuck trying to write a macro to paste in copied data (from unix) that is pipe delimited into excel. Is there anyway to do this without going through the process of opening up the text ...
1
vote
1answer
14 views

OR Statement for Advanced Filtering

I'm looking to find a way to filter two different columns. Normally I would just use the filter for this, but the catch is that after filtering by one item the second filter is not possible as none ...
1
vote
1answer
27 views

Excel return a list of stringe where 'TRUE'

Ok so I have couple of cells listing warnings: A B C 1 Warning1 TRUE 2 Warning2 FALSE 3 Warning3 TRUE Now I want to return list of warnings that are set to ...
0
votes
0answers
24 views

How do I fix the error “Excel connot open file (filename).xlsx”? [duplicate]

I have several excel files stored on my system. I used these files from the same computer daily. Yesterday, when i tried to open several files in Excel 2007 then i found following error on my computer ...
-2
votes
0answers
21 views

Pull data from excel worksheet using VBA [closed]

I have a workbook with two sheets. Sheet 2 contains a "database" of info: first name and last name and a record ID assigned to them. Say it looks like this: 1 john doe 2 mary smith 3 ...
0
votes
1answer
21 views

Is there a way to include “workbook” event functions in my personal macros file?

e.g. Private Sub Workbook_AfterSave(ByVal Success As Boolean) Beep End Sub This only works in "ThisWorkbook," and only in 1 spreadsheet at a time, not in my personal.xlsb file. (Inspired from ...
0
votes
0answers
28 views

Excel 2013 crashes when saving instead of showing a pop up message “Some links could not be updated”

I need to prevent an Excel file from crashing and get a popup message instead. How can I do this? Below is the scenario: Excel 2013 crashes, when saving, instead of showing a pop up message "Some ...
2
votes
1answer
28 views

Can I run a VBA function whenever excel calculates, even when I don't click F9?

This is a followup question to this one: Can I make Excel beep when a calculation is finished? The answer relies on me pressing F9. However, even with calculations on manual, sometimes calculations ...
0
votes
0answers
10 views

How to use Excel VBA API:XmlNamespace .InstallManifest [closed]

I have read the help document,but I am still confused,is there someone can help me by providing an sample example?
0
votes
2answers
28 views

Excel - how to make alphanumeric cells work for =sum

trying to work out how to add up a list of cells that all contain alphanumeric values. Example for cell data is '3.098 GB (3,326,698,574 bytes)' I am using the below to strip out the brackets and ...
0
votes
1answer
22 views

Microsoft Excel 2003 Sequence numbering

I am in need of working out how to have sequence numbering in the excel database I'm creating. I am trying to have the following 001/15, 002/15, 003/15... I am having no luck in getting this to work ...
0
votes
1answer
21 views

Looking to total cells, but leave some blank in between

I've written a worksheet for selling work. I have one column "C" for the cost, and the column next to it "D" for a subtotal. Depending on the work to be performed, not all rows will have values to ...
0
votes
2answers
36 views

Conditionally Formatting Across Cells

I am organizing an event and would like to do the following: I have a General sheet with all the invitees names, addresses, etc. I also mark here if they replied and how many people will be ...
0
votes
0answers
16 views

How do I filter multiple values that are contained within a cell in Excel? [closed]

Excel lets you filter up to two values contained within a cell using the standard filter. I know Advanced Filter allows you to specify more criteria, but how do you search within a cell (ie. contains ...
0
votes
1answer
23 views

How to find a specific row in Excell

I am looking for some formula in Excel like give me the number of the row which its first column is 5 and its second is 3 I have searched the web but I have found lookup, search, find and ... which ...
0
votes
0answers
23 views

Why is the autosum behaviour not as expected when used on an entire column?

This is some strange behavior I encountered when using the Sigma to sum a column. If I click on the open cell under the last number in a column and then hit the Sigma button and press enter I get the ...
0
votes
1answer
28 views

Expanding Excel reports

I am not very experienced in using Excel spreadsheets, but have created one for a client and need help. I set it up so all the columns are on one page, but would like the rows to be larger and extend ...
0
votes
0answers
14 views

Excel workbook file [closed]

I have a master workbook on file with the names of my engineers and their services for the week. I want to split them out from this into individual workbooks for each engineer. Is this possible and if ...
-6
votes
1answer
35 views

How can I use the IF condition in a formula? [closed]

Need some help with the Excel function using IF condition. The data input is just a number format and keeps changing. Excel Table Home 6:00 Travel 9:00 Office 10:00 Travel back Home 18:00 ...
-1
votes
1answer
17 views

Insert Excel chart into Word template [on hold]

I want to create a Word template. Is it possible, that template will take information from another Excel file automaticaly? And can it use charts? User story: The user should open the template, ...
0
votes
2answers
15 views

How can I write-protect a worksheet, while permitting link jumping to another worksheet to enter comments?

There is a very important MS-Excel sheet that I maintain, which I need to share with other colleagues. For every row in the particular worksheet that I maintain, multiple colleagues could leave ...
2
votes
1answer
32 views

Why does my Excel require pipes instead of commas in formulas now?

I'm using Excel 2013 on Windows 7 x64. Yesterday, I could write formulas using commas, like this: =IF(ISNUMBER(A1), "num", "not num") but today, I have to enter the formula using pipes, like this: ...
0
votes
1answer
20 views

Capturing Text from Pivot Table

I'm trying to create a pivot table that has 2 parts. In order to push parameters into the table, you would add allows users to filter across any one of several parameters in a field. For instance, ...
0
votes
1answer
12 views

How do I assign a key based on count of available keys and indicator value?

I need some help writing a formula that does the following: Looks to see if an indicator=1 If indicator=1, lookup the key value based on the number available for that particular key Keep looking up ...
1
vote
1answer
93 views

Populating Data Table in Word with Excel VBA: Selecting Range between two bookmarks and pasting

With Excel and Word 2013 & Windows 8: In essence, I have an excel template that I want to update to a word template. I have about 20 tables in Word, that are preformatted and I want to update ...
1
vote
1answer
21 views

How can I return a value of 1 or 0 depending on conditions of other cells?

I want to return a value of 1 or 0 in cell H1 depending on the following conditions being met - E3>=60 F3>=60 G3>=6 I had used =IF(E3>=60 AND F3>=60 AND G3>=6, [1], [0]) - but it ...
0
votes
0answers
10 views

Matlab extract numbers from cell with mixed contents

I have a cell array with different datatypes, from an excel sheet that I need to read in, but which is beyond my control. [~, ~, raw] = xlsread(xlsFile) raw is now a r-by-c cell vector, for ...
0
votes
1answer
33 views

Mass change the appearance of URLs in Microsoft Excel

I wish to change the appearance of the URLS in a Microsoft Excel worksheet. At present the current URL's look something like: http://www.example.com/101010101010101010101010101. I know how to change ...
0
votes
1answer
16 views

Change background color of rows which are present in another column

I have data in the A and B column. B column's data is mostly duplicates of A's data, but not always. For example: A Budapest Prague Paris Bukarest Moscow Rome New York B Budapest Prague Los Angeles ...
0
votes
2answers
26 views

Using COUNTIFS for a series of values at once

Working a step higher then COUNTIFS, I appose a challenge to write a formula without VBA code. The basic data is combined from 1000s of rows with: Column A: rows with values from 1 to 3 Column B: ...
1
vote
0answers
14 views

How to get rid of extra spaces when copying a table from Excel to Powerpoint

I have been facing this problem from times immemorial. Whenever I copy a table with data, either numbers or text, from Excel to Powerpoint, most of the times I get numerous spaces before the data, ...
0
votes
3answers
38 views

Converting a Percentage to a Letter Grade

I am trying to figure out all of my grades on Excel. I already have all of the percentages figured out but I cannot figure out how to convert those percentages into letter grades automatically. For ...
0
votes
0answers
13 views

Mouse Pointer Glitch when using Dual Monitors, Win 8.1, Excel 2013, and VBA, Visual Studio. Cursor Drifts

I have been using Windows 8.1 and Excel 2013 and I've been writing a lot of VB for Excel. Also I've been using Visual Studio 2013 on some projects I'm working on. I've searched for this answer and ...
0
votes
2answers
42 views

Excel 2013 - How to remove duplicates from 1 column but leave empty cells in place of duplicate?

I have a sheet with 2 columns. first column has unique values, while the second column has many duplicates. I would like to remove duplicates from the second column , however the cells that ...
0
votes
1answer
22 views

Does Acrobat XI Pro Win ESD support fillable form fields from a CSV?

At work I had an old version of Adobe Acrobat Pro, version 9, which I used combined with some Actionscript and batch actions to fill in form fields using a csv file and finally outputting to one pdf ...
0
votes
1answer
20 views

Mail Merge using mutiple fields/next record

I am trying to merge the following: {MERGEFIELD Signer} Date Page 2 {MERGEFIELD Payername} {MERGEFIELD Number} {MERGEFIELD Description} {MERGEFIELD Year} PB If the client has multiple Payer ...
0
votes
1answer
16 views

Combining address function and cell function in Excel

In MS Excel 2013, when I write =CELL("contents",$B$1) It is okay, but when I write =CELL("contents",ADDRESS(1,2)) It results in error. I would like to access the contents of an address. I have ...
0
votes
1answer
35 views

How can I make Excel conditionally highlight cells based on the contents of cells?

I have a few things that I would like to do on Excel: How do you highlight a row [A-U] if only the first cell A has had text entered in it? When you enter text in cell A cells B-U have a yellow ...
0
votes
1answer
37 views

Excel formula to count unique values in two columns

I have two columns and I want to get distinct count for each of the account codes: Account 12 12 34 56 90 90 91 91 Account code a b a a a b a a ...
1
vote
2answers
28 views

How to condense sparse data in a table with redundant rows and columns

In Excel how can one merge, collapse, condense, or prune empty cells from an array with duplicate headings in rows and columns? +-----------+---------+------+---------+-------+---------+ | ...
0
votes
0answers
27 views

Color scale based on multiple cells

I have a data sheet with min-max possible values adjacent to each other. I'd like to color the cells based on how close they are to matching (ie the color should be based on their difference) I ...
0
votes
1answer
26 views

What is this argument of AGGREGATE function doing in my formula?

I need to understand this part ($B$1:$B$15<>"") in the following formula used to represent a column of data with blank cells removed: ...
0
votes
3answers
80 views

Compare multiple columns for any two or more cells within the same row having the same content

I need a formula to compare multiple columns for any two or more cells within the same row having the same content. If that is true, then display "TEXT A" (can be anything such as "TRUE"). If all of ...
0
votes
0answers
15 views

How to fill a list into incoherence cells of column

How to insert code from Column A to Blank cell in Column C sequentially? (I have so many code so cannot copy and past manually), the result should be:
0
votes
1answer
26 views

Microsoft excel 2010 - highlight duplicate values in multiple columns

I have been looking at a lot of help articles about how to highlight duplicate values, but I can't find one that does exactly what I am trying to do. I was hoping to highlight cells when the value in ...
0
votes
1answer
16 views

Excel Title Row — Not part of the count when using conditional formatting

I would like to set my Excel document to color every tenth line in the document using conditional formatting -- without counting the header row as row 1. Is there any way to accomplish this?