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
2 answers

Trying to use SUMPRODUCT to identify unique values based on two additional conditions?

I am having some difficulty with this formula and I am hoping someone can help. I have searched extensively everywhere I can think of and can't find an answer pertaining directly to this issue. I have data in a spreadsheet table tracking employee…
James
  • 21
  • 4
1
vote
1 answer

Empty excel file has huge size

I've been writing in vba some code to make excel open a workbook, get info from there, paste it temporarily in the file and use that data to make an e-mail and send it. After that he clears everything and an empty file is left. Although there is…
KawaRu
  • 64
  • 1
  • 9
1
vote
1 answer

Converting XML to Excel with Powershell

exSafe:Nocontract cm:version,cm:title,cm:own,cm:author 1122334455 true
Tuhin
  • 37
  • 1
  • 8
1
vote
2 answers

How to write this faster?

This is current formula =IF(Sheet1!A1="?","Check",IF(Sheet2!A2="?","Check","")) (nested IF formula) This is what formula should do: If any A1 cell from Sheet1 to Sheet100 has ? written in cell, than write in cell in which is this code word…
Denis
  • 13
  • 4
1
vote
1 answer

Excel | How to Format Number with comma separated

How to format excel cell with comma separated. For example, we say like 1427322 and it show like 1,427,322 Any suggestion how we can achieve this?
user3739882
  • 11
  • 1
  • 4
1
vote
0 answers

How to connect to Oracle 12c DB with VBA

I have added a reference to Microsoft ActiveX Data Object 2.0 Library, and tried to execute the following code: Sub Ora_Connection() Dim con As ADODB.Connection Dim rs As ADODB.Recordset Dim query As String Set con = New…
Sarah
  • 2,713
  • 13
  • 31
  • 45
1
vote
1 answer

How can i extract data point value from tooltips of scatter plot?

I' m trying to get the x and y values of a scatter point. I simply want to extract data points values (x = 280 and y = 164) when I click on the data point on scatter plot. Also, I cannot use chart events because of the dashboard. Thanks for the…
Eser
  • 11
  • 1
1
vote
2 answers

Calculate work days

I want to calculate work days between two dates. NETWORKDAYS will do the trick, however I am having difficulty structuring the IF statement components. I have 5 columns, Column A will always have a start date; the other 4 columns might not. What I…
premiumcopypaper
  • 165
  • 1
  • 13
1
vote
1 answer

Approximate match lookup - similar text strings in Excel (No VBA & No Fuzzy Match Add-in)

Using Excel 2010. I have two data sets that contain lists of employees. The data is similar but not exact. Need to look up if the name in data set A is in data set B. Data Set A John Smith Jr. Dan Rogers Jane Doe Data Set B SMITH, JOHN…
Dennis G
  • 11
  • 3
1
vote
1 answer

How to search a range to see if the range is missing a row

I have a set of data that contains statistics for every hour in a month. Sometimes, the data is missing a line (for example, when the database is down for maintenance, so we are not able to collect statistics). What I need to do is determine if in…
Sarah
  • 2,713
  • 13
  • 31
  • 45
1
vote
1 answer

Compare column A and Column C and then if match found then update Column D with Column B

Please can anyone help out me doing this ? I have four column. Column A, B, C, D, E and F Need to compare Column A with Column C (not in sequence/ order) If match found, first compare Column B with Column D - Then Match or Not match in Column E If…
Anoop prabhu
  • 11
  • 1
1
vote
3 answers

Excel Subtracting time

Currently trying to setup a formula that will calculate the hours/minutes between two different hours of time. I currently use the following formula in Cell D3 and receive 12:35am as the answer: =C3-B3 What I would want it to display is 35…
LOZ
  • 1,169
  • 2
  • 16
  • 43
1
vote
3 answers

Count specific files in folder with excel vba

I need some help with my excel vba. First of all let me tell what it should do... On a network folder there are pdf-files which should be count. Folders look like…
user6702507
1
vote
1 answer

VLOOKUP search issue

Am having some issue using the VLOOKUP function in excel. Am a little new to excel and puzzled as to how to solve this problem. I have two excel sheets. Sheet 1 looks like: Col1 Col2 Col3 HIC GSN ND11 H1C 00214 0212107 C4I 07287 …
Sage Mohan
  • 155
  • 1
  • 1
  • 8
1
vote
2 answers

Conditional picking of a row in excel

I have the following table in excel: Col1 Col2 Col3 Col4 Col5 Col6 43401 17 #N/A 17 #N/A 43401 43480 17 #N/A 17 #N/A 43480 44501 #N/A #N/A #N/A #N/A 97590 #N/A #N/A #N/A #N/A 00475 #N/A …
Sage Mohan
  • 155
  • 1
  • 1
  • 8
1 2 3
…
99 100