Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / October 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Vlookup to transform columns to rows20 Oct 2007 21:36 GMT2
I have data, for example:
Empl No.         Emp First    Emp Last      Dependents     Dep1      Dep2    
 Dep3
98789991       John             Doe            Mary               Mary      
functions for if20 Oct 2007 21:34 GMT2
Hello I need your help again. I am working on a spreadsheet for recording
condensate return which is metered and read daily (almost daily). I want my
sheet to subtract the reading from today from the reading for yesterday. then
i'll have a totals cell. the problem is that ...
Exponential equations20 Oct 2007 20:16 GMT5
How do I enter and exponential equation in a cell?
Name Generator20 Oct 2007 18:04 GMT3
As a soon to be father we have a list of 1st and 2nd names.  I want to
create a spreadsheet where I bang in these two lists and it then shows all
the permutations with the surname.
What formula/s do I need to use for this, or better still can anyone point
Count Functions20 Oct 2007 17:04 GMT34
Hi Everyone i am looking for a formula that would let me count the number of
cells with a value between zero and 15? is there something that would work...
Thanks
warning box20 Oct 2007 15:31 GMT3
How can I have a message come up when  a cell breaks a record.
Example
if A4 is greater than 50 the say new record
Count occurences and return total20 Oct 2007 07:29 GMT2
HELP!  I know someone here can help me!  I want to count the number of times
a specific ID number occurs in a column, and return the total count in the
cell adjacent to each occurrence of that number:
ID #       Combined Count
TO Average Previous values20 Oct 2007 07:08 GMT7
I have 3 cols such that they look like this:
colA           colB         colC  colD
1931jfm     1931jan    1      mean of 1930(j,a,s,o,n,d)
1931amj    1931feb    2      mean of 1930(o,n,d),1931(j,f,m)
Excel 2003 "VLOOKUP" function20 Oct 2007 05:01 GMT4
Can anyone help me with using this feature.  I am trying to compare data in
one column to data in another and place a 1 in another column to sort by
later.  Thanks
Serial number generate20 Oct 2007 04:59 GMT4
I am writing a formula to generate a serial number automatically.  I use
“A1+1” in cell B1.  A1=0, then each record will increase.  But I can’t do any
sorting.  On the other hand, I don’t want to change the formula into a value
then I can do sorting.  Can anyone help please ...
How can I check whether a column of dates are all before today's d20 Oct 2007 04:50 GMT1
I'm working in Excel 2007.
I've got a column of dates, and I need to check the column as a whole to
ensure that every date is prior to today's date.
E.g. if today's date is 10/19/2007, and my column is the following:
grouping help!!!!!!!20 Oct 2007 04:16 GMT1
is there a function called collate to help group stuffs from different cells?
my boss told me collate items. but i didnt know what exactly she meant.
i dont even know if it s called collate.
negative numbers20 Oct 2007 02:48 GMT1
How do I get a negative number to appear in red with a minus sign instead of
brackets or a minus sign in black?
find cell with matching text, then reference cell in same row20 Oct 2007 01:05 GMT2
I have a main sheet and many additional sheets with peoples
names' (each sheet is named for a person - including a command and
space).  The main sheet is named 'Master Inventory'
On the main sheet, there is a row for each person.  Column A has the
Type a cost code in one cell and discription in an other20 Oct 2007 00:25 GMT4
I would like a formula that will let me place a number in one cell (its a
cost Code) then the next cell to show the discription of the cost code
selected. I have it working using "if" but i have the problem of the dreaded
"Seven" is there any way that i can increase the seven. ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.