Hi!
We have a list for references, colours and sizes that we want to traspose.
One of the main difficulties is that there are references is several colours and some lack of sizes in others.
See atachement for example.
Thanks in advance,
Steve & Anita
In I3 copied across and down
=SUMIFS($D$3:$D$16,$A$3:$A$16,$G3,$B$3:$B$16,$H3,$C$3:$C$16,I$2)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
If you want to create column G and H also, you'll need an ARRAYED Formula
In G3 copied across to H3 and down
=IFERROR(INDEX(A$3:A$16,SMALL(IF($E$3:$E$16=1,ROW($E$3:$E$16)-ROW($E$3)+1),ROWS($A$1:$A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Thanks a lot!That was great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks