I am using an If function to see if column H matches either I, j, K or L.
All of these columns contain numbers ranging from $0.00 to $20,000.00.
目前分類:title (4957)
- Jun 04 Wed 2008 20:44
Truncating numbers
- Jun 04 Wed 2008 20:44
Securing access to a spreadsheet on the web when .xls is saved as
A client wishes to place a spreadsheet on to his website, and wants to
restrict access to selected people.
- Jun 04 Wed 2008 20:44
Strange Vlookup problem
- Jun 04 Wed 2008 20:44
Issues with Advanced Filter
I am trying to use the advanced filter to grab distinct values from a
column on my spreadsheet and copy it to a different location. This
- Jun 04 Wed 2008 20:44
how to create my own functions??
- Jun 04 Wed 2008 20:44
This is what I want to do...
- Jun 04 Wed 2008 20:44
New featu Two rows join amp; sort together.
Can this be done?
- Jun 04 Wed 2008 20:44
Drop down box like a form
I need a simple drop down box of choices of Yes, No, and N/A. How do I do
this so it acts like a form? I need it on about 100 cells. I am sure one I do
- Jun 04 Wed 2008 20:44
How can I fill in the required fields on my spreadsheet?
having trouble filling in a spreadsheet sent to me by email.
- Jun 04 Wed 2008 20:44
Is there a way to convert an entire Excel workbook to a pdf file?
I know you can convert individual worksheets to pdf files, but is there a way
to convert the entire workbook to pdf?
- Jun 04 Wed 2008 20:44
multiple column lookups
I need to get a formula for Col D in sheet 1 to tell me that for column A in
Sheet 1
- Jun 04 Wed 2008 20:44
Option Button
I have been asked to do a form in Excel and one portion of the form requires
a simple Yes or No answer. The best way of doing this I thought was giving
- Jun 04 Wed 2008 20:44
How do I conditionally format a chart?
I need to format a chart in Excel so that values in certain ranges (such as
0-19, 20-39, 40-59...) are shown in different colors. There are too many
- Jun 04 Wed 2008 20:44
Please
When trying to format the walls or the data series of a 3D Chart with a
picture fill, a copy of the worksheet the data is being taken from appears
- Jun 04 Wed 2008 20:44
contents in cells are not visible when word wrap is selected
It appears the profile or standard template for excel has been changed on my
machine. Spreadsheets I worked on earlier this week that contained cells
- Jun 04 Wed 2008 20:44
Microsoft Excel 2003
Why is the Advanced Filter extracting only the 1st row of the range in my
spreadsheet? No matter what criteria I use it only pulls the first row. I'm
- Jun 04 Wed 2008 20:44
A counting question...
- Jun 04 Wed 2008 20:44
time questions (roundup amp; convert hh to mm
hi, 2 questions please...
1st. i have durations in column A in hh:mm:ss format. How do I round them up
- Jun 04 Wed 2008 20:44
Hiding values in cells
I have one cell that has my begining total...and then another cell that has
the payment and the 3rd cell is the remaining balance my formula is