Search results

Hello Excel Masters!! I want to calculate profit from buying and selling transactions by using FIFO method and matching the quantity. the formula for profit is as simple as = (sell rate- buy rate) * qty, but the qty needs to extracted from the list of transactions. I have attached a file which...

Dear Excel Experts, Hello! In this thread I have attached employee details file which contains Employee Name, attendance, salary amount and email id. There's a separate sheet of Salary Slip which calculates salary as per the selected Month. I need your help in creating VB macro which would...

Dear All, Please help me with the attached file. I need to print variable data preferably without using micros, as my people are not much used to them. The Data sheet contains the daily plan in details. There are two sections of the production. and every day the number of shift changes (1 or...

Dear Excel Gurus, Thanks for your support every time I need! I'm in need of printing reports as given info in the attached file. - I select the product on sheet 'Main' and depending on that lot of data has to be printed on Pg Nos 1 to 5. - Depending on prod cat, I need to print only those...

Dear All, Attached file contains the data table and desired output. You are requested to help me setting the formula.

Dear All, It might b ea basic problem but I'm not getting it solved after using the available solutions on the site. I've three sheets named OffStock, WorkStock and ORData in a single file.. Three different people from different location ( through Google drive) updates these sheets (by copying...

Dear All, Please go through the attached sample file. https://docs.google.com/file/d/0B0W5ZzWOyj6TV0ZpYnBNVHNmNUE/edit?usp=sharing The Data sheet contains the process steps while result sheet shows the batches ( in process) at every dept. I have tried using rank command, but failed to do...

Respected All... I'm stuck wid this basic prob and couldnt find better place than this... I have data table each for year 2012 and 2013. The Columns are same and on the summary sheet I want to plot graph. Considering number of reports (30+) and large tables the file size is big and i dont want...

Dear All, Thanks for solving my previous problem regarding filteration of data... My new query is how to find min and max value in a table based on conditions... the attached file contains the data as well as desired output http://sdrv.ms/U35g1K I tried to search the forum for earlier...

Dear Excel gurus.... I have a specific query to be solved. I have a data in the following manner in one particular file: Monthly Payment 2012-13 Sr. No. Particulars Frequency Type Due Date Person Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar 1 Salary & Wages Monthly Payment 5 GSK 1...