Say I have a list that looks like the following:
boy
dog
cat
hat
small
it
lady
run
shout
and I want to randomize the order in which they appear so that a randomized list might look like the following:
lady
shout
boy
it
small
run
dog
hat
cat
Currently, I fill the column to the right of the...
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...
Thanks for your help. I ended up just using this simple code in the form itself and it seems to do the trick:
=DateDiff("yyyy",[DOB],Date())+(Date()<DateSerial(Year(Date()),Month([DOB]),Day([DOB])))
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...
from the ACCESS 97 Help File
Syntax
DCount(expr, domain[, criteria])
The DCount function has the following arguments.
Argument Description
expr: An expression that identifies the field for which you want to count records. It can be a string expression identifying a field in a table or...
I tried this first and then changed it to the second and still the same error message, I'm sure I'm entering the expression incorrectly, but I didnt find much help for dcount from Microsoft.
=DCount("[subject_study","study_name","study_name = 'Stroke'")...
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.