I have a table Which Items in Rows and data Under heading of columns.(Table1)
I want to make a Table2 that By columns headings in Rows and Items in Columns with condition if data greater than 0(zero).
I need only formula & functions (Macro not available for real file structure)
You can see example file attached and detail.
Thanks in advance for any reply and help.
Regards,
turist
Hi
In B11 and copy down and across use this ARRAY formula.
Formula:
Please Login or Register to view this content.
or with comma as separators
Formula:Please Login or Register to view this content.
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Similar to Fotis' solution:
I created table starting in B25
If your tables are large, then you'll want to get away from these Array formulas but that will require some dummy columns.Formula:Please Login or Register to view this content.
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
Thanks both of you.
Working, very well.
Regards,
turist
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks