Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
IF statments for multiple listings.
Hello,
I am hoping someone might be able to help with this. I am trying to come up with a sheet for my Fantasy Football league's draft. I have one worksheet that has the entire draft. Then I have a worksheet for each team. This has a table that autopopulates from the original draft, showing who each team has drafted. Also, there is another table on this worksheet that shows the full roster for the team. Here's the problem. We draft multiple players at a couple of positions. So, I have been able to use the IF function to scan the data table for position players. (i.e. =IF(H6="QB",G6, IF(H7="QB", G7, IF(H8="QB", G8, IF(H9="QB", G9, IF(H10="QB", G10, IF(H11="QB", G12, IF(H13="QB", G13))))))) So that it will autopopulate the QB position on the table. The problem I have is with the positions we draft more than one of. So for RB, it will autopopulate from the draft table, but it will put the first RB selcted at both cells. Is there some way to have the first RB cell search through the data table and autopopulate. And then have the second RB cell compare itself with the first cell, and put in the next player? Thank you. |
#2
|
|||
|
|||
Hi!
This shouldn't be too difficult but it's hard to give advice without seeing the file. If you want to send me a copy I'll take a look. Biff -----Original Message----- Hello, I am hoping someone might be able to help with this. I am trying to come up with a sheet for my Fantasy Football league's draft. I have one worksheet that has the entire draft. Then I have a worksheet for each team. This has a table that autopopulates from the original draft, showing who each team has drafted. Also, there is another table on this worksheet that shows the full roster for the team. Here's the problem. We draft multiple players at a couple of positions. So, I have been able to use the IF function to scan the data table for position players. (i.e. =IF(H6="QB",G6, IF(H7="QB", G7, IF(H8="QB", G8, IF(H9="QB", G9, IF(H10="QB", G10, IF(H11="QB", G12, IF(H13="QB", G13))))))) So that it will autopopulate the QB position on the table. The problem I have is with the positions we draft more than one of. So for RB, it will autopopulate from the draft table, but it will put the first RB selcted at both cells. Is there some way to have the first RB cell search through the data table and autopopulate. And then have the second RB cell compare itself with the first cell, and put in the next player? Thank you. -- imjoel . |
#3
|
|||
|
|||
Biff,
What's your e-mail address and I'll send it over. Thank you, -Joel Quote:
|
#4
|
|||
|
|||
Hi!
You should have stayed in the original thread! I may not have seen this post! Valko 01 is at com cast period ten. Reverse ten. Take out all the spaces and is. Biff -----Original Message----- Biff, What's your e-mail address and I'll send it over. Thank you, -Joel Biff Wrote: Hi! This shouldn't be too difficult but it's hard to give advice without seeing the file. If you want to send me a copy I'll take a look. Biff - -----Original Message----- Hello, I am hoping someone might be able to help with this. I- am trying to- come up with a sheet for my Fantasy Football league's- draft. I have- one worksheet that has the entire draft. Then I have a- worksheet for- each team. This has a table that autopopulates from the- original- draft, showing who each team has drafted. Also, there is- another table- on this worksheet that shows the full roster for the team. Here's the problem. We draft multiple players at a- couple of- positions. So, I have been able to use the IF function- to scan the- data table for position players. (i.e. =IF (H6="QB",G6,- IF(H7="QB",- G7, IF(H8="QB", G8, IF(H9="QB", G9, IF(H10="QB", G10,- IF(H11="QB",- G12, IF(H13="QB", G13))))))) So that it will autopopulate the QB position on the- table. The problem- I have is with the positions we draft more than one of.- So for RB, it- will autopopulate from the draft table, but it will put- the first RB- selcted at both cells. Is there some way to have the first RB cell search- through the data- table and autopopulate. And then have the second RB cell- compare- itself with the first cell, and put in the next player? Thank you. -- imjoel . - -- imjoel . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an Excel template to reconcile business bank statments? | Excel Discussion (Misc queries) |