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...
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
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.