Search results

Hi Faseeh, Thanks a lot for raising queries , sill I'm not done with this w.r.t to below - 1.PT I'm currently using is the best possible way i found apart from trying others. Please let me know if you've any alternate option. 2.This file actually gets generated by a typical system and...

Luke, I practically don't think so, well let me go ahead and explain this- A management information system (MIS) provides information that is needed to manage organizations efficiently and effectively, This is actually a type of report as per organizational requirement on prescribed...

Dear All, Attached if the file showing pending consignments of a courier company . https://docs.google.com/open?id=0BwzKuUvuZlkcMW1GZGtBbWR5Tlk In different columns showing different details as below - 1.Consignment no - Consignment number of the sent packet 2.Originator name- the...

Chandoo, let me try this too.. anyways if u're suggesting it must work since u're excel God ( That's what I discuss with all my friends and colleagues discussing tricks suggested by you ) SirJB7, Hope now u're comfortable with my name

Dear All, May i request every ninjas to look into this please.. I'm still stuck

Hi Satish, Thanks a ton for revert, actually pending columns are the count of work left pending as on last day or may be better explained "pending as on date" Would be great if you could share the excel format ( since i'm still stuck with this :) Thanks...Saumya

Hui Thanks a lot, Clean worked smoothly. Muneer, Thanks.. TRIM i've used earlier also and using CLEAN and SUBSTITUTE is good Shrivallabha, Thanks a lot. @all above, thanks a ton for help, you all rock!!

Dear All, My solution is not found yet, please help..Thanks..Saumya

Good Morning and greetings for the day. Recently I've been working on a project where I've to do a vlookup from a series of 8digits of no. say row A1 with a data. Now the problem is I've copies and pasted numbers from different sources and some space is appearing in some cases. for eg. A1...

Hui I've added concept of Full Time Equivalent ( FTE ) and got something like this https://docs.google.com/open?id=0BwzKuUvuZlkcYUJ3SkVzVl9TdVU But still don't you think something lacks, please review.

Hui =Iferror(Existing Formula, 0) this is working fantastic in my formula error parts, but still stuck with above.

Hui Let me explain this time.. Suppose we're running a finance company back-end operations, where lots of activities are happening department wise. Now departments may be categorized as ACCOUNT SERVICES / BBO ACTIVITIES and so on. Since the list of department is large so in the example file...

Dear Hui, Please update if you've found some solution to my query, still I'm stuck with this..

Dear Hui, You may refer this excel file i've attached with google drive/docs https://docs.google.com/open?id=0BwzKuUvuZlkcYUJ3SkVzVl9TdVU There are various activities like ACCOUNT SERVICES & BBO ACTIVITIES. Now in account services sub activities are there with date wise count of work...

I need some help in creating a data from below raw data, scenario is like this. ACCOUNT SERVICES Date 01-Oct-12 02-Oct-12 03-Oct-12 04-Oct-12 05-Oct-12 Collections Schedule Updation 1243 956 789 1967 2100 Collection Updation - Manual Cases 23 43 25 29 32 Branch PDD 765 265...