Archived

This topic is now archived and is closed to further replies.

Darth Biscuit

Anybody on here an Excel guru?

6 posts in this topic

I can do this manually but I want to automate it since I'll probably have to do it again...

 

 

I have a spreadsheet with 4 columns...

 

A, B, C, D

 

A is a sequential number

D is an elevation

 

I need a formula that says if column A is X then Average the values in column D.

 

 

It'd be even better if it said if the value in A is equal, then average D.  Make it a little more automated, but either will do.

 

Is this even possible?

 

Share this post


Link to post
Share on other sites

what you are asking for seems like a very basic IF formula. 

 

 

=IF(A1=XX, Average(D1:D4),0).  you can set XX to be another cell and then type in the sequential value you are looking for.  this formula would show either the average you want or a zero, based on the lookup of XX

 

If you don't want the cell to be a o if it doesn't match you can actual have it be blank or plugin a text statement if you want.

 

Share this post


Link to post
Share on other sites

what you are asking for seems like a very basic IF formula. 

 

 

=IF(A1=XX, Average(D1:D4),0).  you can set XX to be another cell and then type in the sequential value you are looking for.  this formula would show either the average you want or a zero, based on the lookup of XX

 

If you don't want the cell to be a o if it doesn't match you can actual have it be blank or plugin a text statement if you want.

 

I think you are correct except that I want it to automatically find the rows it needs in D.

Share this post


Link to post
Share on other sites

Should be able to just nest the IF statement. So basically you need some kind of logic for it to know which rows to average in d. But that kind of function is doable

Share this post


Link to post
Share on other sites

We couldn't figure it out so I had a programmer friend of mine write me a script to process the raw text file.

Share this post


Link to post
Share on other sites

  • Topics

  • Posts

    • You miss the point. Taylor was here before. We picked him because of what he could do for our wide receivers not because he had some great knowledge no other person had on the staff. Shula and Rivera and Gettleman studied multiple college systems for months before signing Taylor or drafting McCaffrey or Curtis and would have drafted the same whether Taylor was here or not. They liked the way Taylor developed McCaffrey which showed his talent but Stanford's offense wasn't Taylors idea or unique to him. Shula has a connection to Taylor as early as when Shula was at Alabama.  The debate was whether Taylor was chosen to replace Shula because Shula didn't know what to do to run a college offense and if he screwed up Taylor would replace him. And that Taylor was the reason and most influential in getting McCaffrey. I said it wasn't even close to the truth and this plan predated Taylor and was more thorough and we'll thought out. Everything since then just confirms I was right once again like usual.  
    • Assholes should've never taken it away in the first place.  Me and a couple buddies had a hookup and were all hyped up and planned out going to it... then the NBA had to get all political and take it out on the city of Charlotte and the fans -- which made no fuging sense.  Seriously doubt we'll even get the chance to go again.
    • 6'6" 255.  He'll definitely have some good mentors with JP, CJ and the rest of the D-Line crew. 255 he'll need to put some weight on don't you think?