Stack Overflow
Stack Overflow

Questions tagged [excel-2010]

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft. If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.

Excel 2010 is the 14th version of Microsoft's commercial spreadsheet program. Microsoft made slight user interface (UI) changes; otherwise, it continues to use the UI pioneered in Office 2007.

Features such as Sparklines and Slicers were introduced in Excel 2010 to provide more charting and data visualization power.

This tag is used for questions specific to the 2010 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it or . Questions about addins for Excel 2010 should be tagged .

Links:

6168 questions
1
vote
1 answer

Conditional formatting a subset of cells based on a formula

I had thought that my question here: In a subset of cells, determine if at least one corresponding cell matches a value would give me enough information that I could apply it to conditional formatting, but that is not the case. So, my follow-up…
Brian
  • 197
  • 2
  • 10
1
vote
1 answer

Is there such thing as a VLOOKUP that recognises repeated numbers?

I have a list of values in column A on an excel TAB and on the column B next to it I have a list of words. On another TAB, I'm trying to retrieve the words from B where A has the smallest value, then the 2nd smaller value, 3rd, etc. Example:…
pedroteixeira07
  • 91
  • 11
1
vote
1 answer

How do I set the default save format in PowerPoint?

Microsoft, in their infinite wisdom, decided that the default file format for Office 2010 applications should be the format that was 13 years old (Office 97-2002) at the time of release. The newer formats (2007 and newer) save the data in…
FreeMan
  • 5,660
  • 1
  • 27
  • 53
1
vote
3 answers

Excel formula for min value if greater than negative number and less that positive

I need some help with a formula. I'm trying to work out the minimum value if greater than -365 but less that 365. {=MIN(IF((E46:J46<365)*(E46:J46>-365),E46:J46))} This is the formula I have so far, which is ignoring anything less that -365 and…
atame
  • 521
  • 2
  • 12
  • 22
1
vote
1 answer

Open XML move sheets in workbook

Using OpenXml on a excel sheet i create new worksheet. newWorksheetPart.Worksheet = new Worksheet(new SheetData()); Sheet sheet = new Sheet() { Id = relationshipId, SheetId = sheetId, Name = sheetName }; …
user581157
  • 1,327
  • 4
  • 26
  • 64
1
vote
1 answer

How can I get each cell in a row in Excel to display its own address?

I am having a lot of trouble getting each cell in the first row of an Excel sheet labeled by its address. i.e I want: A1 B1 C1 D1 etc. to be the first row of my sheet. I have tried the function =ADDRESS(1,2,4,1) but it does not work generically.…
Daniel64
  • 29
  • 2
  • 8
1
vote
2 answers

Excel.Application error in Visual Studio Express (Visual Basic)

Using Excel 2010, Visual Studio Express 2013. I have added the Reference Object Library in Visual Studio for Microsoft Excel 14.0 Imports Microsoft.Office.Core Public Class Form1 Private Sub Button1_Click(sender As Object, e As EventArgs)…
Code
  • 157
  • 2
  • 3
  • 16
1
vote
3 answers

lock in a vlookup column

so I have the following formula and I'm trying to create a stable formula where $o4$p74 is stapled and wont change. However, I need to constantly delete the p-column and then I do that, the vlookup changes from p to o and continues if I keep…
Sergio Oropeza
  • 37
  • 1
  • 5
1
vote
1 answer

Excel, find a date closest in a range of dates given a number and return another cell

New to advanced excel concepts, I have a list of numbers such as: 101 02/22/2016 100 02/21/2016 and then another list like so: 101 01/01/2016 Apple 101 02/20/2016 Banana 100 02/21/2016 Apple 100 02/23/2016 Banana I'm trying to get it where I use…
Nathanial Wcislak
  • 33
  • 4
1
vote
1 answer

Excel Macro which saves a worksheet

I'm totally new to Microsoft VBA and I'm getting trouble to fix an Excel macro. The intention of this macro is that, when pressing a button, it automatically saves the active worksheet on a file but it is not working and I don't know why. It seems…
Rods2292
  • 665
  • 2
  • 10
  • 28
1
vote
3 answers

Excel VBA - Removing duplicates

I try to sort a sheet in my workbook. After the macro sorted my table it should remove all duplicates based on the column A. But every time I use the macro, I get the following error: Sub SortAndRemoveDUBS() Dim Rng As Range Dim LastRow As…
Bluesector
  • 329
  • 2
  • 11
  • 21
1
vote
2 answers

Index-Match: String in cell to mappings

I am trying to match strings to a text. I would like to return the index of these "mappings". I tried: =INDEX($A$2:$A$1000;MATCH(F2;$B$2:$B$1000;1)) However, I wrong values: In the mappings the values are all different as shown in the example! Any…
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
1
vote
2 answers

count if and search in excel

=COUNTIF(AND(A:A="01.01.2015";B:B="torsvik";ISNUMBER(SEARCH("wt";C:C)));TRUE) I would like to count "wt"s on "01.01.2015" and "torsvik", but it is giving an error. Could you give your advice ? if a is true , and b is true and c is true , count it…
Saba
  • 13
  • 3
1
vote
2 answers

Replace text marker with column text

I am having several columns with text. Furthermore, I have a column, which is called Replacement text. This columns contains strings that have markers in it, like [1], [2], etc. I would like to replace the markers with the text that is in the…
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
1
vote
1 answer

Excel 2010: Shading per series for Bar Charts

I have a table of data similar to this: I want to create a bar chart like this: But I get this: or, when I add major gridlines, I get this: However, I want a quick way to visually differentiate between the different quarters (Q1... Q4) by…
Karthick S
  • 3,204
  • 6
  • 36
  • 52
1 2 3
…
99 100