Search results

Hey Could you help me with calculating Average of a range without max and min values. I tried but it is very lenghty. Any shortcut??? Thanks

Hui, Thanks a lot. I just wonder how you people combine so many functions to achieve desired results!!! Gr8 work. About the solution, it worked, but does it work on a range , say A1: A200 or we have to copy paste the formula for each row?? Secondly, i tried to make sense of the formula...

Hie Hui, I believe i wasnt able toexplain the problem. i go again- Col A Col B Chandoo is amazing 1000 Now what i want is, that if my criteria is "chandoo" then excel returns the value in Col B against the text "chandoo is amazing" or sum the values for the rows where...

Hie again!! Is it possible to retreive some data based on a word in a long text??? I have a column with some text and value corrosponding to it in another column. Now i want to retreive value if a particular word is anywhere in the long text. eg i want to pick value against the word...

Forum, Hie. Just when i thot i understood this logic, then only the formula seem to have given up on me. I am trying to CF a colmumn which has debtor's name. The logic i m tryin to use is that if the particular bucket in which amount o/s against d debtor falls is greater than the credit...

Thanks a lot , Luke, Hui and Kchiba. now it is making sense to me. Probably little slow with logic, but thanks for your patience.

Hui, Thats where I have confusion. If the countif arguement is false, then it should be zero and thats y u had used in that post for some other purpose, countif(lst2,B21)=0 So when we want the function to higlit values when it is true, then y do we use the operator>0. cant we use...

Hui, Thanks and apologies for the delayed response. I would be more specific,. In one of posts on comparison Ninza, while comparing 2 lists and hiliting values in both lists, the formula used was-: COUNTIF(lst2,B21)>0. Now my question is, we are essentially trying to find same entries...

Hui, Thanks for the link. Dashboards are indeed great tool, but the extent of information and look of it is intimidating. Still, thanks

Hie forum, What is the best way to depict multiple data series in one table and chart, like productwise, customerwise, yearwise, sales data. I would appreciate any suugestions. I use open office and it does not have all functionalities of excel.

Chandoo, Hie again!! I have seen many posts of urs using logical functions in CF, like Iserror, countif, Not, And. However, many a times i had just picked up formulas directly without understanding logic behind it. Would u be kind enough to tell me why do we use in certain formulas, >0 and...

Hey TeesaES, Thanks a lot, it works!!!! BTW, if and when u have time, could u explain to me d logic behind it not workin earlier with cell reference as "A1" and now working with reference "A30"??? Thanks again

Hui, The entries in Col. A & B is through Vlookup and manual entry and the range does not form part of any table and neither any CF is applied to any cells in that range. BTW, i am using Open office3.2. I hope the formulas apply equally to excel and Open office. The formula just does not...

Hui, Seems the cells are stubborn. Just not complying. It does not work and when i randomly click on any cell in the range and go to CF, the formula shows as AND($a#Ref!=0,$b#Ref!=0) I hope I have communicated the exact nature of problem now. Would appreciate if you can solve my problem.

VaraK, Thanks for the reply. I am afraid it is not working. The formula in the conditional formatting for cells in the range is showing reference error and therefore the cells dont get higlited as per the condition. Wld appreicate if you could offer alternate solution or point out where I...

Chandoo, Hie. I have benefited immensly from your blog and real heart felt thanks to you. Have a issue with your favourite topic. There is data in column A and Column B. I want to set a rule that highlits the cell values in Col A and Col B, when zero, only and only when both columns contain...