Top "Excel-2010" questions

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

Changing the Date Format for GROUPED dates in a PIVOT TABLE

I'm working in Excel 2010 Let's say you have a legitimate date field in your raw data with dates such as 1/1/2015. …

excel excel-2010 pivot-table
Using VBA to prompt user to select cells (possibly on different sheet)

I'm working in Excel on a VBA project, and want part of my macro to prompt the user to select …

vba excel excel-2010
Excel Q - SUMIFS with a 2 dimensional array

I have a 2-D array: dates on a horizontal axis and identification numbers on a vertical axis. I want the …

excel excel-formula excel-2010 vba
Put entire column (each value in column) in an array?

So i'm making a macro to do a bunch of things. one thing is find duplicates of cells in sheet1 …

vba excel duplicates excel-2010
Excel Conditional Formatting Data Bars based on Color

I cannot find a way to change the color of an Excel data bar based on value. Current formatting options …

excel excel-2010 conditional-formatting vba
How to compare two csv files in windows

I need to compare two csv files in windows7. How can I proceed to achieve this. I want to see …

windows csv excel-2010
Simple way to remove blank cells dynamic dropdown list Excel

Whenever I do a dependent dynamic drop down list , I see a bunch of blank cell in the drop-down list , …

excel excel-2010
How to highlight a cell using the hex color value within the cell?

I have a spreadsheet of symbols and matching hex colors. I want to fill the cell itself (or the one …

vba excel excel-2010 conditional-formatting
How do i loop an excel 2010 table by using his name & column reference?

Since Excel 2010 I'm using a lot of tables within Excel. For example, I have a table "tabWorkers" with 3 columns: "ID", "…

vba excel excel-2010
vlookup with multiple columns

I have the following formula in my B:B column =VLOOKUP(A1;'mySheet'!$A:$B;2;FALSE) It does output in …

excel excel-formula excel-2010 array-formulas