i have a big file, data entered like dis
A V 0
W 1
X 0
Y 1
Z 1
B V 0
W 1
X 1
Y 1
Z 1
C V 1
W 0
X 0
Y 1
Z 0
i want to sumarise as :
V W X Y Z
A 0 1 0 1 1
B 0 1 1 1 1
C 1 0 0 1 0
Plz help me...
i have a big file, data entered like dis
A V 0
W 1
X 0
Y 1
Z 1
B V 0
W 1
X 1
Y 1
Z 1
C V 1
W 0
X 0
Y 1
Z 0
i want to sumarise as :
V W X Y Z
A 0 1 0 1 1
B 0 1 1 1 1
C 1 0 0 1 0
Plz help me...
I can't see the pattern!
Please post a workbook - it's a lot easier to understand what you mean.
Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
Attached a file...plz check if its possible
if it is really laid out like that then.....
"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
Thanks martindwilson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks