Re: $$Excel-Macros$$ Extract Names which are not common

2013-08-22 Thread Deepak Barnwal
Dear Santosh, PFA solution of your problem. Regards Deepak On Thu, Aug 22, 2013 at 2:16 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Anil, > > Thanks for your prompt reply. > > However the solution did't solve my problem. > > I have attached the solution sheet with desire

Re: $$Excel-Macros$$ VBA for Data Validation Question

2013-08-01 Thread Deepak Barnwal
PFA Is this what you are looking for. If not send an example file. Regards Deepak On Thu, Aug 1, 2013 at 10:26 PM, RJQMAN wrote: > I am not sure if this is the proper way to reply, so forgive me if I am > not doing this correctly. I thought I posted the code but perhaps I did not > do it corre

Re: $$Excel-Macros$$ Re: SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as per descending order of salary

2013-07-26 Thread Deepak Barnwal
Dear Vijay PFA Regards Deepak On Fri, Jul 26, 2013 at 3:18 PM, vijay yadav wrote: > Dear Kartik, > > Thanks for the suggestions. > I do not want to sort list manually but need formuale to sort the above > columns as there is some interlinking with other cells. > > Also i can sort the salary i

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Deepak Barnwal
On Fri, Jul 19, 2013 at 5:05 PM, Excel_Lover wrote: > Dear All, > > Attached is a sample data in which I have some month wise item total, I > need a formula which can calculate SUM of an item from the Month Jan-12 to > till the month which we are selecting in the column D1. > > Appreciate if som

Re: $$Excel-Macros$$ Too many cell formats

2013-07-11 Thread Deepak Barnwal
This problem occurs when the workbook contains more than approximately 4,000 different combinations of cell formats in Excel 2003 or 64,000 in Excel 2007 and higher. A combination is defined as a unique set of formatting elements that are applied to a cell. A combination includes all font formattin

Re: $$Excel-Macros$$ Need Formula

2013-07-05 Thread deepak barnwal
Hi Prabhakar find the solution as per your requirement On Fri, Jul 5, 2013 at 12:32 PM, Prafull Jadhav wrote: > Dear Prabhakar, > > find the same ...It is alternate use... > Our expert can give you better solution on it. > > Regards, > Prafull Jadhav. > MIS-executive. > > > > On Fri, Jul 5, 2013