Search results

Thank you very much sir. I need to apply this formula for 27000 rows. Do you think it causes any performance issue?

Hi All, I want to find out the sum of first 3 non-blank cells. If there are more than 3 cells in that particular row means we should do the summation only for first 3 occurrences. Sample file attached. Thanks santhosha

Thanks a lot my dear friend. Not sure why did you say it is not robust.

Hi All, Is this something which is possible in Excel,MS Access or SQL? i tried it in different ways using GROUP BY clause.I want to find out the Duplicates(Concatenating Sales Order and Item) with the sequential number.Column 'schedule' is what i am looking for. Pleas help me on this.

Many Thanks. Very clear explanation.

Many Thanks. Very clear explanation.

Dear All, I am stuck up with the concept Moving average . I have explained my problem in the attached workbook. Please have a look on it and get back to me with some solutions. Your help is greatly appreciated. Thanks santhosha

Thank you both

Thank Thanks but some of my data looks like this. 1/22/1900 1:29:15 AM. For this i should get 529 hours.Is there any way to achieve this?

I have a column with time stamp field which contains the time. ie. 7:10:00 AM. I would like to split this field into 2 fields, one with just the Hours portion ie 7 and the other with just the Minutes portion. ie 10.There are some instances where time-stamp is as follows 18:10:00 AM. I tried Left...

Dear All I want to find the duplicates based on two columns.For Example I have Value ABC in Cell B1 and Value XYZ in C1. This is reversed in second Row means XYZ in B2 and ABC in C2. When I concatenate this It is one and same for me. ABCXYZ and XYZABC. Just the values are interchanged. Now i...

Please help me out on this Here is the data 1 column has sales order no and other column has line number,say for example, clumnn A Column B column C 2500 1 0 3000 1 1 2500 2...