|
|
Index Match 2 columns 1 row by
deeds
I am sure this is out there somewhere...I just can't find it.
A B C D E
Cage Box Kennel
Dog 2008 ...
|
August 31st, 2008 09:36 AM
by Max
|
2 |
210 |
|
|
Subtotal Formula by
Chris
I have this formula:
=INDIRECT("PrintData!J" &RowIndex)
and need to wrap a subtotal 9, around it so that it only includes
visible rows when there is an auto...
|
|
1 |
80 |
|
|
|
|
1 |
122 |
|
|
|
August 31st, 2008 01:47 AM
by smartin
|
1 |
123 |
|
|
|
August 31st, 2008 01:22 AM
by smartin
|
1 |
79 |
|
|
|
August 30th, 2008 11:21 PM
by smartin
|
1 |
117 |
|
|
Validation List 27.08.08 by
robzrob
I have a validation list for a particular cell. It contains a list of
longish phrases which I want to be able to select from for that
particular cell. But...
|
August 30th, 2008 09:43 PM
by robzrob
|
4 |
158 |
|
|
How to expand Index/Match formula by
Chris
I have the following formula below, but I want the formula to also
match columnD in addition to columnA on my Data! sheet. ColumnA and
ColumnD on Data! needs...
|
|
2 |
154 |
|
|
|
August 30th, 2008 07:50 PM
by Sheryl
|
2 |
115 |
|
|
Problem with Self signed Certificate by
Bill R
I have tried deleting the certificate but I keep getting a message saying
that the worksheet is read only. The worksheet totally locks up. How can I
fix it.
|
August 30th, 2008 04:53 PM
by Bill R
|
0 |
88 |
|
|
round up (ends with...) by
jatman
i need something that will round as follows:
OLD NEW
16.99 =16.99*1.04
result is as follows:
OLD NEW
16.99 17.67
what i need is the 17.67 to...
|
|
3 |
91 |
|
|
Validation on cell by
dalymjl[_6_]
Is it possible to apply a validation to a cell to allow only a 7 digit
number followed by any letter from A to W e.g 1234567T?
--
dalymjl
|
|
4 |
109 |
|
|
Vlookup/match? by
Chris
Can anyone help me out with creating a formula that does the
following.
sheet1 has a 'JobCode' in column C
sheet 2 has a 'JobCode' in column A with an...
|
August 30th, 2008 10:52 AM
by Max
|
9 |
145 |
|
|
|
August 30th, 2008 07:26 AM
by JLatham
|
1 |
123 |
|
|
Add-In Program by
NoodNutt
G'day everyone
Many years ago, when I was using an earlier version of Excel (Now currently
using 2007), I came across an add-in program that had several...
|
|
1 |
175 |
|
|
Formatting Time by
Dan D...
I am having an issue with getting Excel to reformat time. I copy and paste
data from an Access query into a spreadsheet. After doing this, any changes
to the...
|
August 30th, 2008 04:53 AM
by Max
|
7 |
106 |
|
|
Drop down list by
Dave
I have a sheet that has a scorecard on it. I have a drop down list that
refers to records from another sheet. If I choose from the drop down list,
say 1-5,...
|
August 30th, 2008 03:48 AM
by Dave
|
0 |
119 |
|
|
Count but with conditions by
v!v
I have a table for each person that's periodically updated with essentially 3
columns: A = week ending dates, B= work hours, and C= travel hours. For any...
|
August 30th, 2008 02:38 AM
by v!v
|
7 |
110 |
|
|
|
|
1 |
116 |
|
|
|
|
11 |
238 |