$$Excel-Macros$$ Look formula required

2015-03-27 Thread Rajesh thrissur
Hi Experts please check the attached table , there i have to select a value from one table to another based on the criteria given. pls help me Regards Rajesh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

Re: $$Excel-Macros$$ Re: use sumproduct formula to find min max values

2013-11-01 Thread Rajesh thrissur
Hi Thanks for the reply now I got it. Regards Rajesh On 10/31/13, Rajan sharma rajansharma9...@gmail.com wrote: Hi, CSE stands for Control + Shift + Enter ( Enter in same time after entering the formula) With warm regards, Rajan Sharma On Thu, Oct 31, 2013 at 10:20 AM, kasper

$$Excel-Macros$$ use sumproduct formula to find min max values

2013-10-30 Thread Rajesh thrissur
Hi Experts Please refer the attached document and tell me how can I get the min and max values of each month from the given data using sumproduct or any other methode suitable to that. Regards Rajesh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ list selection code according to condition

2013-02-17 Thread Rajesh thrissur
Hi Experts In my file there is form contains 2 text box. 1 cmd button 2 listbox.I need to get display listbox1 if the cursor is in textbox1 and display listbox2 if the cursor is in textbox2 . Here is the codes I am trying Private Sub CommandButton1_Click() If TextBox1.TabStop Then

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-23 Thread Rajesh thrissur
the people you can, As long as ever you can.” - John Wesley -- --- From: Rajesh thrissur rajeshka...@gmail.com To: excel-macros excel-...@googlegroups.com Sent: Tue, January 22, 2013 7:36:40 AM Subject: $$Excel-Macros$$ Consolidate

$$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-22 Thread Rajesh thrissur
Hi Experts, Is there any method to consolidate data from many worksheets to one master worksheet, here I attached a simple work book it have only 5 data sheets and 1 master sheet. being data is very less I solve it with just adding data from reference cells but when data is more this method is

$$Excel-Macros$$ Fwd: Select Unique values

2013-01-01 Thread Rajesh thrissur
Hi Experts, Please refer the attached file tell me How to select employee names from the column B and display in Column D after removing the duplicate. Regards Rajesh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

$$Excel-Macros$$ Need sumif formula with 2 conditions

2012-12-26 Thread Rajesh thrissur
Hi experts, Please check the attached file.In it the first table contains daily purchase data, I want to get a summery report of the same in the second table format, How can use a formula with two criteria . Regards Rajesh -- Join official Facebook page of this forum @