|
replace a word with another word through out workbook
I am creating a workbook with multiple pages. I would like to type a company
name on the first page and have it placed in the middle of sentences through
out the work book....
|
4 |
12/8/2008 11:25:30 PM |
|
|
Search For Common Text in Column
I am trying to search for specific words in column A and then print an
abbrviated version of those specific words in Column B. There is a set of 7
words that I want to search for and if one is found i want to print the
abbreviated word if not I want to move to the next word I am searching for.
I have been trying to use the If, Lookup and search functions. I have not
been successful. Ex...
|
12 |
12/8/2008 10:44:47 PM |
|
|
Function usage and outcome clarification
I am attempting to derive a number (cost) if eihter of the two adjacent
column cells have whole numbers. The cost factor is a constant 11. So I
tried forcing the IF funcion then a combination of IF and OR but once I
suspect I got the formatting correct all I could get were alpha characters in
the cost column. Would someone please direct me how to get the numeric
number in the cost col...
|
15 |
12/8/2008 10:06:06 PM |
|
|
I do not want the minus sign
Hello from Steved
the below gives me -520671 please what is reqiure for it to display 520671
=SUM(F63:F66)-F67
Thankyou....
|
6 |
12/8/2008 9:26:00 PM |
|
|
convert figures into words on Microsft Excel
Hi,
I am a newbie to Excel. I've been trying to convert figures into
words on Microsft Excel. While browsing i got the code below from
Microsoft. But the problem is that it converts Numbers into Dollars
and Cents. I just want it to convert it to words, i.e, 456 = Four
hundred and fifty-six...
Please edit the codes below so that i get the desired result...
Thanks
Option Explicit
'...
|
4 |
12/8/2008 9:06:25 PM |
|
|
How to total words
I have a spreadsheet with two columns like below.
I'd like to get a total of column B. For instance, Apple=4, Mango=2,
Pineapple=1/
Is this possible?
Orchard Fruit
A Apple
A Mango
B Apple
B Mango
C Pineapple
D Apple
E Apple
...
|
3 |
12/8/2008 9:00:32 PM |
|
|
Lining up rows based on values
Hi all,
I have 3 types of data in my spreadsheet. Species code, taxon, and
average. Each of these data are spead out into 5 groups corresponding
to their survey number. So, I have 20 columns of data (species,
taxon, mean, survey) lined up next to one another. I would like them
to match up by species, but not every survey found each species found
in other surveys. FOr instance, suveys 1...
|
2 |
12/8/2008 8:55:03 PM |
|
|
Can Excel recognize gender?
I am putting together a spreadsheet that already has a persons first and last
name and I have to go through and write everyones courtesy title and there
are over 500 names. My question is, Is there some kind of function or
formula that can auto populate each one of their courtesy title by telling if
its man or woman? That would really save me some time. Thanks.
--
RebeccaW...
|
5 |
12/8/2008 8:52:06 PM |
|
|
Need Conditional Formating help.
I have a row in a worksheet that contains a text description of items being
purchased. What i want to do is Format all rows that contain a * to be in
italics.
I don't know how to word it, but i want this condition:
if cell value contains a * i want the cell to be in Italics.
i.e. if cell says "interior wall mount *" i want it to read the same but in
italics.
--
Jon Robershaw...
|
3 |
12/8/2008 7:50:57 PM |
|
|
=max between one hour and second hour
> In Out Hours
> > 16:00 18:30 02:30
> > 08:55 15:00 06:05
> > 12:00 21:00 09:00
> > 10:00 16:00 06:00
> > 08:45 16:35 07:50
> > 08:00 20:30 12:30
> >
I have a hourlist like this, the hours are in format hh:mm, what I hope to
manage is..
lets call the columns
> > A B C D E
> > IN...
|
4 |
12/8/2008 7:44:15 PM |
|
|
Excel Count Functions
I am trying to count the number of cells in a row that contain one or more of
three letters?...
|
21 |
12/8/2008 7:42:29 PM |
|
|
Rows to columns with multiple sets
Hi -
I have a file of data that I need to flip rows and columns, however, there
are multiple sets of data so the "paste special>>transpose" doesn't meet my
need. So, for example, my current data file looks something like this:
A B
City Ozark
State MO
ZIP 65721
City Kansas City
State MO
ZIP 64118
City Suffolk
State VA
ZIP...
|
2 |
12/8/2008 7:35:02 PM |
|
|
Pivot tables - Refresh issues
I have 2 separate pivot tables (separate worksheets) within a file - both
using same data source. For some reason I now have an issue that when I
refresh one table, it refreshes the other at the same time (whether or not I
have them relying on each other re data source). Is there a way to ensure
only one table refreshes at a time? (using right click/refresh button to
refresh)....
|
2 |
12/8/2008 7:25:25 PM |
|
|
MATCH INDEX formula required.
Hi
Any help with this sould be great. I use to be able to nail this stuff, but
too long working with VBA has screwed my mind.
I have 3 columns of data (D4:F6000) that forms my table. There are loads of
repetetive data though no row of 3 cells holds the same info.
In cell G4 I enter the values say from D5
In cell H4 I enter the values say from E5
In cell I4 I need a formaula that wil...
|
4 |
12/8/2008 7:25:02 PM |
|
|
Calculating overdue date fields
I have a column with dates that I'd like to use a count formula where it
counts the total number of rows that are past a certain date. How
can I write the formula to calculate this count? Below is an example of what
I mean. A1 is the cell for the date criteria that will determine how many
dates are past due in column B. Column B will have mixture of date and text.
The count should include...
|
4 |
12/8/2008 7:24:05 PM |
|
|
list of bi-weekly paydates for 2009 beginning 1/8/09
List of biweekly payperiods that start on Monday 12/22/08, Pay Period ends
Sunday 1/4/09 and paycheck date is Thursday 1/8/09. For formula in excel to
do this automatically for 2009 and I won't have to do it manually....
|
3 |
12/8/2008 7:22:01 PM |
|
|
creating a master file
i have 12 files, jan, feb, mar ............., dec. Each file is contains the
same format. Data is entered in each file monthly.
I want to creat a master file which should contain the links or fomulas to
show all the numbers of 12 files. ...
|
2 |
12/8/2008 7:11:02 PM |
|
|
Conditional Formatting
I am very unfamiliar with Excel so please forgive me for any incorrect
information, I'll do my best. I have a workbook with 15 worksheets. The first
worksheet has a list of 600 names (summary page). Each of those names will be
duplicated in the other worksheets at another time. Here is what I want to
happen:
When a name from worksheet1 has be entered into worksheets 2 - 15, I would
li...
|
2 |
12/8/2008 6:43:03 PM |
|
|
gridlines don't print
i HAVE VISTA AND EXCEL 2007. mY SPREADHEET WON'T PRINT GRIDLINES. i HAVE BEEN
USING THE SHEET IN 2003 BUT NOW 2007 GRIDLINES ARE GONE....
|
3 |
12/8/2008 6:30:01 PM |
|
|
Match and index returning N/A
Please help with this I'm tearing my hair out. My table looks like this:
Gin Vodka Brandy Whisky
North 456 654 776 776
South 1000 764 965 464
East 532 642 642 1234
West 357 456 852 842
Gin starts in B1. I want to find out say, the Brandy sales for the East
using Index and match using the formula as follows:
The text in F6 is Brandy and in F7 East
=INDEX($A$1:$E$5,MATCH(F6,$A$1:$...
|
6 |
12/8/2008 6:24:00 PM |
|
|
customize count/sum formula for overdue dates
I have a column with dates that I'd like to use a count formula where it
counts the total number of rows that are past a certain date. How
can I write the formula to calculate this count? Below is an example of what
I mean. A1 is the cell for the date criteria that will determine how many
dates are past due in column B. Column B will have mixture of date and text.
The count should include...
|
6 |
12/8/2008 5:55:41 PM |
|
|
Formulas calculate the answer wrongly as 0
Hi
I have a spreadsheet with some very simple formulas such as =cell+cell or
=SUM(cell:cell) which was working fine. However the formulas have started to
equal 0 after I have double clicked on a cell containing a formula or when I
know enter a new formula. I assume this has something to do with formatting
but have checked the basics such as automatic under the Tools and calculation
...
|
2 |
12/8/2008 5:52:14 PM |
|
|
Cleanup worksheets from 97-2003 to work properly on Excel 2007
A Customer of ours has mainly Office from 97 to 2003. When he uses worksheets
in 2007 (in Vista or XP), it comes painfully slow either opening or working
(eg to go from one cell to another), it keeps saying the program is not
responding. Even if they are converted to .xlsx the problem is the same.
These are generally simple worksheets of 2 or 3 pages with some conditional
formatting (eg ...
|
1 |
12/8/2008 5:43:00 PM |
|
|
Data Validation in Excel 2007 - Input Message
Is there a way to import informaiton into the body of the Input Message?
> What I want to accomplish is to have a list of employee ID's plus corresponding name in the Input Message for the end user without having to type in every number and name as some lists are very lengthy. Copy/Paste don't work in this box - help!
--
ADagenais...
|
1 |
12/8/2008 4:30:18 PM |
|
|
Intra-pivot table calculations
I have a pivot table that has part numbers as the row and months as the
column, with our margin on the parts for each month as the value. I want to
calculate the delta between October and November so I can sort the table by
the difference between those two months.
Right now I copy and paste special values the pivot table and add in the
column I want to calculate. I am thinking there h...
|
1 |
12/8/2008 4:30:02 PM |