Top "Excel-2010" questions

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft.

Apply Conditional Formatting based on multiple conditions

I'm attempting to highlight a cell based on two conditions, if the Work Type is equal to (blank), and if …

excel excel-2010 conditional-formatting
Any way to hide Slicer Values in Excel 2010

I know that Excel 2010 Slicers will visually indicate when there is no data associated with a particular slicer selection. For …

excel slice excel-2010 powerpivot
Lookup using INDEX and MATCH with two criteria

I am trying to achieve a basic lookup using INDEX and MATCH. My layout is: Sheet 1 NAME | SITE | DATE Sheet 2 …

excel excel-formula excel-2010 lookup excel-match
vba excel 2010 Environ("username") not working in saveas filepath

For some reason I can get the Message Box to tell me what the username is, but it doesn't work …

vba excel-2010 username
numeric up down control in vba

Is there an in-built numeric updown control in vba or do we need to create a control like that? If …

excel vba excel-2010 numericupdown
What is the VBA code to emulate selecting a block with the CTRL+A shortcut?

In earlier versions of Excel, pressing CTRL+A in a worksheet would literally select all cells. In Excel 2010 (not sure …

excel range excel-2010 vba
How to get unique values in a column using excel formula

I have Excel Data like below JID Val 1001 22 1030 6 1031 14 1041 8 1001 3 2344 8 1030 8 2344 6 1041 8 How do i get the unique JID values like below using formula? …

excel-formula excel-2010
Table in Excel from SQL Server stored procedure with parameter field in workbook

I need to create a dynamic report using Excel 2010 and SQL Server. Going off of previous ones created by others …

sql sql-server-2008 excel stored-procedures excel-2010
Calling a userform and returning a value

I have a vba code thats Auto_Open. It does some checks then prompts a userform that asks for username …

excel excel-2010 userform vba
Using COUNTIFS to count blank when cell has a formula

I have criteria where I need to count if a column B is not blank. But I have a formula …

excel excel-2010