I have a spreadsheet which I would like to count the number of a word in one
collumn, but only if which matches with a word in a different collumn.
目前分類:title (3013)
- Aug 14 Mon 2006 20:09
How do I use COUNTIF with two different criteria (2 collumns)
- Aug 14 Mon 2006 20:09
countif
how do i use the countif function
when i want the criteria to be a cell
- Aug 14 Mon 2006 20:09
Filtering Data With Formula
In Column D I have about 100 Cells filled with numbers. Some are greater to
or equal to zero, some are less than zero. I'm wondering if there are
- Aug 14 Mon 2006 20:09
Auto Filter Subtotals
I have five columns of data. Columns 1 and 2 are populated with names,
columns 3 through 5 with numbers. I would like to automatically create
- Aug 14 Mon 2006 20:09
Advanced filter using dates
I have a column formatted as a date field and need to do advanced filtering
on it. For example, I want to filter out entries between two dates. When I
- Aug 14 Mon 2006 20:09
Total width of several columns.
Could you please advise if there is a quick way to total the width over
several columns of a worksheet. I need to do this so that I can make page
- Aug 14 Mon 2006 20:09
longevity dates
Hi Pam:
- Aug 14 Mon 2006 20:09
bar graphs
How do I create a bar graph where the y-axis have letter values instead of
numbers? I want the x-axis to show student names and the y axis to show
- Aug 14 Mon 2006 20:09
Change Formatting In 'Active' Cell
HiI want to apply some way of keeping the formatting of an established
spreadsheet the same but changing it in the 'Active' highlighted cell only,
- Aug 14 Mon 2006 20:09
Printing a word doc from an excel button
- Aug 14 Mon 2006 20:09
Using a function to specify a cell
Say I want to specify the cell whose column is C and whose row is the
returned value of a function (say row()). How would I accomplish that?
- Aug 14 Mon 2006 20:09
List all contracts that relate to a single part number
Hi, all.
I'm trying to figure out how to display all the contract numbers that relate
- Aug 14 Mon 2006 20:09
Reset Macro
I have a form which others use which contains a macro that adjusts the form
to fit their screen regardless of the resolution they are using. Is there a
- Aug 14 Mon 2006 20:09
returning macro value to starting cell (different each time)
In my worksheet I am going to launch a macro from a different cell address
each time it is run. I want the macro execution to always complete in the
- Aug 14 Mon 2006 20:09
Making a list inside a cell
- Aug 14 Mon 2006 20:09
Using Find amp; Replace to edit cell references in links
I built the following macro to edit cell references in links to an adjacent
page, and it works great- even though it must be updated daily. Basicly, it
- Aug 14 Mon 2006 20:09
Save External Link Values
Is this error specific to a version of Excel? Will this error go away if I
upgrade?
- Aug 14 Mon 2006 20:09
Update Macro: Leave Colour As Before Once Cell is Not Active
Hi therei got this Macro code, which makes the Active cell change colour, but the
problem is that once you move away from that cell it leaves that cell with no
- Aug 14 Mon 2006 20:09
column truncated due to width constrain
Hi,
when I want to save the excel file as the prn file in the condition: the