# Tagged Questions

**-1**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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?