StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17262311
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-23T15:30:48.880
FavoriteCount
0
LastActivityDate
2013-06-23T15:36:44.510
LastEditDate
2013-06-23T15:36:44.510
LastEditorUserId
620444
OwnerUserId
620444
ParentId
17260906
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You can compare two ranges without looping by making use of an Excel array-formula. The following code stores a value temporarily in cell A20, then produces a value of True or False to confirm if the ranges contain the same values. They are written in Excel VBA, but it should be possible to convert them to use Interop. <code>varCalc</code> (in the 2nd example) would be an Object rather than Variant. <pre><code>Sub TestCompare() '{=SUM(IF($A$1:$A$4=$B$1:$B$4,1,0))=ROWS($A$1:$A$4)} Dim rngA As Range Dim rngB As Range Dim blnTheSame As Boolean Set rngA = Range("$A$1:$A$4") Set rngB = Range("$B$1:$B$4") Range("A20").FormulaArray = "=SUM(IF(" & rngA.Address & "=" _ & rngB.Address & ",1,0))=ROWS(" & rngA.Address & ")" blnTheSame = Range("A20").Value Range("A20").Clear MsgBox "Are they the same? " & blnTheSame End Sub </code></pre> The following version does the same, but works entirely in code, not requiring the use of a cell to store a temporary result: <pre><code>Sub TestCompare2() '{=SUM(IF($A$1:$A$4=$B$1:$B$4,1,0))=ROWS($A$1:$A$4)} Dim rngA As Range Dim rngB As Range Dim varCalc As Variant Dim blnTheSame As Boolean Set rngA = Range("$A$1:$A$4") Set rngB = Range("$B$1:$B$4") varCalc = "=SUM(IF(" & rngA.Address & "=" _ & rngB.Address & ",1,0))=ROWS(" & rngA.Address & ")" blnTheSame = Evaluate(Array(varCalc)) MsgBox "Are they the same? " & blnTheSame End Sub </code></pre> Neither make use of <code>Value2</code>, but I can't see that this is necessary for the comparison(s).
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to Compare two range's Range.Value2 with C#
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAndy G
UserOwnerUserId
1. USAndy G
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.