Re: $$Excel-Macros$$ Conditional Concatenate

Dear Rajan ji, Please find attachment & solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma wrote: > can be done with using concatenate function > =A1&","&B1&","&C1&","&D1 > > Rajan > > On Thu, Jan 10, 2013 at 11:53 PM, Satendra kumar < > satendrakuma...@gmail.com> wrote: > >>

Re: $$Excel-Macros$$ merge data

hi Smitha, please get this Public Sub CombineData() Public Sub CombineData() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets If wks.Name = "Index" Or wks.Name = "Output" Then GoTo lbl Else wks.UsedRange.Copy Wit

Re: $$Excel-Macros$$ Conditional Concatenate

can be done with using concatenate function =A1&","&B1&","&C1&","&D1 Rajan On Thu, Jan 10, 2013 at 11:53 PM, Satendra kumar wrote: > Dear Anil, > > i have large database so how to define colored range?? > > > > =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,",",O3,",",O4,",",O5 > ),""),"") >

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

Glad to see this mail for you, keep it up good work.. Congrats :) Rajan verma On Fri, Jan 11, 2013 at 12:10 AM, amar takale wrote: > Dear Prince, > > > Congratulations my friend, well done and keep it up excellent work for our > group. > > > Warm Regards, > Amar > > > On Fri, Jan 11, 2013 at 1

Re: $$Excel-Macros$$ Re: Sumproduct Formula Required

Dear Prince, Great, thats perfect solution.Many Many Thanks boss. On Fri, Jan 11, 2013 at 12:45 PM, Prince wrote: > =SUMPRODUCT(($C$164:$C$182),IF(ISERR(D164:D182),0,(D164:D182)))/$C$183 > wuth CSE > > > paste this is in C185 > > regards > > > On Friday, January 11, 2013 12:15:53 PM UTC+5:30, am

Re: $$Excel-Macros$$

Hi, can you this =VLOOKUP(A3,$A$3:$B$8,2,0) =HLOOKUP(B2,$B$2:$C$4,1,0) thankx satendra On Fri, Jan 11, 2013 at 12:52 PM, Ruchi Sharma wrote: > Hi, > > How to use hlookup and v lookup in Excel Worksheet. > I need to know the formulas. > > > Regards > Ruchi sharma > > Sent from my i

$$Excel-Macros$$

Hi, How to use hlookup and v lookup in Excel Worksheet. I need to know the formulas. Regards Ruchi sharma Sent from my iPhone -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Pl

$$Excel-Macros$$ Re: Sumproduct Formula Required

=SUMPRODUCT(($C$164:$C$182),IF(ISERR(D164:D182),0,(D164:D182)))/$C$183 wuth CSE paste this is in C185 regards On Friday, January 11, 2013 12:15:53 PM UTC+5:30, amar takale wrote: > > Hi All, > Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but it > is so long & Confusing

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

Dear Prince, Congratulations my friend, well done and keep it up excellent work for our group. Warm Regards, Amar On Fri, Jan 11, 2013 at 11:32 AM, अनिल नारायण गवली wrote: > heartly congratulations prince. > > Warm Regards, > Gawli Anil > > On Fri, Jan 11, 2013 at 11:04 AM, NOORAIN ANSARI >

Re: $$Excel-Macros$$ merge data

It not working, run time error 1004 appears On Fri, Jan 11, 2013 at 12:23 PM, Prince wrote: > https://groups.google.com/**forum/?hl=en&fromgroups=#!** > searchin/excel-macros/merge/**excel-macros/8T3EPECvA10/**Y3vwNk6wM-YJ

Re: $$Excel-Macros$$ merge data

Hi, Any one please help me in combining the data in two different work sheets in to another worksheet. Its really urgent. On Fri, Jan 11, 2013 at 12:30 PM, Smitha S R wrote: > It not working, run time error 1004 appears > > On Fri, Jan 11, 2013 at 12:23 PM, Prince wrote: > >> https://groups.

Re: $$Excel-Macros$$ Conditional Concatenate

Dear Anil, i have large database so how to define colored range?? =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,",",O3,",",O4,",",O5 ),""),"") On Fri, Jan 11, 2013 at 11:50 AM, अनिल नारायण गवली wrote: > Dear Satendrakumar, > > use this =CONCATENATE(A1&","&B1&","&C1&","&D1) > if u want

Re: $$Excel-Macros$$ merge data

https://groups.google.com/forum/?hl=en&fromgroups=#!searchin/excel-macros/merge/excel-macros/8T3EPECvA10/Y3vwNk6wM-YJ On Friday, January 11, 2013 12:20:39 PM UTC+5:30, Smitha S R wrote: > > NO,PLEASE send it once more > > On Fri, Jan 11, 2013 at 12:14 PM, Prince > > wrote: > >> dear >> >> have y

Re: $$Excel-Macros$$ merge data

NO,PLEASE send it once more On Fri, Jan 11, 2013 at 12:14 PM, Prince wrote: > dear > > have you seen that lik i have provided > > > > On Friday, January 11, 2013 11:58:33 AM UTC+5:30, Smitha S R wrote: > >> HI, >> >> is this possible.. >> >> On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R wrote: >

Re: $$Excel-Macros$$ merge data

dear have you seen that lik i have provided On Friday, January 11, 2013 11:58:33 AM UTC+5:30, Smitha S R wrote: > > HI, > > is this possible.. > > On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R > > wrote: > >> Hi, >> >> Please help >> >> >> On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R >> > wro

Re: $$Excel-Macros$$ merge data

HI, is this possible.. On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R wrote: > Hi, > > Please help > > > On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R wrote: > >> HI, >> >> Is this possible without macros >> >> On Fri, Jan 11, 2013 at 11:12 AM, ashish koul wrote: >> >>> Try this >>> >>> Sub merge

Re: $$Excel-Macros$$ Conditional Concatenate

Dear Satendrakumar, use this =CONCATENATE(A1&","&B1&","&C1&","&D1) if u want "," in between. or else share the workbook wit us. Warm Regards, Gawli Anil On Fri, Jan 11, 2013 at 11:45 AM, Satendra kumar wrote: > Dear Expert, > > Solve this query..i want automate colored range. if you have a

$$Excel-Macros$$ Re: Want to copy 2nd sheet of all workbook in a particular folder

Hi Sandeep. May be if this code help you. Public Sub GetRawDataInWorkBook() Dim objFso As Object: Dim objFolder As Object Dim objFileAs Object: Dim wbkSrcContact As Workbook Dim wbkSrcTarget As Workbook: Dim strF

Re: $$Excel-Macros$$ HELP REQUIRED

Pl provide a meaningfull subject. Warm Regards, Gawli Anil On Fri, Jan 11, 2013 at 10:57 AM, joginder kumar wrote: > HI GUROPS MEMBER , > > > PLEASE HELP REGARDING THIS SHEET . > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

heartly congratulations prince. Warm Regards, Gawli Anil On Fri, Jan 11, 2013 at 11:04 AM, NOORAIN ANSARI wrote: > Congrats Prince Babu... > > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com > http:// >

Re: $$Excel-Macros$$ merge data

Hi, Please help On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R wrote: > HI, > > Is this possible without macros > > On Fri, Jan 11, 2013 at 11:12 AM, ashish koul wrote: > >> Try this >> >> Sub merge1() >> Dim i As Long, z As Long >> ' add new sheet at last and name it merge >> Sheets.Add After:=S

$$Excel-Macros$$ Re: HELP REQUIRED

Hi Jai, I m not able to understand ur requirments. Please provide us at least on example to what we needs to do. Regards Prince On Friday, January 11, 2013 10:57:48 AM UTC+5:30, Jai Bhati wrote: > > HI GUROPS MEMBER , > > > PLEASE HELP REGARDING THIS SHEET . > -- Join official Facebook pa

$$Excel-Macros$$ Re: merge data

Hi Friend, May be this will be helpfull for you https://groups.google.com/forum/?hl=en&fromgroups=#!searchin/excel-macros/merge/excel-macros/8T3EPECvA10/Y3vwNk6wM-YJ regards Prince On Friday, January 11, 2013 11:04:04 AM UTC+5:30, Smitha S R wrote: > > Hi, > > How to merge data in two excel w

Re: $$Excel-Macros$$ merge data

HI, Is this possible without macros On Fri, Jan 11, 2013 at 11:12 AM, ashish koul wrote: > Try this > > Sub merge1() > Dim i As Long, z As Long > ' add new sheet at last and name it merge > Sheets.Add After:=Sheets(Sheets.Count) > Sheets(Sheets.Count).Name = "Merge" > For i = 1 To Sheets.Count

Re: $$Excel-Macros$$ merge data

@S R try this one Sub merge1() Dim i As Long, z As Long ' add new sheet at last and name it merge Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = "Merge" For i = 1 To Sheets.Count - 1 ' add headers from first sheet If i = 1 Then ' find last filled row in the sheet z = Sheets(i).R

Re: $$Excel-Macros$$ merge data

Try this Sub merge1() Dim i As Long, z As Long ' add new sheet at last and name it merge Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = "Merge" For i = 1 To Sheets.Count - 1 ' add headers from first sheet If i = 1 Then ' find last filled row in the sheet z = Sheets(i).Range("a1

Re: $$Excel-Macros$$ merge data

HI, Data for the first jan is in one sheet and data for second jan is another sheet. I have to get data in another worksheet for both dates. On Fri, Jan 11, 2013 at 11:05 AM, NOORAIN ANSARI wrote: > Hi Smitha, > > can share a sample with group. > > > > On Fri, Jan 11, 2013 at 11:04 AM, Smitha S

Re: $$Excel-Macros$$ merge data

Hi Smitha, can share a sample with group. On Fri, Jan 11, 2013 at 11:04 AM, Smitha S R wrote: > Hi, > > How to merge data in two excel worksheets to another work sheet > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concis

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

Congrats Prince Babu... -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Thu, Jan 10, 2013 at 10:19 P

$$Excel-Macros$$ merge data

Hi, How to merge data in two excel worksheets to another work sheet -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

Re: $$Excel-Macros$$ excel tips

Nice Stuff Noorain Bhai. On Thursday, January 10, 2013 11:35:01 PM UTC+5:30, NOORAIN ANSARI wrote: > > Dear Putta, > > See attachments, Hope it will help to you. > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com > h

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi Sir, Myself sundar from chennai, First i would appreciate on your brief explanation for MIS role, it is very clear to understand. i have been working as HR for past 3 Years, but my role as HR is not satisfying me. I was looking for a change where i don't interact with people much, and so i

Re: $$Excel-Macros$$ Finding the relative position of an item in a list *

Hi Hilary, What i think is instead of just validation list box you should pick combobox of form control and then link its itm index with a cell that give you ur expected output. so please follow the below mentioned steps. Goto developer tab->Insert->Select Combobox Control->Draw it on ur sheet

$$Excel-Macros$$ Re: Introduce Yourself !!

Welcome Harish (: regards Prince On Friday, January 11, 2013 9:57:39 AM UTC+5:30, harish.yog...@gmail.com wrote: > > > Hi Myself Harish, > I am from INDIA, > i am a civil engineer > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Re: Conditional format & formula

Hi Shiva, I guess you need to explain the problem with an example as it is not clear to us what actually we needs to do. Regards prince On Thursday, January 10, 2013 5:09:20 PM UTC+5:30, shivapr...@gmail.com wrote: > > Dear Champs, > > i need one excel formula help tat with conditional format

$$Excel-Macros$$ Re: Introduce Yourself !!

Hi Myself Harish, I am from INDIA, i am a civil engineer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

Congrats Prince On Fri, Jan 11, 2013 at 9:19 AM, wrote: > ** > Many congratulations to u Prince... > Sent from my BlackBerry® smartphone from !DEA > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Thu, 10 Jan 2013 22:19:58 +

$$Excel-Macros$$ Need help in Creating Data

Hi, Need Help Please find the attached file, they are standard weight of structural steel sections in ABS sheet of the work book, when i want to work in a new sheet of the work book the standard weight of the section should get automatically uploaded as i enter the name of the section . and the

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

Many congratulations to u Prince... Sent from my BlackBerry® smartphone from !DEA -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Thu, 10 Jan 2013 22:19:58 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Prince Kumar - Mo

$$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member December'12

Congrats Pricekeep helping man... On Thursday, 10 January 2013 22:19:58 UTC+5:30, Ayush Jain wrote: > > Dear members, > > Prince Kumar has been selected as 'Most Helpful Member' for the month of > Dec'12. He has posted 92 posts last month and helped forum members through > his excel expertis

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12 *

Congrates chief keep it up On Jan 10, 2013 7:58 PM, "Bé Trần Văn" wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (betnmtdongna...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

Congratulations Prince Kumar Congratulations on receiving a certificate of honorary awards help to members in the professional forum through excel. I really appreciate your knowledge. 2013/1/11, Ayush Jain : > Dear members, > > Prince Kumar has been selected as 'Most Helpful Member' for the mont

Re: $$Excel-Macros$$ Re: Vlookup for two same values

Dear Harshad, Please try.. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Fri, Jan 4, 2013 at 2:52 PM, Prince

Re: $$Excel-Macros$$ Conditional format & formula

Dear shiva, Please explain more.we are bit confuse in TAT Complete and before TAT but not complete. On Thu, Jan 10, 2013 at 9:06 PM, Shiva Prasad wrote: > plz provide any one this solution. > > > On Thu, Jan 10, 2013 at 11:39 AM, Shiva Prasad > wrote: > >> Dear Champs

$$Excel-Macros$$ excel tips

Hi Group, Can you please share the consolidated Excel tips. I need to educate some users who are new to excel. Required tips on Basic Excel & Advanced Excel. With Regards, PMadaiah -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise

Re: $$Excel-Macros$$ Conditional format & formula

plz provide any one this solution. On Thu, Jan 10, 2013 at 11:39 AM, Shiva Prasad wrote: > Dear Champs, > > i need one excel formula help tat with conditional format & formula. > > > i tried if and if error but mistake but exact values are not received. > plz any one help me > please find the ex

$$Excel-Macros$$ Re: How to get max number from a database ?

Hi All... Thanks a lot for the reply. :) Regards Karan On Wednesday, 9 January 2013 15:35:50 UTC+5:30, karan wrote: > Hi > Can anyone pls let me know how do i get the max value or date (using a > formula and not pivot) from the database that i have. > > Attached is the database. > > Than

Re: $$Excel-Macros$$ Finding the relative position of an item in a list *

Thanks Viper i thinks its a good idea, i can do some modification and see what happens but its a great step for me, thanks to every one who assisted. thanks so much On Thu, Jan 10, 2013 at 12:30 PM, The Viper wrote: > [image: Boxbe] This message is eligible > fo

Fwd: $$Excel-Macros$$ Probability

Hi Noorain Can you please help me on this. -- Forwarded message -- From: Smitha S R Date: Thu, Jan 10, 2013 at 5:18 PM Subject: Re: $$Excel-Macros$$ Probability To: excel-macros@googlegroups.com Hi, I need mix of all the places with the kms derived from the data table for eg:

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

What you're asking is not possible without helper column. here is my openior. PFA On Thu, Jan 10, 2013 at 5:39 PM, Hilary Lomotey wrote: > Thanks Noorain, > > for what am trying to do, i need a formula instead. But that is the exact > principle of what i was explaining. thanks > > > On Thu, Jan

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

Thanks Noorain, for what am trying to do, i need a formula instead. But that is the exact principle of what i was explaining. thanks On Thu, Jan 10, 2013 at 12:03 PM, NOORAIN ANSARI wrote: > Hi Hilary, > > See attached sheet, Hope it will help to you.. > > > -- > With Regards, > Noorain Ansari

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

Hi Hilary, See attached sheet, Hope it will help to you.. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Thu, J

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

Very Grateful Exl. learner But i guess i didnt explain myself properly, i will try and again Assuming Moda appears in the First, Fifth and tenth Row, if i select Moda from the the data validation drop down ie the first moda, i expect to see 1, if i select Moda from the fifth row, i expect to see

$$Excel-Macros$$ Re: Boxplots in Excel 2010

Forgot to say: You need to select at least one column with at least 5 rows, excluding the title row (which also needs to be selected) On Thursday, January 10, 2013 12:57:01 PM UTC+1, Adrian Teodorescu wrote: > > This is a rudimentary (and not thoroughly checked) graphical > representation of dat

$$Excel-Macros$$ Boxplots in Excel 2010

This is a rudimentary (and not thoroughly checked) graphical representation of data as a boxplot. It does not check the outliers using Grubb's test however shows outliers that are farther than 1.5 IQR. Looking for ideas on improving it. Copy and paste the code into a new module and run the macr

$$Excel-Macros$$ Roman to Arabic

This is a rather rudimentary conversion of Roman numerals into Arabic (inverse of ROMAN function in Excel 2010) Just copy the code and paste it into a new module. then in excel cell, type = Arabic("xxx") where xxx is the Roman numeral (e.g. MMDX) -- Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Re: Finding the relative position of an item in a list

Very Graeful Prince But i guess i didnt explain myself properly, i will try and again Assuming Moda appears in the First, Fifth and tenth Row, if i select Moda from the the data validation drop down ie the first moda, i expect to see 1, if i select Moda from the fifth row, i expect to see 5 and i

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

*In F1 cell *- _*Non Array formula *_ *=LOOKUP(2,1/(A1:A8=D1),ROW(A1:A8))* OR *=SUMPRODUCT((MAX((A1:A8=D1)*ROW(A1:A8* On 10-01-2013 4:41 PM, Hilary Lomotey wrote: Hi Experts, In the attached, i have a list of items, some are repetitive in the list, if i want to find the relative positi

Re: $$Excel-Macros$$ Probability

Hi, I need mix of all the places with the kms derived from the data table for eg: Data is: A to B is 15 B to C is 2 C to D is 3 A to D is 20 I require: A to B 15 B to A 15 B to C 2 C to B 2 C to D 3 D to C 3 B to D 5 D to B 5 C to A 17 A to C 17 A to D 17 D to A 17 On Thu, Jan 10, 2013 at 4:40

$$Excel-Macros$$ Re: Finding the relative position of an item in a list

Hi Hilary, I hope this will may help you =MAX(SUM((A1:A8=D1)*1)) with CSE (: Regards Prince On Thursday, January 10, 2013 4:41:12 PM UTC+5:30, hilary lomotey wrote: > > Hi Experts, > > In the attached, i have a list of items, some are repetitive in the list, > if i want to find the relativ

Re: $$Excel-Macros$$ Finding the relative position of an item in a list *

Thanks Viper This is not what i require, i will try and explain again sorry if i didnt explain properly, your formula only produces the max ordinal position, assuming Moda is in the first , fifth and tenth row, and in the data validation drop down i select say Moda in the first row, i expect the

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

Ok Pankaj i can only reply in evening. regards Prince On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote: > > Don't use differnt mails. > > REgards, > Pankaj > > On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H > > > wrote: > >> Hi Prince, >> >> Its not working. >> >> Can you

$$Excel-Macros$$ Conditional format & formula

Dear Champs, i need one excel formula help tat with conditional format & formula. i tried if and if error but mistake but exact values are not received. plz any one help me please find the example sheet. need urgent any one plz help me. -- Regards, Shiva -- Join official Facebook page

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

I have not received any answer. Regards, Pankaj On Tue, Jan 8, 2013 at 7:56 PM, pankaj gmail account wrote: > Dear Prince and Lalit Thanks for response. > > what i wanted in a excel file:- > > Student ID Class SubjectMarks(Mandatory) > 123 V

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

Don't use differnt mails. REgards, Pankaj On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H wrote: > Hi Prince, > > Its not working. > > Can you send me example with this formula. > > Rgds, > Prabhakar > > On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote: > >> yes it is possible, pleas

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

=MAX(IF(A1:A8=D1,ROW(A1:A8),"")) with CSE On Thu, Jan 10, 2013 at 4:41 PM, Hilary Lomotey wrote: > Hi Experts, > > In the attached, i have a list of items, some are repetitive in the list, > if i want to find the relative position of each item what formula can be > helpful, the normal match will

$$Excel-Macros$$ Want to copy 2nd sheet of all workbook in a particular folder

Dear excel guru, I want to copy only the 2nd sheet of the all workbooks from a particular folder. Please accordingly rectify the below mentioned code which I also got this forum. Option Explicit   '32-bit API declarations DeclareFunction SHGetPathFromIDList Lib "shell32.dll" _Alias "SHGe

$$Excel-Macros$$ Finding the relative position of an item in a list

Hi Experts, In the attached, i have a list of items, some are repetitive in the list, if i want to find the relative position of each item what formula can be helpful, the normal match will for instance if an item appears twice in different positions will only give me the position of the first i

Re: $$Excel-Macros$$ Probability

Are you sure about the output you mentioned in attached file. or output will be Starting Place A Starting place B Starting place C Starting place D Starting place Ending Place A B A C A D B A B C B D B Ending Place C A C B C D C Ending Place D A D B D C D Ending Place Regards, Lalit Mohan O

Fwd: $$Excel-Macros$$ Probability

Hi, Can any one help on this -- Forwarded message -- From: Smitha S R Date: Thu, Jan 10, 2013 at 2:52 PM Subject: $$Excel-Macros$$ Probability To: excel-macros@googlegroups.com Hi, PFA the file which shows distance in KMS between different places. First Table 'Data' mentions t

$$Excel-Macros$$ Macros Cartograms

Hi Team, I need to write a macro on the attached template Cartogram where I can adjust a value and the size of countries in a map of the world changes (but their vague position stays the same)... Thanks a ton for the help! Sri -- Join official Facebook page of this forum @ https://www.faceb

$$Excel-Macros$$ Probability

Hi, PFA the file which shows distance in KMS between different places. First Table 'Data' mentions the kms from one place to another and total kms from starting place to ending place. Is it possible to get all probabilities of places in the second table with the kms derived from the first table

$$Excel-Macros$$ Re: Mandatory Cell Entry

Hi Prince, Its not working. Can you send me example with this formula. Rgds, Prabhakar On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote: > yes it is possible, pleas follow the following steps. > > 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow > section

$$Excel-Macros$$ Re: Please Help

Dear Karthik, your query is solvedpls check it. Thanks Ashish Kumar On Wednesday, January 9, 2013 8:07:11 PM UTC+5:30, karthik n wrote: > > Dear Help > > Please help for below attached file. > > > -- > > *Regards* > -- Join official Facebook page of this forum @ https://www.faceboo

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

Dear Kasper, You can also use below code for Ms. Excel All version (2003+) Sub Remove_Duplicates() With Sheet2 .Range("A1:A" & .Cells(Rows.Count, "A").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy, copytoRange:=.Range("C1"), unique:=True End With End Sub -- With Regards, Noorain Ansari h

Re: $$Excel-Macros$$ How to get max number from a database ?

With Array you can also use.. *=MAX(IF($A$4:$A$9567=A4,$B$4:$B$9567,""))* press ctrl+shift+Enter On Thu, Jan 10, 2013 at 12:17 PM, ravinder negi wrote: > you can use =DMAX(database,field,criteria) > > --- On *Thu, 1/10/13, Ms-Exl-Learner * wrote: > > > From: Ms-Exl-Learner > Subject: Re: $$Exce

Re: $$Excel-Macros$$ Need Help to seperate Date & time

Dear Senior, Thanks for your reply & support. I'll keep this in my mind for better future assistance. Thanks Ashish kumar On Thursday, January 10, 2013 1:03:01 PM UTC+5:30, Ms-Exl-Learner wrote: > > Please make it in an excel workbook and send it to us for our better > understanding of your

Re: $$Excel-Macros$$ Need Help to seperate Date & time

Dear Noorain Sir, Thanks for your valuable support. Thanks Ashish Kumar On Thursday, January 10, 2013 1:13:59 PM UTC+5:30, NOORAIN ANSARI wrote: > > Dear Ashish, > > You can try,, > > > For date > =date(year(a1),month(a1),day(a1) > and press ctrl+shift+# > > For time > =date(Hour(a1),minute(a1)