I need help with creating formulas worksheets

I need help with formulas in multiple section on my file.There three worksheets two worksheets help putting formulas.


get data from bills & 49er are main sheets conference & division work get data off main worksheets with no empty lines and remove BYE on conference & division worksheets.

The pictures is then answer for 49ers conference & 49ers division formula put in place way I want it.

All formula is 49ers conference & division worksheet is not same as like pictures are

49ers conference will get data from 49ers worksheet 12 TEAMS

Where W L OR T go have this formula

Formula:

Please Login or Register  to view this content.

Where 49er score go have this formula

Formula:

Please Login or Register  to view this content.

on this formula i want remove bye out of formula

Where 49er opponents go have this formula

Formula:

Please Login or Register  to view this content.

you can change formula to make dynamic when I add more team to file that why are two teams for now
on this formula in 49ers conference should not be bye anywhere in this section

away/home have no formula in section away or home only. Create a formula that lookup from main team worksheet without BYE and empty lines

Where opponent conference go have this formula

Formula:

Please Login or Register  to view this content.

Where opponent division go have this formula

Formula:

Please Login or Register  to view this content.

Where opponent score go =IFERROR(IF(D15="BYE","",IF(VLOOKUP(D15,INPUTSCORES,A15+1,FALSE)="","",VLOOKUP(D15,INPUTSCORES,A15+1,FALSE))),"")
on this formula i want remove bye out of formula

AT symbol

Formula:

Please Login or Register  to view this content.

remove bye in conference


49ers division will get data from 49ers worksheet 6 TEAMS

Where W L OR T go have this formula

Formula:

Please Login or Register  to view this content.

Where 49er score go have this formula

Formula:

Please Login or Register  to view this content.

on this formula i want remove bye out of formula

Where 49er opponents go have this formula

Formula:

Please Login or Register  to view this content.

on this formula in 49ers conference should not be bye anywhere in this section

away/home have no formula in section away or home only Create a formula that lookup from main team worksheet without BYE and empty lines

Where opponent conference go have this formula

Formula:

Please Login or Register  to view this content.

Where opponent division go have this formula

Formula:

Please Login or Register  to view this content.

Where opponent score go

Formula:

Please Login or Register  to view this content.

on this formula i want remove bye out of formula

AT symbol

Formula:

Please Login or Register  to view this content.

remove bye in conference




Thanks you very much

Voyager22

Need answers asap way before August


Thanks You

@VOYAGER22
This is an all volunteer forum. People respond when and if they have time and the inclination to help. They are from all over this globe, so while you may be awake and in need of help, the person with the answer to your issue may be working, playing elsewhere or sleeping. Patience is the key here. If you have an urgent need, then you probably need to contact a professional in your area and pay for help. This site is free. I urge you not to use the terms that indicate you are in a rush for a solution. It does not help and actually may turn someone off from helping. Good Luck finding a solution and please be patient.

I know this is volunteer site need answers before this August. I can not able to paid to get answers right away.

I treid to help you in an earlier thread. I gave up because you did not do as I asked. Repeatedly you ignored my requested to SHOW me what you wanted in an Excel sheet.

In the current thread, you have a WHOLE PILE of requests and I have NO IDEA where/how to start.

1. Break it up into small groups of questions, 1 or two at a time.

2. Post a file showing what you HAVE.

3. Post (in the same file) a mock-up of what you WANT.

if you do that, I will try to help again. Otherwise, I won't help as it is just too confusing trying to understand your words.

Your choice...

Originally Posted by Glenn Kennedy

I treid to help you in an earlier thread. I gave up because you did not do as I asked. Repeatedly you ignored my requested to SHOW me what you wanted in an Excel sheet.

In the current thread, you have a WHOLE PILE of requests and I have NO IDEA where/how to start.

1. Break it up into small groups of questions, 1 or two at a time.

2. Post a file showing what you HAVE.

3. Post (in the same file) a mock-up of what you WANT.

if you do that, I will try to help again. Otherwise, I won't help as it is just too confusing trying to understand your words.

Your choice...

I will try. Will break up different worksheet. Will take me time my file I had 32 nfl teams. I have one using vba code. I want formulas. Want me send that file. I have look for that file if want

I put his together. I will post file. I also post before picture look like before any new formulas. I post picture should look like after new formulas are put in place. the after picture I manually type in with answer I it do automatically, Before is cells and worksheets name. I need help with conference & division worksheets. I also add all 32 teams 96 worksheets with their conference and division worksheets. Take look before pictures first see look like. thank take look at after picture That I want it look that way I want look like

49Ers Conference: B15:B26 With Formula Some How Look Up From 49Ers Worksheet That Put W,L Or T With No Empty Lines
49Ers Conference: C15:C26 With Formula Some How Look Up From 49Ers Worksheet That Put Team Team Of Worksheet And No Bye In Any Lines And With No Empty Lines
49Ers Conference: D15:D26 With Formula Some How Look Up From 49Ers Worksheet That Put Opponents Conference Only Have 12 Teams With No Empty Lines
49Ers Conference: E15:E26 With Formula Some How Look Up From 49Ers Worksheet That Put Away Or Bye With No Empty Lines
49Ers Conference: H15:H26 With Formula Some How Look Up From 49Ers Worksheet That Opponents Scores With No Empty Lines
49Ers Conference: I15:I26 With Formula Some How Look Up From 49Ers Worksheet That @ No Bye Any Lines With No Empty Lines

Must look at Conference to Conference



49Ers Division: B15:B20 With Formula Some How Look Up From 49Ers Worksheet That Put W,L Or T With No Empty Lines
49Ers Division: C15:C20 With Formula Some How Look Up From 49Ers Worksheet That Put Team Team Of Worksheet And No Bye In Any Lines And With No Empty Lines
49Ers Division: D15:D20 With Formula Some How Look Up From 49Ers Worksheet That Put Opponents division Only Have 6 Teams With No Empty Lines
49Ers Division: E15:E20 With Formula Some How Look Up From 49Ers Worksheet That Put Away Or Bye With No Empty Lines
49Ers Division: H15:H20 With Formula Some How Look Up From 49Ers Worksheet That Opponents Scores With No Empty Lines
49Ers Division: I15:I20 With Formula Some How Look Up From 49Ers Worksheet That @ NO Bye any lines With No Empty Lines

Must look at Conference and division

Look at Patriots worksheet have some vba code is before.

One my friend give me code it work I want formula instead of vba. the file is updated file have vba code.

Please Login or Register  to view this content.