I have three columns...I want to find the coulum that has the miniimum value that is greater than zero, what do I do...? Thanks

using min(C1,D1,E1) but columns with zero, I get zero obviosly?

 

 

Ppppsshhhtt....yeah, like you know what you're talking about


What up Jay! Long time no see.

 

If your not part of the solution you are part of the problem.......

we all know using the help from the software is garbage

 

umm dewd the help in office is pimp - use the web help :D - i have found many graasshoppers that way

 

EWWWEEE formulas suck can't help you but I feel you pain working on a Market Research presentation as we speak

 

Select your cells. Go to Format/Condiotional Formatting/add values and what you want it to do.

ex) in mine. you see that I have everything less then 15 is set for Blue font.

Hope this helps.

 

Thanks, but can't get that to narrow down to one choice...

Basicaly, take three amounts and want to highligh/callout the cheapest (only 1), except if its zero

 

Yeah. not unless you mess w. the values more.You might be able to do it.

You can try looking in help for an "IF" logical use. Maybe even "LOOKUP"

But Excel coding is weird to me compared to C#. Can I call it even coding?

 

Set up your sheet like my example with your data in rows and your row totals in the same column. Now highlight your top row, in my case it was the days of the week and click on data, the filter the auto filter. Now hit the drop down on your total column and select custom, here you can enter your info (is = to or less then or whatever)

 

Tim what's on your shirt? Is that a pic of another guy?

 

i knew u where a purple kinda guy !

 

Thanks, but still does not get a min that is greater than zero...I gave up and just did it manually

 

Yes, its Timmmmmay, I believe...I never really watched the show very much

 

timmma timma !!

 

mmmmm hmmmmmmm

 

Ha haaa that's great!

 

By the way I meant to tell you I think your peace sign is blingin

 

I know right! I'm the only blinging yippie you know!