Thanks, Frank.
Maybe I'm missing something, but can I have your email address?
Stan
"Frank Kabel" wrote:
Hi
if you like email me a sample file and I'll create some formulas for this
--
Regards
Frank Kabel
Frankfurt, Germany
"Stan" schrieb im Newsbeitrag
...
Frank,
Unfortunately, the downloaded schedule is coming from other division,
straight from the G/L. Besides, we usually have over 1500 rows of data. I
was
hoping to find a formula (not a macro) instead of fill-in blanks cells in
Col
A.
Stan
"Frank Kabel" wrote:
Hi
it would be much easier if you could fill column A completely with the
group
name. Could you change this layout?
--
Regards
Frank Kabel
Frankfurt, Germany
"Stan" schrieb im Newsbeitrag
...
I need to use SUMIF to calculate a subtotal of column B based on the
criteria
of column A. The problem is, the column A has names of group in every
10th
cell or so, and column B has many repeated numbers which could vary
month
to
month.
Example)
Col A Col B
group A a
b
c
group B a
b
c
d
I need subtotals for group A & B, even when group A has "d" listed in
Col.
B
in other months.
Please help. Thanks.
Stan
|