In sorting sheet when i select the 4 list boxes, that particular data will be displayed based on data sheet
In sorting sheet when i select the 4 list boxes, that particular data will be displayed based on data sheet
Last edited by Shilpa kanchan; 08-01-2012 at 01:12 AM.
is it very difficult
Using SUMIFS..see attached Cell C10
Life's a spreadsheet, Excel!
Say thanks, Click *
Tkank you.. but I dnt want the total of particular Party.
for eg : when i select India, AM, 2012, Aug.. that result wil be
Inv Date Weight
2-8-2012 6256
20-8-2012 16910
23-8-2012 17030
Last edited by Shilpa kanchan; 07-31-2012 at 05:33 AM.
In C8 of Sorting Sheet use =MATCH(B8,P2:P13,0)
and try this..
Please Login or Register to view this content.
can't I use any excel formula
---------- Post added at 04:34 AM ---------- Previous post was at 01:55 AM ----------
here you go helper column in data sheet column F you can hide that or even put it on another sheet completely
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks