Formula Help!!! median

[Fanwood]

look in cell G[row] at that number. See if that number is greater than or less than the median of all items in G:G *.8 with the same county in C:C.

 

[pgc01]

Hi

Are you sharing with us (part of) your homework assignment?

 

[Fanwood]

Hi

Are you sharing with us (part of) your homework assignment?

No This is for my business. I am an appraiser.

 

[pgc01]

Well, it's too telegraphic for me.

I'd need
- a brief explanation of what this is about
- the logic (what you posted a tad more elaborated)
- a sample of data, input and output expected
- what type of solution you need, vba or formula
- the excel version you have

I believe you'd get more answers with a more complete post.

It may be enough, however, for some other members and I hope, of course, that you get a quick solution.

 

[Fanwood]

Well, it's too telegraphic for me.

I'd need
- a brief explanation of what this is about
- the logic (what you posted a tad more elaborated)
- a sample of data, input and output expected
- what type of solution you need, vba or formula
- the excel version you have

I believe you'd get more answers with a more complete post.

It may be enough, however, for some other members and I hope, of course, that you get a quick solution.

I was able to work the formula out myself.
{=IF(MEDIAN(IF(C:C=C26,G:G))*0.8>G26,"Less Than","Greater than")}

 

[pgc01]

I'm glad your problem is solved.

Remark: it's not a good idea to use formulas that refer to whole columns. If you have many of them you'll soon remark how sluggish the workbook gets.

It's always better, if possible, to use specific ranges. For ex., if you think that you'll always have less than 1000 rows:

=IF(MEDIAN(IF(C1:C1000=C26,G1:G1000))*0.8>G26,"Less Than","Greater than")

If you just have a couple of such formulas, however, it shouldn't make difference.