Search results

Hello all I have date like this No Co Acct Description Typ Are Line Description Aug-11 399 51 121000 OTHER RECEIVABLES 0 ACCOUNTS RECEIVABLE OTHER 30,350 399 55 112000 EMPLOYEE RECEIVABLE 0 ACCOUNTS RECEIVABLE OTHER (3) 399 55 121000 OTHER RECEIVABLES 0 ACCOUNTS RECEIVABLE OTHER...

Hui Thanks soo much for the formulas...thanks again

Pls help me with this....

Pdt Jan Feb March April May June July A 0.52 0.60 0.60 0.71 0.71 0.66 0.00 B 0.72 0.72 0.71 0.86 0.96 0.81 0.77 C 3.84 4.35 4.39 3.88 4.23 4.06 3.69 D 1.16 1.49 1.49 1.49 1.67 1.92 0.00 E 1.13 1.32 1.32 1.57 1.57 1.44 0.00 F 1.14 1.29 1.29 1.29 3.12 3.18 0.00 I can to apply conditional...

Names Amount James 50 Mark 50 Mark 50 Mark 50 Momeena 10 Momeena 10 Momeena 10 Mark 5 I need this data without using Pivot table Names Amout Mark 50+50+50+5 155 Momeena 10+10+10 30 Any help will be much appreciated. Thanks in advance Jagadeesh

Hello all I want to compare 2 columns from 2 different sheets, if the values form column M= column S(other sheet) match no color if the value is not equal I want to change the color. Please help me with this regard. Thanks Jagadeesh B S

Dear Vijay, thanks for looking into this... Number Value 100010 $50.00 100015 $10.00 100016 $60.00 100017 $70.00 100018 $80.00 100020 $100.00 100021 $10.00 100022 $60.00 100025 $70.00 100026 $20.00 100036 $30.00 100081 $40.00 115049 $50.00 115062 $90.00 118007...

Hello all I need a formula to pick the values form the column based on the condition. 100010 1 100015 1 100016 1 100017 1 100018 1 100020 1 100021 1 100022 1 100025 1 100026 1 100036 1 100081 1 115049 1 115062 1 118007 1 122020 1 122021 1 132002 1 132004 1...

Thank you Hui, Vijay helped me in this regard. Your formula rocks... Thanks again...

Hui I am not getting my desired results...can u give me ur mail id so i can send you the file. My mail id is Jaggabs@yahoo.co.in

Dear Vijay i came to know that this match and index will not help in this criteria. Hui formula helps but somewhere its missing in picking the data... i guess its coz of reference cells given wrong... waiting for the reply form him...:)

Hello Hui, I am getting the result as "0" Could you please look into it and help me again...

Hello all I have date like Cash in Banks - Oper. Accts. 100000 - 100099 Cash in Banks - Time Deposits 101000 - 101099 Restrictive Cash - Current 102000 - 102099 Marketable Securities - Trading 103000 - 103099 Marketable Securities - Available for Sale 104000 - 104099 Marketable...

Hello all, last week i have posted in chandoo.org that i need some VBA code for excel automation for my work, Vijay Sharma helped me with this. He is very helpful in assisting me. Thanks A lot Vijay Sharma:)

Hello friends I am doing an intercompany reconciliation report for which I need some assistance in creating a macro. I have info like Reporting Company Receiving Company Variance Proposed Adjustments / Remarks Name Account Description Curr Balance Curr Balance Account Balance...