Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2013, 12:46 PM
mlttkw mlttkw is offline transpose values based on mulitple criteria Windows 7 64bit transpose values based on mulitple criteria Office 2010 64bit
Novice
transpose values based on mulitple criteria
 
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, 8 views)
Reply With Quote
  #2  
Old 12-06-2013, 02:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline transpose values based on mulitple criteria Windows 7 64bit transpose values based on mulitple criteria Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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, 7 views)
__________________
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
Reply With Quote
Reply

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 values based on mulitple criteria Transpose cells and skip? ItsjustB Excel 1 01-09-2013 08:53 AM
transpose values based on mulitple criteria 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

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft