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

SUMPRODUCT with wildcard

I have the SUMPRODUCT working with hardcoded values however I want to use a wild card for the B clomun in my example. Here is my data +----------+----------+-----------+ | A COLUMN | B COLUMN | C COLUMN | +----------+----------+-----------+ |…
JA1
  • 538
  • 2
  • 7
  • 21
1
vote
3 answers

Find items in a list that contain all sub-items

I have two lists as follows, Column A and Column D: I would like to find all cells in Column A that do not contain a value from Column D. For instance, A1 should be 0 because it contains the values 'a', 'b', 'c' and 'd' - all of which are in Column…
rhughes
  • 9,257
  • 11
  • 59
  • 87
1
vote
1 answer

Filling a column with References to another column in reverse order

I am trying to fill a column with data from another column using a reference to that column's data. I know how to do this normally, but today I need to fill in the reverse order. Row 2, needs to contain the data from row 70, and Row 3 the data in…
Lucy Clara
  • 25
  • 5
1
vote
1 answer

I want to traverse Excel cells to get data with C#

I want to traverse Excel cells to get data, but the cells is not regular. For example: the red cell which is merged by multiple rows. how to traverse all rows? I want to traverse rows to get data as…
Superman
  • 285
  • 5
  • 17
1
vote
0 answers

Copy row in Excel if cell contains text

Am trying to copy an entire row from Sheet1 (FA) to Sheet 2 (FABREAK), if the cells in Column A contains the word NPC. I have the following code: Sub CopyRows() Dim bottomL As Integer Dim x As Integer bottomL = Sheets("FA").Range("A" &…
Sage Mohan
  • 155
  • 1
  • 1
  • 8
1
vote
0 answers

Excel circular reference in formula

I'm having a problem with formulas in excel. The formula of E4 is: =IF(D4<>0;D4;E6+E5) The formula of E5 is: =IF(E4<>0;E4*C5;E6/F6*C5) What I want to do is calculate the cells in both directions. D4 is a fix value that can be 0. E4 is eather D4…
xeraphim
  • 4,375
  • 9
  • 54
  • 102
1
vote
3 answers

VBA | With opening/activating sheet > edit viewing screen/zoom

When I activate a sheet I want excel to do the following process: Is cell "A1 and cell "Z1" in the range of my screen? Yes: Do nothing No: Range("A1:Z1").Select ActiveWindow.Zoom = True I want this because my file has to open on different…
Tim van Mechelen
  • 13
  • 3
1
vote
4 answers

Excel: How to transpose select columns and group by repeated values? (1D to 2D table)

I am working with a data dump of transactions which is not exported from the particular system in a very friendly format for any purpose. The data in Excel is made up of approximately 700,000 rows currently, whereas once organised correctly should…
AlexM
  • 133
  • 2
  • 3
  • 17
1
vote
1 answer

reset the origin of a graph with VBA

I have a problem with my graphs. After transmitting the values for the x- and y- axis, I have the problem that sometimes the origin moves, therefore, I need to reset the origin to its normal position, nevertheless, I do not know how to address the…
Claude G
  • 23
  • 6
1
vote
2 answers

Excel LEN, SEARCH and FIND Double Space Bug?

I am attempting to add conditional formatting to an Excel 2010 worksheet and having trouble with one of the formulas involved. From what I'm able to determine Excel is counting a double space as 1 character, and double spaces are what I'm trying to…
spacetanker
  • 119
  • 2
  • 15
1
vote
2 answers

How to highlight the cell by conditional formatting by comparing two columns ignoring BLANK match?

I am trying to highlight the cell by conditional formatting by comparing two columns B and C The condition is like to ignore BLANKS even if both columns have blanks on same row ,only to highlight the matching values So I wrote =AND(B2=C2,C2<>"")…
user41048
  • 53
  • 1
  • 2
  • 9
1
vote
1 answer

Excel how to calculate occurrences in a range

I have following column /1/, what I want to calcuate the occurrences of range,for example [1,2),[2,3),[3,4),[4,max) in the example/1/, the occurrences of [1,2) is 1, and [2,3) is 2.... How to write excel…
user84592
  • 4,750
  • 11
  • 55
  • 91
1
vote
2 answers

How to combine below two `ifs` formulas in excel?

How to combine below two ifs formulas in excel? =IF(AND( Sheet1!BC2<>"", Sheet1!CI2<>"",Sheet1!CA2=""),IF(Sheet1!CI2="","",Sheet1!CI2),IF(Sheet1!CA2="","",Sheet1!CA2) =IF(AND(…
user41048
  • 53
  • 1
  • 2
  • 9
1
vote
1 answer

Running SQL on Excel like Query on Google Sheets

I have a large database on Microsoft Excel 2010 on which I want to run SQL queries like the =QUERY formula in Google Sheets. Basically on Google Sheets, the =QUERY can reference cells which take user input. This allows me to dynamically update the…
tiredoak
  • 13
  • 5
1
vote
2 answers

How to color code cells with condition

I have data in the excel like below A B C D sam 9.8 sam 1 kev 0.1 kev 0.1 ashl 2 ashl 2 kris 5.5 kris 3 I'm trying to color code B,D if for eg:A1=C1 and B1=D1 then color B1,D1 green else orange.I tried below…
sam
  • 935
  • 3
  • 17
  • 29
1 2 3
…
99 100