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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Count function23 Jul 2007 23:59 GMT5
I need some help. In worksheet I've column (one) with short strings. I
need to known how much times every of them repeats oneself. Somebody can
tell me is exists function which  it will make this.
Thanks
select and extract rows of data to new excel worksheet23 Jul 2007 23:03 GMT1
I have a large pricelist.  Want to estract all items containing certain word
in description like "wood" to a new sheet.  This must be the entire row of
information as it is part number, description, cost and quantity etc.
SUMIF & COUNTIF based on dates23 Jul 2007 22:36 GMT10
I got formulas' 1 & 2 from this NG and tried to make come up with the
formula I needed from samples posted in this NG but I was not able to.
Please help.
Columns: G=Amount, I=Date Posted and J=Date Sent
Another Conditional Formatting Formula needed?23 Jul 2007 22:34 GMT6
In Column A I have a list of last names (A4:A3500), and in Column P I have a
list of companies (P4:P3500). I'd like to use conditional formatting to
change the color of the last name in Column A (A4:A3500) to blue, when a
specific company name appears in Column P (P4:P3500). I'll ...
Time to time range formula???23 Jul 2007 22:34 GMT11
=TEXT(INT(C2*24)/24,"hh:mm") & "-" & TEXT(INT(C2*24+1)/24,"hh:mm")
is the formula I'm using.  In my spreadsheet, column C lists the time the
patient was discharged.  I was given the formula above last year from a
poster on an Excel website.  I was looking at it today and I don't ...
Run Macro for all worksheets23 Jul 2007 22:27 GMT2
I have many worksheets and I have a macro that I want to run for each
worksheet. Is there any way I could save my fingers some pain instead of
going throw all worksheets and run the macro could run the macro for all
worksheets at once.
cell height23 Jul 2007 22:03 GMT2
I am writing a lot of data in a cell and i am unable to see the whole of it
in the sheet. I can not view the last of the lines. I can only see all of it
if i click on the cell and then the data is visible in the formula bar. Is
there anyway around it, i have tried formatting the ...
jobs23 Jul 2007 22:02 GMT2
1ST JOB - DAIRY QUEEN :  POSITION-CASHIER            DUTIES (TAKING OUT
TRASH, SWEEPING, MOPING, MAKING ICE CREAM PRODUCTS....)
YEARS WORKED THERE - 3/'96-11/'96
LOCATION - 141 BISCAYNE BLVD.    MANAGER - CHRIS
Canadian Postal Code format?23 Jul 2007 21:57 GMT9
I would like to type is our Canadian Postal Code and have a special format
that forces the right entry. Our Postal Code consists of
3 characcters a space and 3 more character. Ie "S0L 1G9".
It is always a "UPPERCASE LETTER, number, UPPERCASE LETTER, space, number,
How to add (sum) specific cells23 Jul 2007 21:36 GMT2
If i have a colum E1:E20 with a specific letter in each cell like A,B,C and
colum F,H,J with specific numbers, how can i ADD values that lies with A only
and B only and C only?
thank u...
Make #N/A blank if no value is returned23 Jul 2007 21:24 GMT11
Using VLOOKUP some of my values are #N/A. The formula I am using is:
=VLOOKUP(1,$X$10:$Z$17,3,FALSE)
If the value returned is #N/A how can I make it display blank or null?
IF STATEMENT HELP CHOOSE AND GET COST23 Jul 2007 21:06 GMT7
I have a Dependent Validation data that I need it to complete this statement
IF D2=LOCAL,TECH,FACTORY,OR WEB (TYPES OF CLASSES) IS CHOOSEN
E2=THE INDIVIDUAL TYPE OF CLASS IS AVAILABLE CHOOSE
AND WHEN THE CLASS IS CHOOSEN:
Looking up multiple results with VLOOKUP23 Jul 2007 20:18 GMT7
Is it possible to have VLOOKUP return multiple results?  (I suspect the
answer is "No").  My "lookup table" consists of project numbers in column A
and supported systems in column B (the project number is repeated in each row
for which there is a different supported system).
Help understanding what a formula does and why it's 'faulting'23 Jul 2007 18:17 GMT13
With some help I got a formula that works, but only after a fashion
Here was my original question:
Return last 6 results formula
I have a column in my sheet that fills in progressively over a season
What do you call values used with a functions?23 Jul 2007 18:07 GMT3
Working on excel crossword at work and this one of the questions...the answer
is nine letters...hope someone can help.
 
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.