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 / May 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Conditional formatting of entire workbook20 May 2008 03:00 GMT3
I have a workbook that has separate sheets for each day of the school year
and wanted to see if I can conditionally format the whole workbook  at once
instead of having to do one page then copy.  Right now I have one that is
live data and I am creating another version for next ...
pivot tables - add columns20 May 2008 02:17 GMT1
I would like to add columns to see the info by different ways without
changing the field configuration. Is it possible.
Can Excel warn me if a cell already contains entered information?20 May 2008 01:21 GMT2
I'm using Excel to keep track of orders - each with a separate number. These
numbers are all in the same column. Can Excel warn me if another cell in the
same column already contains the information I'm trying to put in? Order
numbers consist of only four numbers, if it matters.
Search for duplicates across three worksheets20 May 2008 00:29 GMT1
I need help with this one. I have one excel file with three worksheets. I
want to compare the data in column A in each worksheet and if a value exists
in more than one sheet I'd like to highlight the cell in each sheet it
exists. Or I guess another way to put it is I want to ...
Concatenation19 May 2008 23:27 GMT2
How do I use the concatenate function to merge data from separate cells?
appreciate it very much if somebody could explain with  a simple example.
Is it possible to dedupe two excel lists?19 May 2008 22:21 GMT1
I have two excel spreadsheets with overlapping data and would like to dedupe
them, seperating the unique from the duplicate data.
Does anyone know how I could accomplish this?
TIA,
HELP19 May 2008 22:17 GMT3
I have a date that I would like to add 28 working days to.  I don't want to
include the weekend days in the calculations.  So May 19, 2008 plus 28
working days would be ????  I need a formula for my worksheet.  Can you help.
How do I enter the formula to show the current day of the week ?19 May 2008 22:17 GMT4
I want to show the current date ..ie =(today) but in a column next to it I
want to show the day of the week.   What is the formula ?
Formulas and counting19 May 2008 21:27 GMT9
II need to have a formula that will search through one column in a specific
range (check Sheet1!C:C for a date range) if it is within that range then
check Sheet1!E:E for a specific value if it is that value increment this cell
by one. Is that possible in excel? I tried and if ...
Can I create a button for a formula?19 May 2008 21:12 GMT1
I have a formula that I use several times a day in various workbooks.  The
formula is always =(I2&" "&J2) written in Cell K2.  I created a macro, but it
keeps tying to the workbook.  I want to create a button that will automaticly
type this formula no matter the workbook I'm in.  ...
Match 3 columns to one cell19 May 2008 20:57 GMT5
I have 9-digit account number in the first 3 columns (from A4:C65002) that I
am trying to verify if the number that I have in range D4:d54.  I am trying
to use the match function to perform this, but apparently the match function
will NOT match between 3 columns only one column.
Indentify Shift number in 24 hour period19 May 2008 20:46 GMT5
Hi all, I am trying to find a way to identify the shift of a particular time
without the date.  For example the shifts start at these times:
1  22:30
2  06:00
Excel - Formula/Programming19 May 2008 20:08 GMT1
I have a list that is sorted by a date and a true/false cell. I would like
to have these columns moved to a new sheet (which would be labeled "old")
based on the date and the value of the true/false cell being "true". For
example, if a column's row cell date is 1/8/05 and another ...
Condtional formatting on 2 separate dates19 May 2008 20:03 GMT2
I have a spread sheet that conatins hire dates in one column (A) and
termination dates in a separate column (AU). I want it to highilght the date
in column A if there is a termination date in column AU. Or even highlight
the name of the employee in column F if there is a ...
creating a combo box that shows multiple entries.19 May 2008 19:27 GMT1
I have an address list in one worksheet. I have a form in another worksheet
where I want to place a combo box that will allow me to select the person's
name and then fill in all the other columns with their address, phone number,
city, state, etc, on the form. Another vaariation ...
 
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.