I have set up an Excel sheet that retrieves data from an Access database that
is stored on the local network. Microsoft Query stores the location of this
- Jul 20 Thu 2006 20:08
using network paths rather than drive letters in microsoft query
- Jul 20 Thu 2006 20:08
#N/A in VLookup
I am using a VLookup function. I need to find an exact match, but when there
is no match, I would like to see a zero, rather than #N/A. Can someone help
- Jul 20 Thu 2006 20:08
finding a file
Hi.
I have opened a excel file that was in the zip by double clicking.
- Jul 20 Thu 2006 20:08
Chart on Voter Turnout
I am trying to make a chart with two series--one showing turnout in
presidential years and the other in mid-term elections.
- Jul 20 Thu 2006 20:08
Information retrieval functions
Hi,
I'm new here, and a bit of an Excel newbie and would like to learn more but
- Jul 20 Thu 2006 20:08
Copy Function into other cells
I am trying to copy a easy function, =SUM(b10-B11), into other cells in the
same column and it will not work. It gives me the correct formula but it
- Jul 20 Thu 2006 20:08
possible? =if(That cell = quot;a certain wordquot;, delete row, go next)
Can Conditions include operative actions if true or false? such as:
- Jul 20 Thu 2006 20:08
Comparing two cells
Hi,
- Jul 20 Thu 2006 20:08
List Object and Protection
Can't get worksheet protection to protect formulas in a created list object
(Ctrl L) and still allow for the auto-insert row feature from the blue *
- Jul 20 Thu 2006 20:08
Birthday calculations
Hi,