Search results

Can I use Vlookup formula to get date from pivot table

I want a formula to get eaches from pack description for example 18 for kitkat,for polo 27. Can you help me PACK Eaches KIT KAT 4 Finger 18(18x37.3g) N3 IN 18 NESTLE CEREGROW BIB 24x300g IN 24 CERELAC STAGE 1 Rice BIB 24x300g N3 IN 24 CERELAC STA1 WheApp Poshan BIB24x300g IN 24...

I need to fill the data with shipment as criteria date and time i am attaching the sample file Can u help me

I want to copy the data into different sheets based on the name as criteria I have pasted the data of one customer i want the data to paste the data of all customers for one customer one sheet

I have to get the details from dump sheet to annex sheet depending on the po number Please help

I select the item code from e column in stock intake i dont have issue in f column stock in take but enter in stock out in g column i have to check whether is quantity avaible in H col in investory sheet Can u please give any solution for this Regards Mohandas

This file is for tracking the inventory for the manufactuing products I have 3 sheets 1 RM (Raw Material) 2 PM (Packaging Material) 3 FM (Finished Material) I have to select in the FM the raw material which is multiple may be more than 1 and pacaking material which also can be the multiple...

Dear Sir, I want to do validation I have 3 sheets 1 RM 2 PM 3 FM I want to do data validation on F column in FM SHeet where i have enter the quantity which has to check in PM sheets whether it has quantity or not ,If not it has to give the message Please help

I Have many sheets which has the brand name and averages. I want data from all sheets into one sheet and sheet name as columns heading can any one help me Regards Mohandas

I have in this sample file 3 sheets called town1, town2,town3 Which has category of oulets namely supermarkets and so on I have another sheet called summary in which this town data needs to be updated Please help me getting the data from that sheets as sheet name and outlet category as...

I have 2 sheets one is pack and another is brand. I was trying to sum the brand basis brand names in b column and quantity in ge columns from pack sheet to brand sheet. There was issue in blanks cells which is giving wrong numbers. Please help me in this issue Regards Mohan

Need to populate the data as per the sheet3 from sheet 2. need to macro to separate block wise data into separate sheeet No of customers is from account no column Collected is amount column due is the blank cells in amount column please heelp

Dear Sirs, I Need some inputs for the file attached to create a dash board Please help me in making it with ur ideas Guide me Mohandas

I need conditional formatting in f column basis g column if it is less than or equal to g column value it is green more the 5 in g colums value it is amber more than 10 it is red Please help

I Have a format which gets data by vlookup formula after getting the formula i need to get data copied and pasted with values in the same place, But that format also contains other formula which has to be as formulas. As solution for this Regards Mohandas

Dear friend. the data in the column a-l is month wise targets of the region it has to divided to the concerned parties based on the percentages for idea i have given 2 parties as example is there any short cut for this problem because i have 87 parties , Please help me in this matter

Dear All, I have one problem to look up I want to get data based on code and and cd code and closing as it is closing sheet I have given exam for one row Can you help Mohandas

I need to get data from data sheet for all the other sheets based on region and sku as criteria There is any formula to get it Thanks

I have 2 works books where sheets names are same . i want to get data from one work to another .there are 50 sheets in both of the files i have attached both same sheets in the excel work as i cannot attahced the file more than 1 mb

Dear Sir, what formula can be used to get the week number for a given date in a month for example 15.05.2016 is week 3 Regards Mohandas

I want to organise the as in the depivot file can you help me Mohandas

Dear Sir, data need to get from channel sheet w7 and brand product x438 to book1 example i have geven from swathi agencies Please help Regards Mohandas

I need populate the data from lactogen1,lactogen2 to praveen sheet

Iam not able to select a file in the upload file

8-10 =400 11-15= 675 16-20= 950 21-25 =1200 There are four small slabs in one column Less than 7 for 400 slab should be marked in red Less than 11 for 675 slab should be marked in red Less than 16 for 950 slab should be marked in red Less than 21 for 1200 slab should be marked in red...