|
|
Find address of active cell by
Dave
Is there a function that returns the row, column or address of the active cell?
I'd like to build a formula in a column that displays a character if the...
|
September 6th, 2006 06:43 PM
by Dave
|
5 |
65 |
|
|
Lookup tables? by
Dave
I have 5 plus variables. See below for types of criteria. If the criteria
meet certain conditions then it needs to sum all the appropriate values for
that...
|
April 5th, 2007 01:12 AM
by Dave
|
2 |
80 |
|
|
Generating a list by
Dave
Hi all,
I've been wrestling with a problem for some time now and I think it's time
to ask for some professional help :(
I've got a column from J3:J1000 that...
|
April 4th, 2007 12:35 AM
by Pete_UK
|
1 |
49 |
|
|
hyper link to another file by
Dave
I have a hyper link in cell b4 in worksheet 1 which links to another file.
How can I link that hyperlink to cell b4 in worksheet 2 so that when I update
the...
|
May 21st, 2009 06:32 PM
by Dave
|
0 |
76 |
|
|
|
|
3 |
137 |
|
|
Colors according to the month by
dave
Hello,
im working on xl sheet which contain 12 months information. i need to
highlight the next column to the date according to the month. If the
date in cell...
|
December 6th, 2009 03:40 PM
by dave
|
2 |
131 |
|
|
Dependent dropdowns by
Dave
Hi,
XL2003
I have many named ranges in my workbook. Relevent ones a
"Components" "ResTH" (without the quotes).
On my worksheet:
Cell A2, Data Validation...
|
|
4 |
155 |
|
|
Counting sales by
Dave
I have two different datasets. Each with a common identifier. I need a
formula that will reference the identifiers in both datasets and count the
number of...
|
|
1 |
148 |
|
|
|
March 7th, 2010 07:47 PM
by dave
|
6 |
102 |
|
|
Automatic creation of worksheets by
dave
Does anyone have any idea how to accomplish the following using a
macro? The first sheet has 'n' number of rows. I want to
automatically create a seaparate...
|
March 15th, 2007 05:03 PM
by dave
|
2 |
63 |
|
|
Pivot Table Data did not update by
Dave
I copied and pasted data into a current Pivot Table data Sheet. I reviewed
the wizard to be sure that my rows and column lengths were correct. I
refreshed...
|
March 12th, 2007 10:24 PM
by Nagesh
|
1 |
45 |
|
|
|
September 7th, 2006 06:13 PM
by Nobody
|
3 |
56 |
|
|
VLOOKUP weirdness by
Dave
Hi all,
I've got a bit of a problem involving VLOOKUP on a spreadsheet I'm
designing. I have a VLOOKUP formula in a particular cell (which works) that
I...
|
November 5th, 2006 03:22 PM
by Dave
|
2 |
105 |
|
|
Adding an AP to a worksheet automatically by
Dave
Hi all,
I've been trying to achieve the above now for a couple of weeks and I've got
nowhere. Please could someone help me?
I have a list of transactions in...
|
November 7th, 2006 09:59 PM
by Dave
|
2 |
54 |
|
|
couting dates as events per month by
Dave
Hi
I have a column of dates covering several years. I want to total the dates
as # of events per month per year.
Example
date range my result...
|
|
4 |
57 |
|
|
|
January 24th, 2007 08:27 PM
by Dave
|
3 |
53 |
|
|
cells react different on 2 computers by
Dave
I copies the same file to 2 different computers
Computer 1, I can tab to cell and enter information
Computer 2, I have to double click on cell to enter...
|
January 23rd, 2007 02:49 AM
by Dave
|
0 |
43 |
|
|
|
|
3 |
113 |
|
|
Assigning numerical value to text by
Dave
This may be simple but I'm new...forgive me...
I've created drop-down lists in a column with several variables all in text
from a list. I am trying to make...
( 1 2)
|
February 1st, 2007 02:21 AM
by Dave
|
11 |
140 |
|
|
Index from TM by
Dave
Hi,
Looking at an answer from Teethless Mama to someone else's question, raised
yet another question. (what a surprise)
The formula was:...
|
|
8 |
253 |