Stack Overflow
Stack Overflow

Questions tagged [excel-2007]

The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft. The version independent Tag is "excel". 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 2007 is the 12th version of Microsoft's commercial spreadsheet program. It is the first version of Excel to incorporate a new user interface (UI), which is now standard across most/all Office suite programs.

This tag is used for questions specific to the 2007 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 2007 should be tagged .

Links:

3668 questions
1
vote
1 answer

pivot running total in reverse order

I have a pivot table where I want to preserve the order of the columns, but show a running total in reverse order (i.e. the values decrease over time). I know I can reverse the order of the columns and set up a running total, or create a separate…
Longfish
  • 7,582
  • 13
  • 19
1
vote
1 answer

Reduce excel generation time while dumping data from Datable to Excel

My excel generation time is quite long.So i refer this for time reduction: How to speed up dumping a DataTable into an Excel worksheet? But, I'm not able to get what are these two variable: string [] columnNames, string [] fieldNames in the…
bapi
  • 1,903
  • 10
  • 34
  • 59
1
vote
1 answer

Format a cell that is referenced by another cell

I need to format a cell that is specified by another cell. Basically after many calculations, the cell AL1 contains a cell reference, in this case it is AD48. I want to format cell AD48 and fill it red. This cell reference can, and will change so…
John Smith
  • 11
  • 2
1
vote
1 answer

Multipart identifier error in Excel 2007 MS Query but not in SQL Server 2008

I have the following SQL code SELECT pd1.Meter, pd1.BasicPool, pd1.RateClass, pd1.Flowdate, (SELECT upOrDownContract FROM PipelineData pd WHERE pd.id = pd1.sibling) AS DnK, match.Volume, …
Ram
  • 3,092
  • 10
  • 40
  • 56
1
vote
1 answer

Need to populate master list from many different sheets in excel

So lets say I have 3 different sheets each with information on them like this: Sheet 1 Sheet2 Sheet 3 item1|2 item2|7 item1|4 item3|5 item3|6 item6|2 item9|7 item8|4 item7|8 The first part (code#) is a code for an item.…
user2409871
  • 21
  • 1
  • 1
  • 3
1
vote
4 answers

How do I count occurrences of a pattern of data in Excel?

I realized after manual scanning 90 records, that this was going to be painful and tedious unless I made use of automation. I have this set of data, about 4000 records that occurs in a pattern that I want to track. The first column is the important…
Ken Ingram
  • 1,538
  • 5
  • 27
  • 52
1
vote
2 answers

Excel: Cell counts based conditions

I am again trapped in a situation where I can't figure how to do it. Basically, here is replica of the table I need to work on. A B C D E F G 1 Months MON TUE WED…
ManishChristian
  • 3,759
  • 3
  • 22
  • 50
1
vote
2 answers

Recorded macro does not work on chart object

I recorded the following macro : Sheets("Rejets Techniques TGC").Select ActiveSheet.ChartObjects("Graphique 1").Activate ActiveChart.Axes(xlCategory).Select ActiveChart.SeriesCollection(1).Values =…
sliders_alpha
  • 2,276
  • 4
  • 33
  • 52
1
vote
0 answers

C#: Create/Insert Excel 2007 charts into Word 2007

How do you create and then insert an Excel 2007 chart in Word 2007 with office interoperability? Important: I do not want to save an Excel file to create a chart.
Partial
  • 9,529
  • 12
  • 42
  • 57
1
vote
2 answers

CountIf and Subtotal

I have a series of data columnar that I am wanting to use a countif for visible cells only that have the value 1. I can do either formula with no problem, CountIF, or SubTotal for visible cells, however when I try to combin them I get lost. Here is…
Desert Spider
  • 744
  • 1
  • 13
  • 31
1
vote
1 answer

Comparing two text cells to get four outputs

I'm building up a checking sheet for my work for issuing of commemorative coins. In 'Column F' I have a if formula running that answers 'Yes' or 'No' to indicate if the employee is eligible to have a coin issued. 'Column G' is a manual input of…
user2365648
  • 13
  • 2
1
vote
1 answer

How do I check for duplicate rows and do calculate on that rows in excel file?

I have one excel file which is having data like following CUSIP Quantity Date Price AF0 500000 5/6/2013 1 AE4 400000 5/6/2013 1.0825 AE4 500 5/6/2013 1 I need to check for column CUSIP and Date If…
Neo
  • 15,491
  • 59
  • 215
  • 405
1
vote
2 answers

selection.MergeCells property changes the original selection in excel

I want to check if my selection contains MergeCells and if so I do not want to process that selection in excel. But whenever I call selection.MergeCells the original selection changes and it wraps the areas bounded by MergeCells which I DO NOT…
Sagar
  • 645
  • 2
  • 9
  • 31
1
vote
1 answer

Why does -1 Match Type Match return N/A?

Suppose I have this formula =MATCH(16,{5;10;15;20;25},-1) Why does it return N/A? I would expect it to return 4. But What confuses me more is that when I change it to a Less than Match(1) it works as expected. And even though I knew it would…
user2140261
  • 7,855
  • 7
  • 32
  • 45
1
vote
2 answers

Excel multiple if function for 70 logical test

i'm about to use the if function in excel 2007 for these criteria: if B1 = "A" then C1 = "1" if B1 = "B" then C1 = "2" if B1 = "C" then C1 = "3" if B1 = "D" then C1 = "4" . . . . if B1 = "BP" then C1 = "68" if B1 = "BQ" then C1 = "69" if B1 = "BR"…
randms26
  • 137
  • 1
  • 6
  • 16
1 2 3
…
99 100