Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-05-2013, 12:46 PM
mlttkw mlttkw is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2013
Posts: 2
mlttkw is on a distinguished road
Default 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!!!
Attached Files
File Type: xlsx Book3.xlsx (11.9 KB, 2 views)
Reply With Quote
  #2  
Old 12-06-2013, 02:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,901
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

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)))
and pull down and across
Attached Files
File Type: xlsx Book3(1).xlsx (12.0 KB, 0 views)
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

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


All times are GMT -7. The time now is 03:03 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft