Jump to content


Photo
- - - - -

Anybody on here an Excel guru?


  • Please log in to reply
5 replies to this topic

#1 Darth Biscuit

Darth Biscuit

    Dark Lord

  • HUDDLER
  • PipPipPipPipPipPipPipPipPip
  • 33,984 posts
  • LocationWilmington, NC

Posted 25 April 2014 - 09:14 AM

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?

 



#2 logic1977

logic1977

    Senior Member

  • HUDDLER
  • PipPipPipPip
  • 407 posts

Posted 25 April 2014 - 09:22 AM

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.

 



#3 Darth Biscuit

Darth Biscuit

    Dark Lord

  • HUDDLER
  • PipPipPipPipPipPipPipPipPip
  • 33,984 posts
  • LocationWilmington, NC

Posted 25 April 2014 - 09:24 AM

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.



#4 logic1977

logic1977

    Senior Member

  • HUDDLER
  • PipPipPipPip
  • 407 posts

Posted 25 April 2014 - 07:46 PM

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

#5 Panthro

Panthro

    aka Pablo

  • Moderators
  • 24,327 posts

Posted 25 April 2014 - 08:34 PM

Vlookup perhaps

I'm sort of one

#6 Darth Biscuit

Darth Biscuit

    Dark Lord

  • HUDDLER
  • PipPipPipPipPipPipPipPipPip
  • 33,984 posts
  • LocationWilmington, NC

Posted 25 April 2014 - 09:04 PM

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


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Shop at Amazon Contact Us: info@carolinahuddle.com