Loading formats...
MrExcel's Learn Excel #945 - Index Column Row
B
Bill Jelen
1 views • Feb 06, 2009
Description
Rod from Australia sends in an excellent tip for today's episode. Rod receives a CSV file every day that needs to be transposed. Rod put together an elegant combination of INDEX, COLUMN, and ROW to solve this problem. Episode 945 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Discover more
Keywords & tags
More from this user
02:34
MrExcel's Learn Excel #976 - Default Comment
Bill Jelen
03:19
Learn Excel 2010 - "Date Next to a Yes" #1474
Bill Jelen
07:51
Dueling Excel - "Rank Ties by Weight" #1473
Bill Jelen
03:39
Learn Excel 2010 – “Wrap Cells and Resize" #1472
Bill Jelen
02:08
Learn Excel 2010 - "Random with No Repeats" #1471
Bill Jelen
06:30
Learn Excel - "Copy Total to Weeks Macro": #1470
Bill Jelen
Related videos
00:05
[PDF] EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets
Mingdestiny
00:05
Read EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets
Boziek
09:14
How to Use Vlookup to Merge Spreadsheet Data - Match Data in Google Spreadsheets and Excel
Alonza Darrick
01:26
How to Excel Delete Remove Duplicates and Duplicate Cells Data from Multiple Excel Spreadsheets
HotHotSoftware1
00:28
PDF Excel for Auditors Audit Spreadsheets Using Excel 97 through Excel 2007 Download Full Ebook
Reyna
03:09
How to extract e-mail addresses from Excel Spreadsheets (or multiple excel files)
HotHotSoftware1