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

    • I would be more than happy with a battle of the Carolinas for the title (if for no other reason than it means we got by UK and KU). Please beat Florida for me.  I am sick of hearing about them.
    • Ross for me. Davis is good, but the same way Ross' previous injuries give people pause, so should Davis' competition. You can only play who's on your schedule, but Davis played against inferior talent and, for the most part, got shutdown against good schools (Wisconsin, OSU). He did dominate the other schools so I'm not saying he won't be a good pro. I just think this T.O. talk and saying he's going to beast out could be premature.  Davis last game he was shut down by Wisconsin and then, due to injury, hasn't run at the combine or his pro day. For me, that's a little risky too at #8.  I wouldn't take Ross at 8, but what we need based off of our roster is a player of Ross' abilities and strengths, IMO. I wouldn't be mad with Davis, but I prefer Ross and would not want either at #8.