Solution How to tranpose 2 column excel spreadsheet by column A group
Hi Dear,
Please try this...
=IFERROR(INDEX($A$2:$A$11,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$11),0),1),"") with CTRL+SHIFT+ENTER
Thanks
Attachment | Size |
---|---|
TRANSPOSEQUERY.xlsx | 11.15 KB |
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 492 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Solution How to tranpose 2 column excel spreadsheet by column A groupHi Dear, Please try this... =IFERROR(INDEX($A$2:$A$11,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$11),0),1),"") with CTRL+SHIFT+ENTER Thanks
|
Highest Ranked Users
Recent Blogs
ForumsUser login |
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago