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

excel: if FileExists, if a given value is x in the file, then pull the data from a given cell

I have a function which checks if a file exists, if the file exists then it checks for a specific value in a specific cell, if thats true then it pulls the value from a given cell. Problem is, a dialouge box keeps appearing when I run this code. I…
Boosted_d16
  • 13,340
  • 35
  • 98
  • 158
1
vote
0 answers

Dynamically-generated array with MODE.MULT for Chart Series Values causes Excel 2010 to crash

First of all, I would like to clarify that I am looking for a technical explanation as to why the following issue occurs, rather than for alternative set-ups which achieve the desired result (I shall in any case present several such alternatives as…
XOR LX
  • 7,632
  • 1
  • 16
  • 15
1
vote
1 answer

Find and placing elements in a long string/column of text

The following is the result of downloading information from an accounting system. Basically, I was tasked with sorting through expenses from this year from an online system; once the information was downloaded from the online system, it was not…
bdpolinsky
  • 341
  • 5
  • 18
1
vote
1 answer

Excel specific column extraction

I've been trying to extract certain columns from an Excel sheet from a multitude of unwanted columns. I've been running the following script: Public Sub extractCol() Set range1 = Range("A:A, BI:BI, C:C, L:L") range1.Copy Set newbook =…
Sage Mohan
  • 155
  • 1
  • 1
  • 8
1
vote
1 answer

Excel divide column per row formula

I have an Excel column (total per x) and row (cumulative values of y) and I want to calculate the %. In the following example I'm trying to calculate for example : BQ18/BQ89, then BP19/BP89, BO20/B089 etc. My table is shown on the picture.
Amine
  • 225
  • 3
  • 13
1
vote
2 answers

mulit plot from different sheets in one chart with VBA

My problem is that I want to make many graph in one chart but the data is from different sheets. At the moment my code can only take multi data from one sheet, meaning I can plot 2 graph from one sheet. My code at the moment is: Sub ChartSheet() …
JessieQuick
  • 51
  • 8
1
vote
0 answers

Access SQL in Microsoft query in Excel 2010

I have an MS Access database with several tables that I am trying to reproduce in MS excel using Microsoft Query. The information from the various tables in access has been copied into seperate sheets in the excel workbook and given the same names…
kit
  • 83
  • 4
  • 16
1
vote
3 answers

Switch synatx error issue

In the following vba code in excel 2010 I am getting the error message Syntax error. I think it is to do with the switch statement but can't see what is wrong. Do you know what I have done wrong? Sub timeperiod() Dim change As Integer, colA As…
kit
  • 83
  • 4
  • 16
1
vote
2 answers

EXCEL VBA: looping through columns and copying

In excel I have four columns. There are numbers in the first column, the second column is blank, the third also contains numbers and the fourth contains text. I want to check each value in the first column and check if it exists in the third…
kit
  • 83
  • 4
  • 16
1
vote
0 answers

How to render HTML Database content via a T-SQL query?

I have some an HTML content column in a SQL Server 2012 database. I want to issue a SQL query similar to: select name, HtmlContent from table and have the HTML rendered in the result set, and not as HTML tags. I do not have reporting services. I…
SamJolly
  • 6,347
  • 13
  • 59
  • 125
1
vote
1 answer

Excel 2010 Conditional Formatting - INDIRECT Function

I have an ongoing table that contains info in columns A-K and an undefined amount of rows. I'm trying to create a rule that will highlight columns A-K in a specific row if the value of cell D in that row is less than or equal to a specific date. I…
Kay
  • 25
  • 8
1
vote
2 answers

Excel: I want to populate Column A with the Contents of Column B, only if Column B value starts with F

I have two columns with different values; A and B, if the values of column B start with letter F, I want that value (the one starting with F) to replace the current value in column A. This is the VBA code I have so far, not sure if I am heading in…
Z. Finley
  • 13
  • 3
1
vote
1 answer

Sql: datediff within switch for MS Query

I am using MS Query in Excel 2010. I have two tables and I am appending them together. colG is then added. ColA has dates and in colG I want to diplay a message about how long ago the date is from the current date. I am having issues using DateDiff…
kit
  • 83
  • 4
  • 16
1
vote
2 answers

Retrieve unique counts in excel

I'm looking to create a formula that counts the number of sign ups for a given day. My input data is based off an event log, and looks something like this: AccountName | SignUpDay | EventLogged acct1 | 06/01/2016 | 06/01/2016 acct1 | 06/01/2016 |…
Gshock
  • 317
  • 1
  • 4
  • 13
1
vote
2 answers

Change Cell Reference between Absolute and Relative

I want to write a macro which goes through all cell references in a selection's cells formula and changes them to absolute or relative. Is there a formatting variable which can change this or a function which does this already (similar to what…
AER
  • 1,549
  • 19
  • 37
1 2 3
…
99 100