No place for sum
Not completely sure what you are trying to do or what your problem is, but
could you use in A7
=IF(sheet1!B2="NameA",ROW()-5,"")
I don't know what you are doing in the scond equation so no suggestions
" wrote:
To create a report from sheet1 I use below formula on sheet2
On A2
=IF(sheet1!B2="NameA",ROW(),"")
On B2 and C2 and other columns
=IF(ROW(A1)COUNT($A:$A),"",INDEX................. .........
I create all reports needed. But it starts from top.
And no place for sums.Want to leave say 5 rows
at top for report label and sums.
Instead of A2 tried to start on A7 but didn't work.
Can you advice ? Thank you.
|