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 / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Data Consolidation w/ Multiple List Boxes02 Apr 2007 19:44 GMT2
I am needing help - after days of searching the discussions and trying a few
suggestions, I cannot seem to find an answer to my issue.
I have timecards of 10 people with a timecard for each month (each on a
seperate worksheet).  Each timecard starts with 5 columns which include ...
Need help in forcing number that wants to stay in Sci. Notation fo02 Apr 2007 19:32 GMT6
I have received an excel file from a client that is giving me fits.  The
issue at hand is my inablility to convert a formatted column from number to
text, without it reverting back to scientific notation.
What is happening is that the column shows a numeric value, such as
tab color change02 Apr 2007 19:24 GMT4
I have a workbook with several sheets inside of it.  I would like for the tab
color to automatically change color is a condition is met.  For example if on
the sheet a cell has a drop down list and by choosing one of the selections
from the drop down menu would automatically ...
Summary sheet with Vlookup02 Apr 2007 19:18 GMT2
I have looked on threads for summary sheet, with or without VBA, however, my
sheets in the work book are all the same format, except that the names in
column A are not always in the same order. and therefore using the same cell
on each sheet is not an option
How do I edit a cell in Excel without clicking on the cell first?02 Apr 2007 19:15 GMT5
I cannot find the shortcut keys
Change Cell Value from another Cell02 Apr 2007 19:13 GMT1
Can we change cell B3's value from a condition in say cell A3. I cannot use =
in B3.
Signature

Ponnath

Convert Time to a Text02 Apr 2007 18:56 GMT3
I need help with a formula.  I'm trying to convert a time to text as in the
example below.
Example:
A1= 5:16 PM
sum values in cell based on another cell02 Apr 2007 16:55 GMT2
I tried to find a solution by searching posts, but had no luck understanding
them. Here is sample table and then my question:
A          B            C              D
0          1            1              Tuesday
how do I show 1st, 2nd, and 3rd most repeated non-numeric values?02 Apr 2007 16:08 GMT2
I have several categories that are repeated numerous times.  For example,
most eaten fruit in the cafeteria...  apples, oranges, bananas...
I want to put in a formula that will count how many times each fruit is
repeated in the data, and if apple is top repeat, show apple in the ...
NUMBERING ROWS02 Apr 2007 15:48 GMT2
hi, i am trying to give the rows a number in a designated column that when 1
is entered and i drag down the rows the numbers following will automatically
change in order eg 1.2.3.4.5.6.7.8.9. etc
any help willbe brilliant
Rank excluding Errors02 Apr 2007 15:46 GMT3
I've searched for a solution here, but I'm not able to find any.
My formulas:
=RANK(C12;IF(ISNUMBER(C$7:C$55);C$7:C$55;"");0)
or
How can I apply a formula to all cells even those with < signs?02 Apr 2007 15:43 GMT5
I have a huge worksheet (about 741 lines) and almost all figures in the cells
need to be changed from parts per billion to parts per million.  Is there an
easy way to change this?  Some cells have < signs in them.  I would really
appreciate help with the formula and applying to ...
Conditional Formatting based on Text02 Apr 2007 15:42 GMT2
I have two questions:
1) I have two columns one is 'purpose for gift' and one is 'gift amount',
I've subtotaled these using excel - and would like to automatically format
the gift amount to be bold for each subtotalled line.  I thought I could use
Using Data from Drop Down Menus in Sum Formulas02 Apr 2007 14:26 GMT3
Hi there,
I'd like to set up a spreadsheet with numerical drop down menus, the
selected values of which can then be taken and added together using the sum
function. I've tried adding in a drop down using the forms tool bar but sum
Excel spreadsheet formula02 Apr 2007 14:03 GMT2
Is there a formula to add 90 days to a date. (i.e what is 90 days from
01/20/07)
 
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.