# tagged [excel]

#### filter out multiple criteria using excel vba

filter out multiple criteria using excel vba I have 8 variables in column A, 1,2,3,4,5 and A, B, C. My aim is to filter out A, B, C and display only 1-5. I can do this using the following code: But wh...

- Modified
- 15 Nov at 10:2

#### Convert date field into text in Excel

Convert date field into text in Excel I have an Excel file which has a column formatted as date in the format `dd-mm-YYYY`. I need to convert that field to text. If I change the field type excel conve...

- Modified
- 25 Feb at 23:32

#### Remove Duplicates from range of cells in excel vba

Remove Duplicates from range of cells in excel vba I'm trying to remove duplicates in excel 2013 VBA. but I'm getting error "object does not support this property or method". The problem is I don't ha...

- Modified
- 25 Jul at 21:17

#### How to use workbook.saveas with automatic Overwrite

How to use workbook.saveas with automatic Overwrite In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?" ``` Application.DisplayAlerts = False Set xls = Crea...

- Modified
- 2 Jun at 08:51

#### Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?

Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running? The following code leaves a Microsoft Excel background process running, until after my program has exit...

- Modified
- 7 Oct at 05:20

#### microsoft.interop.excel Formatting cells

microsoft.interop.excel Formatting cells I am building a report using the microsoft.interop.excel library in C#. I have something like this: I want the range to display its values as whole numbers i.e...

- Modified
- 13 Sep at 12:38

#### Get the current Workbook Object in C#

Get the current Workbook Object in C# I've been writing an application in C# which creates Custom Document properties in an Excel spreadsheet, I have a function for this which takes in a Workbook Obje...

#### Find last used cell in Excel VBA

Find last used cell in Excel VBA When I want to find the last used cell value, I use: I'm getting the wrong output when I put a single element into a cell. But when I put more than one value into the ...

- Modified
- 27 Jul at 11:23

#### Excel Date to String conversion

Excel Date to String conversion In a cell in Excel sheet I have a Date value like: I want to convert that Date to Text and also want the Text to look exactly like Date. So a Date value of `01/01/2010 ...

- Modified
- 29 Mar at 06:48

#### Shortcut to Apply a Formula to an Entire Column in Excel

Shortcut to Apply a Formula to an Entire Column in Excel If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells...

- Modified
- 14 Jun at 15:57

#### Add user defined function to Visual Studio Excel Add-in

Add user defined function to Visual Studio Excel Add-in In visual studio I have an Excel 2010 Add-in project. How can I have that project create the following module: ![enter image description here](h...

- Modified
- 19 Dec at 15:52

#### Excel - programm cells to change colour based on another cell

Excel - programm cells to change colour based on another cell I am trying to create a formula for Excel whereby a cell would change colour based on the text in the previous cell. So for example if cel...

- Modified
- 3 Oct at 22:1

#### Reordering Chart Data Series

Reordering Chart Data Series How does one reorder series used to create a chart in Excel? For example, I go to the chart, right click > Select Data. In the left column I see series 1, series 2, to ser...

- Modified
- 31 Dec at 04:59

#### How do I create an Excel chart that pulls data from multiple sheets?

How do I create an Excel chart that pulls data from multiple sheets? I have monthly sales figures stored in separate sheets. I would like to create a plot of sales for multiple products per month. Eac...

- Modified
- 2 Oct at 18:4

#### Excel Formula: Count cells where value is date

Excel Formula: Count cells where value is date I'm looking for a formula to run a COUNTIF (or similar) on a range of cells, and where the contained value is a date, to increment the counter - essentia...

- Modified
- 6 Mar at 14:16

#### Loop through each row of a range in Excel

Loop through each row of a range in Excel This is one of those things that I'm sure there's a built-in function for (and I may well have been told it in the past), but I'm scratching my head to rememb...

- Modified
- 8 Jul at 20:13

#### Excel: last character/string match in a string

Excel: last character/string match in a string Is there an efficient way to identify the last character/string match in a string using base functions? I.e. not the last character/string the string, ...

- Modified
- 17 Jun at 22:22

#### How to keep one variable constant with other one changing with row in excel

How to keep one variable constant with other one changing with row in excel Lets say I have one cell A1, which I want to keep constant in a calculation. For example, I want to calculate a value like t...

- Modified
- 25 Jan at 21:58

#### Getting unique values in Excel by using formulas only

Getting unique values in Excel by using formulas only Do you know a way in Excel to "calculate" by formula a list of unique values ? a vertical range contains values `"red"`, `"blue"`, `"red"`, `"gre...

- Modified
- 10 Sep at 10:51

#### How to SUM parts of a column which have same text value in different column in the same row

How to SUM parts of a column which have same text value in different column in the same row I have a column with names and a column with numbers: Names with same `FirstName` a

- Modified
- 28 Sep at 23:9

#### Draggable data points in Excel 2007?

Draggable data points in Excel 2007? I know Microsoft removed draggable points in 2007, but I need to get that function back. So far, I've got the MouseDown and MouseUp events trapped, but I'm having...

- Modified
- 9 Jul at 18:41

#### Ignore cells on Excel line graph

Ignore cells on Excel line graph I am trying to draw a line graph in Excel 2010. The y column data source has some gaps in it and I want these to be ignored for the graph. Seems to default these to ze...

- Modified
- 19 Aug at 15:48

#### Find if column contains value from another column?

Find if column contains value from another column? I have two columns. Column E extends up to 99504 (values) and column I extends to 2691 (values). Both columns contains filenames with extension. Some...

- Modified
- 29 Jan at 12:9

#### Excel 2010: how to use autocomplete in validation list

Excel 2010: how to use autocomplete in validation list I'm using a large validation list on which a couple of vlookup() functions depend. This list is getting larger and larger. Is there a way to type...

- Modified
- 27 Jun at 14:48

#### How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

How to do a "Save As" in vba code, saving my current Excel workbook with datestamp? I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the...

- Modified
- 9 Jul at 18:41