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 / General Excel Questions / November 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Lookup Help19 Nov 2007 01:30 GMT2
I am trying to look up UPC values in column B.  If a UPC listed in Column B
is also listed anywhere in Column C, then I want to return 'Yes" in column D.
If not I want to return 'no".   I am sure this is simple, but I can't figure
it out from Lookup help.  Thanks!
VLOOKUP19 Nov 2007 01:25 GMT2
I am making a billing system which will pick product prices automatically
from a price list of products.  My prices should change automatically
according to latest price. I have products like this
column A        column B               column C
Pivot Table exclude negative values from sum19 Nov 2007 01:23 GMT2
Using Excel 2007:  
I am using a pivot table to sum staff by department.  Some departments have
positions shown as a negative (indicates they belong to a different
department/budget).  When I include the FTE column in my pivot table to
mouse trouble in excel19 Nov 2007 00:51 GMT4
I use excel 2003 at work and when I try to right click on a cell to get the
copy paste menu nothing happens in any cell. I checked it in work and it
works fine as well as in diffrent programs we use. It only fails to work in
excel is there a option that has been disabled?
Protection - Allow Group/Ungroup but lock / unlock some cells18 Nov 2007 22:31 GMT2
I have a spreadsheet which allows people to enter some figures in some cells.
Those cells then add together to creat bew totals.
I want to allow them to see all the individual lines or allow them to use
the group +or - (the rows have already been grouped) to change the views.
Random Number Generation at Interval18 Nov 2007 22:18 GMT1
I could use some help with gernating a random number (between 50~75) in cell
A1 at set time intervals (in seconds).  The value of the interval would be
entered in B1 with a command button for "start number generation" and "stop
number generation"
How To Anchor Chart Data18 Nov 2007 21:47 GMT2
I am using this code to add/paste data from another sheet(1) in to column K
on sheet2 at 1 minute inertvals.  This macro works fine and when it runs it
emulates a stream of data (1 min appart) which places the most current value
in colum K and the value streams to the right with ...
Value searching in columns - vlookup can not do it?18 Nov 2007 19:32 GMT4
This may not be an easy one to follow, so if you need more information please
let me know!
I have two columns of original data which are linked. Column A is time and B
is acceleration at each time in A.  From these two columns of data I need to
COUNTIF limitations, alternatives?18 Nov 2007 19:20 GMT5
I'm entering the results of a survey into Excel.  The answer to one of the
questions was a number from 1-6.  I entered all the data, then used COUNTIF
to tell me how many respondents entered 1, how many 2, how many 3, etc.
Now I'm getting the next survey coming back, almost the ...
progressive sum18 Nov 2007 18:12 GMT3
dear sir,
i want the progressive sum of cell values in one column like this
column "a" , "a1"=10,"a2"=15,"a3"=20,"a4"=30 and i want the progressive sum
of column A in column B like this
SWITCH NUMBER BY LETTERS18 Nov 2007 17:43 GMT3
i would like to change in excel program  number by letters for example:
1245  = mil doscientos cuarenta y cinco
vlookup - matching where codes are not exact18 Nov 2007 17:12 GMT2
I need to match product codes from multiple spreadsheets and am using
vlookup. Have been succesful up to now but have now hit a point where the
data is not clean. So a product code on sheet 1 = abc1xyz whilst on sheet 2
the same product = abc1(xyz).
numbers rounding18 Nov 2007 17:00 GMT1
been using excell to track orders. i recently upgraded from office 2000 to
2007.
all of a sudden when i type in a number like 250, it shows as 3 on the
spreadsheet.
Why Cos(45) is not equal 1/Sqrt(2)?18 Nov 2007 16:35 GMT2
Does anyone have any suggestions how to use Cos function in Excel?
When I type =cos(45) in cell A1, it returns 0.525322 which is not 1/Sqrt(2).
Does anyone have any suggestions on how to use Cos?
Thanks in advance for any suggestions
French format18 Nov 2007 16:25 GMT3
I have the need to have 2 cells side-by-side (one in English and the other
in French).  In the English one, I have =Text('variables'!$B$33,"dddd mmm dd,
yyyy") which results in the value 'Saturday, September 01, 2007' being
returned.
 
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.