formulating if; then; enter list

  • Thread starter Thread starter striker92s
  • Start date Start date
S

striker92s

13 teams, saved team players in pivot table format (also first time use
for pivot table
 
Hi!

Not sure what "saved team players in pivot table format"
means.

Here's an example of a table and the formula to use.

Col L = team names starting in L1
Col M and N = players names starting in M1,N1

Team 1 Player 1 Player 7
Player 2 Player 8
Player 3 Player 9
Player 4 Player 10
Player 5 Player 11
Player 6 Player 12

Team 2 Player 1 Player 7
Player 2 Player 8
Player 3 Player 9
Player 4 Player 10
Player 5 Player 11
Player 6 Player 12

Team 3 Player 1 Player 7
Player 2 Player 8
Player 3 Player 9
Player 4 Player 10
Player 5 Player 11
Player 6 Player 12



Select the range H4:I9.
Enter this formula in the FORMULA BAR as an array by using
the key combo of CTRL,SHIFT,ENTER

=IF(A5="","",OFFSET(L1,MATCH(A5,L1:L100,0)-1,1,6,2))

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link Drop Down with Pivot Table 2
Create a summary list without using PivotTables? 8
Excel VBA For excel 0
Countif until a number occurs four times in a row then return that number 3
formula in pivot tables involving counting text cells 1
Pre-configuring Pivot table "views" 4
Excel Excel conundrum - I've tried and tried, but 10
GETPIVOTDATA and (blank) 0

Back
Top