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!

  • Congratulations Wanet Telecoms Ltd 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: kapzlok
  • Content: Threads
  • Order by date
  1. kapzlok

    Random Cell Values in Excel

    I was wondering if there is a particular function that can randomize a list of values in a column in Excel? I know that this may be accomplished by generating random numbers in a column next to the column with the desired values and then sorting the column, however, I am looking for simple way...
  2. kapzlok

    Date Cleanup Function

    I am trying locate a function to cleanup dates in an excel spreadsheet so that all of the dates are in the following format: mm/dd/yyyy Currently the formats vary, here are some examples: 1/1/97 01/04/92 3/12/1999 I wanted them to look like the following: 01/01/1997 01/04/1992 03/12/1999
  3. kapzlok

    Current Age

    I have a column with a person's date of birth listed. I was wondering if there is some function that I could use which would return the person's current age based on his/her birthdate and the current date, which would update for each day?
  4. kapzlok

    DCOUNT Issue

    I am trying finish an access database that I started for the lab I work in where I want to store subject and study information. I am almost done with the database, I'm just trying to add little features that my boss wants. Currently I'm stuck on a DCOUNT issue where I am trying to count the...
  5. kapzlok

    Count Function

    I want to write a function for a basic textbox in a form to display the amount of time a particular study appears in a table. I know I need the count function and an if statement but for some reason I get an error message when I try the following...

Part and Inventory Search

Back
Top