No place for sum
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. |
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. |
No place for sum
Thank you very much.
Now with your code on A7 I have the desired report starting from row 7 leaving me enough space for labels and sums at top. Great ! |
No place for sum
Hi
Sorry. One more question. How can I sort my list according to B column ? It is date. (I mean with formula change) On A7 =IF(sheet1!B2="nameA",ROW()-5,"") On B7 and others =IF(ROW(A1)COUNT($A:$A),"",INDEX(sheet1!A:A,SMALL ($A:$A,ROW(A1)))) |
No place for sum
select row 7 and below.
data sort by column B " wrote: Hi Sorry. One more question. How can I sort my list according to B column ? It is date. (I mean with formula change) On A7 =IF(sheet1!B2="nameA",ROW()-5,"") On B7 and others =IF(ROW(A1)COUNT($A:$A),"",INDEX(sheet1!A:A,SMALL ($A:$A,ROW(A1)))) |
All times are GMT +1. The time now is 11:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com