What's the best way to do this?

[Bob Smith]

Hi folks,

I have a workbook with 26 worksheets to track game scores for a group of
players @ 24 different sites in our local area. Data for each site is pulled
down from a web site via queries. Each site sheet shows the top 50 players
at each site. Column A goes from 1 to 50, Column B are the players names,
Column 3 shows their accumulated points earned.

Data from each site sheet is copied, via paste special, to a sort worksheet.
This data is sorted by accumulated points - descending. The data from this
sheet is then copied via paste special to a Top 100 worksheet, so that the
Top 100 players in the area are displayed. The point total for the 100th
player on this page is in cell I34 on the Players sheet.

What I'd like to do, show which players are on the Top 100 list from for
each site sheet. by putting a formula in each site sheet, for each player in
Column D, if their point total in Column C is equal to or greater than the
value in the players sheet in cell I34, The text "***" is placed in
respective cells in Column D.

I'm stumped on which formula to use. Any suggestions?

Thanks in advance.

Bob

 

[Frank Kabel]

Hi
do you mean
=IF(C1>='summary_sheet'!$I$34,"*****","")
and copy down

 

[Bob Smith]

Hi
do you mean
=IF(C1>='summary_sheet'!$I$34,"*****","")
and copy down

<snipped>

Frank ... You are the man! Worked perfectly once I changed the sheet name
and cell #.

TYVM

Regards, Bob