|
|
|
|
1 |
821 |
|
|
|
|
2 |
821 |
|
|
|
|
2 |
918 |
|
|
modifying T. Valko ws function by
Steve
Howdee all.
I received some help from T. Valko back in January on a complicated
worksheet function. It's been working really great, and today I found that I...
|
June 1st, 2010 09:30 PM
by Steve
|
5 |
1,161 |
|
|
IF formula question by
charlie
I need to write a formual for the following:
IF J1=R and L1= 3221 OR 3223 then N1 should be FALSE
J1 could be either R or C and L1 could be any numer of...
|
|
3 |
864 |
|
|
How to know if a worksheet was unlocked by
Mathieu936
Hi!
I have a worksheet containing many formulas. This worksheet is locked
without any password.
Is there a way to see if somebody unlocked the worksheet to...
|
|
8 |
1,012 |
|
|
|
|
0 |
826 |
|
|
HLookup? by
wagz
I have a sheet that is comparing vendor's pricing. I am using the MIN to
find the cheapest cost, but now I want to find out which vendor it is based
on the...
|
|
2 |
956 |
|
|
How do I save a header? by
Global10
I need to permanently save a header and it will never save once I open up a
new file. Any suggestions?
|
|
2 |
829 |
|
|
V-Lookup variation query by
njcr83
Hi,
I am having an issue with comparing columns of values.
Basically I have a table similar to the below except with a couple of
thousand lines.
Either the...
|
June 1st, 2010 04:41 PM
by Glenn
|
2 |
871 |
|
|
Interpolation? by
Mel
What fx to use for the following scenario:
Month-End Dates (for many years) in column A
A dollar Amount for each Quarter End in Column B (correlating to the...
|
|
1 |
770 |
|
|
|
|
7 |
909 |
|
|
|
|
2 |
797 |
|
|
|
June 1st, 2010 01:08 PM
by PvZ
|
4 |
830 |
|
|
Address must be 18 characters long by
Derek M[_2_]
Hi all again
I need the address to be 18 characters long i.e. if the address is over 18
characters then chop it, if its under, then add spaces
Is this...
|
|
3 |
764 |
|
|
Difference between two date/time values by
Raj[_4_]
Hi,
Cell A1 has 21-04-10 07:00 PM
Cell A2 has 06-06-10 07:52 AM
(the dates are in the dd-mm-yy format)
Cell A3 has the formula =A2-A1 for showing the...
|
|
6 |
813 |
|
|
|
|
7 |
762 |
|
|
Can't rework the formula by
Malcolm
Yesterday I was given a solution to a problem I had when copying text from
cells in the source sheet to the destination sheet. The formula:
=IF(OR('Hskp...
|
|
7 |
841 |
|
|
If OR formula by
Susan
I am trying to write a formula that will first look at the value in C3 which
is identified by either 1 or 99. Then depending on either of these two
numbers,...
|
|
1 |
771 |
|
|
|
|
2 |
986 |