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 / New Users / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Need help with INDEX/MATCH formula07 Mar 2008 14:44 GMT3
I have two worksheets where the results are formula driven. The data
for the worksheets come from two different sources.
The result of worksheet A is the following:
FIJOL/AGNIESZKA    91009    50.00
excel07 Mar 2008 13:43 GMT1
excel
Formula for Exam Marksheet07 Mar 2008 12:26 GMT2
Hi to all,
If in ANY of these cells (F7,H7,J7,L7,N7,P7,R7,T7,V7,X7,Z7,AB7,AD7,AF7,AH7)
contains the letter T,P,W,Wn or TH (any of these), the result in cell AJ7
would be the letter X.
I need Excel Help07 Mar 2008 10:42 GMT1
I have another question about my project that I don't understand, if anyone
could help that would be awesome!
consultants who work on a project also receive a bonus if the fees exceed
estimates, otherwise the consultant received no bonus. Create one formula
#VALUE07 Mar 2008 10:10 GMT1
I have a simple spreadsheet for tracking an account balance.
Column X is withdrawals, Y is deposits and Z is balance. An entry in Z25
would be =Z24-X25+Y25
Since line 25 will contain either a withdrawal or a deposit, one of the
Excel Ribbon07 Mar 2008 09:46 GMT5
This might have been asked in the past but I can not find a post about it. My
question is why is it when you click a command on the ribbon; for instance:
-Page Layout
-Then put a check mark in Gridlines and Headings to print it takes a while
Sum coloured cells07 Mar 2008 08:00 GMT6
I have a small spreadsheet, say 52 rows X 7 columns (yes, it's a year)
Some cells are colour filled red, some blue etc., but are randomly
spread across the cells
I want a separate sum for all cells that have a red fill color, for
What is the best way to program the custom cell format07 Mar 2008 07:24 GMT2
I need to have a format of all the cells of selected row to be 8
characters and if the word of the cell is less than 8 characters,
then
padding with space. For example, if I enter "ABC" in one of the cells
not able to print from line a407 Mar 2008 06:41 GMT2
The following code ends in print preview starting line 7 and not line 4. any
suggestions please. I changed A7 to A4 in the with statement and still the
same problem.
Sub Picture22_Click()
#VALUE07 Mar 2008 04:57 GMT4
I have a simple spreadsheet in which three columns are used to keep track of
an account balance.
Column A is withdrawals, B is deposits, C is balance. A typical entry in C25
would be   =C24 - A25 + B25. One of the cells in A or B will be empty in row
IF Function Help07 Mar 2008 03:12 GMT2
I have a project that requires me to calculate bonuses for employees. I am
pretty sure that I need to use an IF function. Here is the question:
If the project fees do not exceed estimates the manager receives an 100
bonus. Algebraically, this is Bonus=(actual-projected)*bonus rate ...
Sorting in one tabs messes up formulas in another tab07 Mar 2008 02:38 GMT3
I'm not sure if this problem was solved before so sorry if this is a
repeat question. Let's say I have one spreadsheet tab that originally
has the following:
Col A Col B
Extract first names, middle names, last names and JR/SR07 Mar 2008 02:21 GMT8
I have formulas which will extract first, middle and last names but I
need one that will append the JR/SR/III onto the middle name.  What I
have now assumes it is the last name.
Thanks for your help.
Insert a blank row between each used row in document07 Mar 2008 01:28 GMT7
I need a macro to insert a blank row after each row in my document;
that is, every other row will be an inserted row.
For example:
I have:
Best approach for conditional formatting?07 Mar 2008 01:21 GMT4
I would like to make numbers within certain ranges show up in different
colors.  I'm very new to Excel, but have programmed scripts in Access and
know what an Access macro is - as well as the Access "conditional
formatting" feature.  What is the best approach to take in Excel?  ...
 
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.