Is there a function in excel that will allow me to find the largest record in
conjuction with other data? For example, I get a large unsorted file from
one of my databases. It is possible and likely, that there are multiple
records for each of my unique cost centers. For reporting purposes I need
one record for each cost center with all of the dates of activity on the same
row, but in different columns. I want to create a new tab with all of my
unique cost centers listed (1000's). I would have one row for each cost
center with columns for recent and previous occurances. So if one cost
center had two rows of data on my source tab with occurences one in June 07
the other Jan 08. I could right a formula that would find the cost center
and then place the earliest date in the first column and the older date in
the next column. It seems like there should be some combination of
index(match() and large() that would allow me to do this. Does anyone have
any suggestions? Thanks in advance for your response.

What does "largest record" mean. In data base terms a record can have many
fields -i.e: Last Name, First Name, Income, Phone Number, Taxes Paid etc.
What does largest mean?

Tyro

"WildlyHarry" wrote in message
...
Is there a function in excel that will allow me to find the largest record
in
conjuction with other data? For example, I get a large unsorted file from
one of my databases. It is possible and likely, that there are multiple
records for each of my unique cost centers. For reporting purposes I need
one record for each cost center with all of the dates of activity on the
same
row, but in different columns. I want to create a new tab with all of my
unique cost centers listed (1000's). I would have one row for each cost
center with columns for recent and previous occurances. So if one cost
center had two rows of data on my source tab with occurences one in June
07
the other Jan 08. I could right a formula that would find the cost center
and then place the earliest date in the first column and the older date in
the next column. It seems like there should be some combination of
index(match() and large() that would allow me to do this. Does anyone
have
any suggestions? Thanks in advance for your response.

The Largest record means the date field with the largest value. The source
data looks like this:

Cost Center, Date, Score

The problem that I have is that a cost center can be visited multiple time
and have multiple scores. I need my report tab to have row per cost center
with all dates for that cost center on the same row.

"Tyro" wrote:

What does "largest record" mean. In data base terms a record can have many
fields -i.e: Last Name, First Name, Income, Phone Number, Taxes Paid etc.
What does largest mean?

Tyro

"WildlyHarry" wrote in message
...
Is there a function in excel that will allow me to find the largest record
in
conjuction with other data? For example, I get a large unsorted file from
one of my databases. It is possible and likely, that there are multiple
records for each of my unique cost centers. For reporting purposes I need
one record for each cost center with all of the dates of activity on the
same
row, but in different columns. I want to create a new tab with all of my
unique cost centers listed (1000's). I would have one row for each cost
center with columns for recent and previous occurances. So if one cost
center had two rows of data on my source tab with occurences one in June
07
the other Jan 08. I could right a formula that would find the cost center
and then place the earliest date in the first column and the older date in
the next column. It seems like there should be some combination of
index(match() and large() that would allow me to do this. Does anyone
have
any suggestions? Thanks in advance for your response.

Largest record means the largest date in the date field on my source
worksheet. The source worksheet looks like this

Cost Center, Date, Score

On the source sheet every seperate visit is represented with a seperate row.
For reporting purposes I need each cost center on one row with all the
visits for that cost center on the same row.

"Tyro" wrote:

What does "largest record" mean. In data base terms a record can have many
fields -i.e: Last Name, First Name, Income, Phone Number, Taxes Paid etc.
What does largest mean?

Tyro

"WildlyHarry" wrote in message
...
Is there a function in excel that will allow me to find the largest record
in
conjuction with other data? For example, I get a large unsorted file from
one of my databases. It is possible and likely, that there are multiple
records for each of my unique cost centers. For reporting purposes I need
one record for each cost center with all of the dates of activity on the
same
row, but in different columns. I want to create a new tab with all of my
unique cost centers listed (1000's). I would have one row for each cost
center with columns for recent and previous occurances. So if one cost
center had two rows of data on my source tab with occurences one in June
07
the other Jan 08. I could right a formula that would find the cost center
and then place the earliest date in the first column and the older date in
the next column. It seems like there should be some combination of
index(match() and large() that would allow me to do this. Does anyone
have
any suggestions? Thanks in advance for your response.