Hi Everyone,

I use excel 2000 and 2003. I am working on learning to use excel to filter
out data etc. Anybody have a method to organize the
formulas/functions/expressions that one frequently uses? Since I am just
getting started with this stuff I can't really come up with the formulas on
my own yet so I need the "template" for future use....For example.

The 2 expressions below did the same thing on my excel sheet and I will no
doubt use them again for another project.

=TEXT(B3,"mm/dd/yyyy")=TEXT(D3,"mm/dd/yyyy")


=int(c3)=int(d3)
(=int() will take the whole number (the date) and ignore the fraction (the
time).)


Thanks,
Linda

Copy and stick in NotePad with an explanation of what they do.

If you have a Personal.xls you could put them on a sheet as text with a
description so they would be available whenever Excel was running.


Gord Dibben MS Excel MVP

On Fri, 6 Nov 2009 09:48:07 -0500, "Linda RQ"
wrote:

Hi Everyone,

I use excel 2000 and 2003. I am working on learning to use excel to filter
out data etc. Anybody have a method to organize the
formulas/functions/expressions that one frequently uses? Since I am just
getting started with this stuff I can't really come up with the formulas on
my own yet so I need the "template" for future use....For example.

The 2 expressions below did the same thing on my excel sheet and I will no
doubt use them again for another project.

=TEXT(B3,"mm/dd/yyyy")=TEXT(D3,"mm/dd/yyyy")


=int(c3)=int(d3)
(=int() will take the whole number (the date) and ignore the fraction (the
time).)


Thanks,
Linda