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

Great! Excellent! Perfect work! Thanks again Deepak, you are a genius. Regards Vijay Yadav On Friday, 26 July 2013 14:17:30 UTC+5:30, vijay yadav wrote: > > Dear Excel experts, > > I have to sort data in two columns ,first column contains name and second > column contains sa

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

the names as VLOOKUP (and match-index-large) is giving same names for different persons with same salary. Kindly refer attached excel sheet in first post Regards Vijay Yadav On Friday, 26 July 2013 14:17:30 UTC+5:30, vijay yadav wrote: > > Dear Excel experts, > > I have to sort

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

(salary) KISHAN 6 AJAY 24000 SANGEETA 6 *OUTPUT required with help of formulae -* Column C(name) Column D(salary) KISHAN 6 SANGEETA 6 AJAY 24000 Excel sheet is attached containing the data. Kindly help. Regards Vijay Yadav -- Are

Re: $$Excel-Macros$$ Re: NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

Great! This is it! Thanks Deepak,you are a genius Regards Vijay Yadav On Mon, Jul 22, 2013 at 2:53 PM, Deepak Barnwal wrote: > Dear Vijay > > PFA > > regards > > Deepak > > > On Mon, Jul 22, 2013 at 2:08 PM, vijay yadav > wrote: > >> Dear Excel e

Re: $$Excel-Macros$$ Re: NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

Dear Excel experts, Kindly help Regards Vijay yadav On Friday, 19 July 2013 13:57:52 UTC+5:30, vijay yadav wrote: > > > Dear CGMAURYA, > > The file is attached along with this post. > > All details are mentioned below and same is also mentioned in my first > post

Re: $$Excel-Macros$$ Re: NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

Dear CGMAURYA, The file is attached along with this post. All details are mentioned below and same is also mentioned in my first post along with attached file. Regards Vijay Yadav On Friday, 19 July 2013 11:18:16 UTC+5:30, CGMAURYA wrote: > > Dear Vijay, > > Where is attache

$$Excel-Macros$$ Re: NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

Hi Excel experts, Please help in above case. In simple words I need a formula to calculate output considering corresponding cell of B column in same row and a cell in A row. All details are given in excel attached. Kindly help Regards Vijay Yadav On Tuesday, 16 July 2013 14:54:41 UTC+5:30

$$Excel-Macros$$ NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

rent type. Column C = the actual bottle placed i.e output with help of formula Kindly note the actual ranges of A is max 24 nos,B is fixed 16 nos and output is fixed 16 nos. A B Regards Vijay Yadav -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

$$Excel-Macros$$ Re: need formulae to pick next highest value by checking two values - 1) text and 2) number

)),1)+1) =INDEX(OFFSET($A$2:$A$22,0,9),MATCH(A54,OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1,0)),1)+1) *Thanks to Sam Mathai Chacko for initial help which helped me save alot of hours* ** *Regards* *Vijay Yadav * On Wednesday, 25 July 2012 19:31:37 UTC+5:30, vijay yadav wrote: > Dear Expe

$$Excel-Macros$$ Re: need formulae to pick next highest value by checking two values - 1) text and 2) number

Dear Experts In the attached sheet I have the formuale in A55which gives a output by checking the A53 and A54 cells.Also I need outputs in cells A56,A57,A58 and A59. Please help me to get these values. The Answers are in same row ,as the row from where the output in A55 had come under the

$$Excel-Macros$$ Re: need formulae to pick next highest value by checking two values - 1) text and 2) number

headers-"HEADER","RPM","GD sq" and of the adjacent row Please see the attached file Please help Regards Vijay On Sunday, 22 July 2012 02:21:21 UTC+5:30, vijay yadav wrote: > > Great, > > This was exactly what i wanted, > > Please help

$$Excel-Macros$$ Re: need formulae to pick next highest value by checking two values - 1) text and 2) number

hed file Thanks for you very very fast and accurate answer in previous reply. Please help Regards Vijay Yadav On Saturday, 21 July 2012 22:51:37 UTC+5:30, vijay yadav wrote: > Dear Friends/ Excel Experts > > I need formulae to pick next highest value by checking two input values 1)

$$Excel-Macros$$ need formulae to pick next highest value by checking two values - 1) text and 2) number

Dear Friends/ Excel Experts I need formulae to pick next highest value by checking two input values 1) text and 2)number input cells are A53 (TEXT) and A54(NUMBER) formuale should OUTPUT NEXT highest value to number in A54 TEXT IS COMPARED TO A NUMBER OF TEXT ENTRIES IN ROW 1 AND NUMBER IS

$$Excel-Macros$$ Re: to insert rows ,rows inserted should be equal to integer in corresponding cell in the top row

THANKS ! This is it Ashish..thank you! You are just bang on! Also thanks to Don Guillett for the help Regards Vijay yadav On Friday, 6 July 2012 12:29:14 UTC+5:30, vijay yadav wrote: > Hi Experts, > > I need a macro which coluld do the following > > 1)top row contains i

$$Excel-Macros$$ Re: to insert rows ,rows inserted should be equal to integer in corresponding cell in the top row

Hi Don Guillett The macro is giving syntax error Please help. Regards Vijay yadav On Friday, 6 July 2012 12:29:14 UTC+5:30, vijay yadav wrote: > > Hi Experts, > > I need a macro which coluld do the following > > 1)top row contains integer 1 to 50 from B column to

$$Excel-Macros$$ Re: to insert rows ,rows inserted should be equal to integer in corresponding cell in the top row

On Friday, 6 July 2012 12:29:14 UTC+5:30, vijay yadav wrote: > > Hi Experts, > > I need a macro which coluld do the following > > 1)top row contains integer 1 to 50 from B column to BZ column > > 2)other rows contain entries in column A > > > 3)Also ro

$$Excel-Macros$$ to insert rows ,rows inserted should be equal to integer in corresponding cell in the top row

Hi Experts, I need a macro which coluld do the following 1)top row contains integer 1 to 50 from B column to BZ column 2)other rows contain entries in column A 3)Also rows contains one entry beneath the integers in top row the macro should read the columm corresponding to entries in co

$$Excel-Macros$$ Re: need a macro to change the background color a cell as soon as i change the value (alphanumeric)

Great! Exactly what i wanted! Thnaks Vishal! Regards Vijay yadav On Wednesday, 4 July 2012 11:00:42 UTC+5:30, vijay yadav wrote: > Hi Members / Experts > > I need a macro to change the background color of a cell as soon as i > change the value (alphanumeric). > Th

Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

t *shouldn'*t change cell A2 value I think this is not possible with conditional formatting. conditional formatting will highlight all cells with some condition i want to highlight only cell which has a changed value... Please help me in this regard Best regards Vijay yadav On Wednesd

$$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

that case what should be done so that the background color changes to white ? like should I enter the cell and write the value again or any other option Please help me in this regard Vijay yadav -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and

Hi Lalit_Mohan Great work ! wow ! excellent !This works perfect! U are really a expert and a genius in this field This will really save a lot of time and work for me Regards Vijay yadav On Thursday, 28 June 2012 15:39:56 UTC+5:30, vijay yadav wrote: > > Dear members, > >

$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-2

Hi Lalit_Mohan Great work ! wow ! excellent !This works perfect! U are really a expert and a genius in this field This will really save a lot of time and work for me Regards Vijay yadav On Friday, 29 June 2012 14:30:31 UTC+5:30, vijay yadav wrote: > Hi Lalit_Mohan / VBA expe

$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-2

LP ME Regards vIJAY yADAV On Friday, 29 June 2012 14:30:31 UTC+5:30, vijay yadav wrote: > Hi Lalit_Mohan / VBA experts > > Please help me to correct the macro in the above attached sheet to get > the desired output. > > Macro does the following > > Q) X6-

$$Excel-Macros$$ Re: Your feedback is important !

I have posted a request today itself,Should i fill the SURVEY FORM or should i wait for a few days and fill the form when i get a response ? Regards Vijay On Saturday, 9 June 2012 00:23:15 UTC+5:30, Ayush Jain wrote: > Dear members, > > I have received very few responses on feedback reque

$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and

C1 = "=R[-1]C" On Error GoTo 0 .Value = .Value End With Application.ScreenUpdating = True End Sub On Thursday, 28 June 2012 15:39:56 UTC+5:30, vijay yadav wrote: > Dear members, > > Please help me solve the above problem using "macro" or "array formulae

$$Excel-Macros$$ want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and so o

Dear members, Please help me solve the above problem using "macro" or "array formulae". Problem - data seperated by hypen - and comma , to be written in rows existing below (should not insert rows but place data in already existing rows ) eg 1 X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34 ANSWER