Search results for query: *

Hi JTBorton, Thanks a lot for your help and spending time for converting code in to VBA , much appreciated. Regards,

OK... VSS : Visual Sourse Safe.. Come with MS Visual Studios installation.. I have used this for source controlling Visual Basic apps... CVS : The Concurrent Versions System (CVS), also known as the Concurrent Versioning System, is a free software revision control system in the field of...

Thanks a lot!!

Hi Gruuuu , Thanks for the response!! Sorry I was not clear in my question? I am not refering to Excel Version.. I am refering to Coding version control... VSS , CVS, etc... Hi Skip : Hope I have clarified your quetion. Regards,

Hi Guys, Not sure if this is the right place to ask this question... What are design patterns in Excel? Is this general term given to Software engineering or are there any specific design patterns? Regards

Hi Guys , Just wondering what is the best way for version controlling Excel ? Getting lots of version conflicts... Will it be good idea to version control each and every modules or entire excel sheet. Any ideas, pointers would be really great help. Regards,

JTBorton / strongm thanks for the response!! yes Big O notations reminds me one of the tech interview which I had attended sometime back.. I that I was asked about the fastest algorithm for searching and sorting.. and I had blindly told them heap sort and was not sure about the searching...

JTBorton , Thanks a lot for the useful link sent.. I managed to write a logic for sorting with the help of our experts here.. do u think heapsort algorithm can be used to sort alphanumerics? If you could post ur converted code that would be great. Also, what would be the iterations / time...

thanks a lot for ur help!! Just that I had some bad experiences with V & H lookups and also the rows and colms are not fiexd and can change dynamically, hence I wanted not to use lookups.

Guess, I have managed to solve this by using Index, Match.... =INDEX($J$14:$P$14,MATCH("Package",$J$14:$P$14,0),MATCH("Associate",$K$7:$P$7,0)) Please let me know if you feel there might be better solution. Thanks a lot for all your help!!

Hi Skip, Trying to understanding logic here for sorting... =DATE(IF(ISNUMBER(B2),B2,IF(B2="Year",A2+YEAR(NOW()),0)+1900),IF(B2="Month",A2+1,IF(NOT(ISNA(MATCH(A2,Mons,0))),MATCH(A2,Mons,0),1)),IF(B2="Day",A2,0)+1)0 B2 assuming this is Date range to be sorted (i,e 1 Day), in which case this is...

Cool!! Thanks a lot... Let me try this in VBA , will give u an update once I am done. Regards, Kuldeep [hourglass]

Thanks!! I have modified excel to clarify all questions. Please check the attached sample1.xls in which col D is static and col E is expected output with col inputs are J7:P7 and J14:P14. http://www.mediafire.com/file/d3ytdmaam1v/SAMPLE1.xls thanks a lot for ur time again!!

Gavin, Ok, 1 Day could be from today (T) , 2 Day ( T+1), 3 Day (T+3),... etc... Similarly we can may have 1 Month ( T+Month) , 2 Month ( T+ Month) and so on.... Also, same can be future points rolling every three months... Mar10, Jun10, Sep10, Dec10, Mar11, Jun11, Sep11, so on...

Hi, Thanks for the response!! To make it more generic , I am trying lookign for solution without using Vlookup or Hlookups. Please check the sample file , apologies , guess I am not clear in my requirement. http://www.mediafire.com/file/d3ytdmaam1v/SAMPLE1.xls Regards...

Please check below function , I am passing Array1 as Range. Public Function Asort(rng As Range) As Range On Error GoTo ErrHandler Dim aArray Dim R As Range Dim iVal3 Dim icount As Long Dim iTemCount As Long Dim iArrCount As Long iArrCount = rng.Count...

HI Skip, No column names dosent change however , rows can no can change, hence I am looking for solution without using Hlookups. Regards, Kuldeps.

Hi Skip, Thanks for the reply, tried with dates function, however not been able to display them in sorted order as 1 D, 2 D, Mar 10, etc... Regards, Kuldeps

Hello All, Just wondering if you can help me in writing VBA sorting logic for Date in asc or dsc order. Want to sort dates which are not in simple date format (DD/MMM/YYY). Want to sort dates from Array1 below resulting Results_Array1 Array1 Result_Array1 100 Year...

HI All, I am have been a excel VBA programmer from last couple of years, but not an expert in excel formulae. Thought of taking your expert help!! My question : I have a situation where I have to lookup the field say emp grade in a column match it against list of grades from another range...