I have a worksheet ("Sheet 1") containing 10.000 rows of text,
covering columns A to V.
In another worksheet ("Sheet 2") of the same workbook, I've created a table
which contains statistics regarding those 10.000 rows.
The amount of statistics included in this table is too large to mention here.
There are 2 pieces of statistics however, which I've been unable to include
in the table:

A) Statistic (Formula) 1 needed:
a. Columns F & H of Sheet 1, contain names which can appear either
on column
F or H, but never simultaneously on the same row.
Ex: Row 20, may contain "Larry" on column F & "John" on column H.
There will never be a row however, containing, say "Larry" on
both: columns
F & H, simultaneously.
b. I need to be able to figure out whenever, say "Larry" appears on
column F,
what happens to column I. (Column I contains other text,
relating to "Larry"
"John"...)
c. Ex: Say that "Larry" appears on ROW 20 of column F, and that on
the same
row, column I reads: "X".
The formula would ideally tell me that:
(Ex) Throughout 10.000 rows, "Larry" appeared 200 times.
Additionally, when
he appeared, column I, read: