Search results

Though i have replied it on email, i found following links useful and interesting. http://www.mrexcel.com/forum/excel-questions/361022-tree-data-structure-excel-data.html#post1786498 http://www.cainhill.com.au/blog/excel-to-tree/...

Let me reach home.

Hi Rupesh, Please see attachment.

Hi Sachin, We use domaze.net instead, same stuff available otherwise. Narayan's link will be very useful for you. Have a nice weekend.

:) It is banned in Pakistan. hehehehe

HI, If you have 100 rows, the formatting will highlight top or bottom 10 rows. The change will be more visible if you sort column low-to-high for the value you are interested in.

means in whatever comes before RES should be paid, either it is 1 or wo? is that correct?

Your regional formula in F14 contains two conditions, if both of these conditions are true (a AND type relations) then you want cell to have Either Green, Amber or Red. Is this correct?

There is already one formula in there.. what do you want to change.

Please try this with ctrl+shift+enter =IF(BP3="Active","Active",INDEX($L$2:$AO$2,MAX(IF(L3:AO3=1,COLUMN(L3:AO3)-COLUMN(K3))))) Drag down.

Hi Locusta, Please try this with CSE =IFERROR(ROUND(AVERAGE(AVERAGE(IF($E$1:$G$1=TRANSPOSE(LARGE(IF($E3:$G3>0,$E$1:$G$1),{1,2,3})),$E$3:$G$3))),0),"")

Try inserting IF() within percentile function so that values feed to percentile are equal to 100. and try using a vlookup table or lookup() to fetch the values.

@teylyn Setting value to greater then one will highlight all subsequent values greater then one. Please check.

="Please confirm to us in writing before the end of "&"TEXT(EOMONTH('Housing Application'!C2,2),"DD-MMM-YYY") Hope it helps.

Goto conditional formatting and put this formula in conditional formatting menu with formula =COUNTIF($A$1:$A1,A1)=1 assumes your data in col A

Please put this formula in some cell and drag to right, see if it works. =SUMPRODUCT((YEAR($E$12:$AU$12)=YEAR(E4+1))*($E$13:$AU$13))

Hi Sampath Please see attachment.

@DAGUET, Please remove your personal info from your signature. Please post a sample file, it will be easier for others to respond.

Dear Qayyum, Any update on this?

Dear Qayyam, sorry for late reply, please see attachment.

For first part of the question: You can sort for the company's name and add subtotal to the amount. For second part, you need to wait for some vba guy.

Hi bfree, Please see this link: http://christianpf.com/10-free-household-budget-spreadsheets/ if you need modification then you can ask for it.

If your dates are true dates then this should work: =ABS(A4+B4-(C4+D4))

Your dates are not true dates..

@pallu, have you checked the attachment i have worked out same pattern in it.