Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kuldeps
  • Order by date
  1. kuldeps

    Sorting of Date!!

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

    Excel Version Control!!

    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...
  3. kuldeps

    Design Patterns!!

    Thanks a lot!!
  4. kuldeps

    Excel Version Control!!

    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,
  5. kuldeps

    Design Patterns!!

    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
  6. kuldeps

    Excel Version Control!!

    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,
  7. kuldeps

    Sorting of Date!!

    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...
  8. kuldeps

    Sorting of Date!!

    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...
  9. kuldeps

    Trying to find of HLookup alternative formula.

    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.
  10. kuldeps

    Trying to find of HLookup alternative formula.

    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!!
  11. kuldeps

    Sorting of Date!!

    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...
  12. kuldeps

    Sorting of Date!!

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

    Trying to find of HLookup alternative formula.

    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!!
  14. kuldeps

    Sorting of Date!!

    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...
  15. kuldeps

    Trying to find of HLookup alternative formula.

    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...
  16. kuldeps

    Sorting of Date!!

    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...
  17. kuldeps

    Trying to find of HLookup alternative formula.

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

    Sorting of Date!!

    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
  19. kuldeps

    Sorting of Date!!

    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...
  20. kuldeps

    Trying to find of HLookup alternative formula.

    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...

Part and Inventory Search

Back
Top