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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
duplicate name help please20 Feb 2008 15:52 GMT9
Hello group
I have a spreadsheet that calculates the players Position, Total score,
Played games, and Number of wins, from a MAIN sheet.
     Positions Names Total Scores Played Wins
Restricted Cells20 Feb 2008 15:44 GMT1
I have a spreadsheet with the following characters - some columns are
inaccessible for input, some cells are protected, there is a section of
the spreadsheet that I can't even click the mouse it jumps to the next
available cell. Some columns have a weired color - Pink!. Basically it
Disallow cell data entry which autopopulates20 Feb 2008 15:34 GMT4
I have a macro which autopopulates a date/time stamp (lets say,cell B1)
when a selection is chosen in (A1). This time stamp can be changed and
I don't want anyone to be able to change it. I want to make the cell
where the user can click the cell, but when they try to type, nothing
excel formulas20 Feb 2008 15:01 GMT19
How would I do the following:
A+B = C,
if C = 10 then D = 1
if C = 11 then D = 2
If statements20 Feb 2008 13:18 GMT1
I am trying to insert a result of an if statement into a column that has some
blank spaces but also has some correct values the same column. I want to
build a Macro that would include this statement. How do keep from overwriting
the cells that have the appropriate values when I ...
Lookup a criteria from another sheet20 Feb 2008 11:48 GMT1
Good Day
I what to lookup a crieria in col A and it gives me what is in col B.
Col A                                    Col B
Repair & Maintenance            13,500.00
copy of certain rows20 Feb 2008 04:53 GMT2
I have a matrix (16071 * 40), and i want copy or cut rows 3 to 43 and 367 to
408 and to the end to another worksheet.
Any help will be greatly appreciated.
regards.
Logical Test20 Feb 2008 03:26 GMT5
If cell B40 contains a formula to AVERAGE the adjacent cells (B1:B38),
however, this range of cells are empty, then my result in cell B40 equals
#DIV/0!
Now, on the next worksheet, I would like cell C50 to reference B40, however,
How do I combine If and AND Formula20 Feb 2008 03:06 GMT5
I want to use a IF Formula but need to combine it with an AND Formula as I am
trying to check if the value of a cell is between two values...in my case If
cell is between 12 and 24 show "X".
I came so far as =If(A1>=12;"X";"") so now I need to get it also to check if
automatic sorting20 Feb 2008 00:59 GMT4
I have many columns of corresponding data, i was wondering if there was a way
to not only sort one column but have the coresponding data in other columns
sort with it.  I need an automatic sort beacause the data is to be refreshed
frequently and the actual sort a list comand is ...
finding multiple non-zero values in a column19 Feb 2008 23:21 GMT2
I have a sales list for a customer and I need to find all of the items they
are getting via the column that shows "amount of units". Then I need to put
that number as well as the item name that corresponds to each amount in a new
sheet for project managers. The array looks like this ...
Text to Date function19 Feb 2008 22:44 GMT3
I have a row of Text
20071020
20070814
could anyone help me, these are supposed to be dates but have been put in as
Lookup discontinued Lines19 Feb 2008 22:27 GMT1
Hope you can help
I have a spreadsheet with data that i want to lookup the discontinued
lines i have and have a text string say Delete
The discontinued lines are set up in an Array.
Formula Assistance19 Feb 2008 22:25 GMT1
We have two large spreadsheets and both contain a common SS field. I need to
combine both sheets by the ss field. They don't have uniform formatting  or
columns throughout. I have tried a Pivot Table and vlookup to no avail. HELP!
Return Last 10 rows in reverse row order.19 Feb 2008 21:23 GMT9
I have an 8 column by many rows, dynamic named range called "Data". The named
range starts in row 2, column "C". The oldest data is at the top, row 2 and
the most recent data is at the bottom of the named range. "Data" holds
numeric values.
 
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.