#1
|
|||
|
|||
transpose values based on mulitple criteria
here is my dilemma. I have a dynamic data source that will have the same distinct Names in column a and b and c and the same of occurrences in each column. Across row 1 the values are also static.
the data within will change in my output I need to match the distinct values from the input to the output and transpose the values accordingly to the output file I am attaching my example for better depiction...I am playing around with a combination of Match, Index and Transpose and can't quite get the outcome. PLEASE HELP!!! |
#2
|
||||
|
||||
In C20 enter
Code:
=SUMPRODUCT(($A$5:$A$13=C$17)*($B$5:$B$13=C$18)*($C$5:$C$13=C$19)*INDEX($D$5:$F$13,,MATCH($A20,$D$4:$F$4,0)))
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MACRO - Insert row based on Form Field Criteria | Elan05 | Word VBA | 5 | 04-16-2013 06:39 AM |
Transpose cells and skip? | ItsjustB | Excel | 1 | 01-09-2013 08:53 AM |
Conditionally Email People Based on Values in Fields | dawsonh2002 | Mail Merge | 2 | 12-12-2012 12:11 PM |
change values based on cell | ubns | Excel | 1 | 05-21-2012 06:28 PM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |