Excel - Using the ISODD Function in Excel for Data Analysis - Episode 1683
2,710 views · Published 8 April 2013 · 3:16 · Indexed 12 November 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: Using the ISODD Function in Excel for Data Analysis: MrExcel Podcast. Welcome back to the MrExcel Podcast. In this episode, we're diving into the ISODD function in Excel. As Mrs. Excel and I are shopping for a new house, I came across a property on Via de la Reina and wanted to compare it to other recent sales in the area. However, I needed to separate the even and odd numbered houses on the street, as one side is on a canal and the other is not. This is where the ISODD function comes in handy. Instead of using the MOD function, which is typically used for separating even and odd numbers, I decided to use the ISODD function. I first used Flash Fill to extract the street numbers from the property appraiser's website, and then used the ISODD function to determine if the number was odd or even. This allowed me to easily separate the houses on the canal side from those across the street. But that's not all! I also needed to extract the hyperlinks from each of the houses' pages to gather more data. Instead of manually clicking on each link, I used a code that I shared in a previous podcast episode. This code quickly extracted all the hyperlinks, making my data analysis even easier. In tomorrow's episode, we'll take a look at how to gather data from each of those pages using the hyperlinks we extracted. Thank you for tuning in to this episode of the MrExcel Podcast. Don't forget to subscribe and join us next time for more Excel tips and tricks. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Data analysis for house shopping (00:17) Comparing houses on Via de la Reina (00:27) Using data mining to gather information (00:37) Differentiating between even and odd street numbers (00:50) Using ISEVEN and ISODD functions instead of MOD (01:00) Using Flash Fill to organize data (01:27) Sorting and copying values (02:13) Obtaining hyperlinks for data from each page (02:56) Fast and efficient data retrieval using code (03:06) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Comparison of house sales Data extraction from web pages Even and odd numbers Excel data analysis Flash Fill in Excel 2013 Hyperlinks in Excel ISEVEN function ISODD function Property appraisers website Via de la Reina homes Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153505/ Mr. and Mrs.Excel are House shopping in Florida. And how does Bill prefer to look over the details? In Microsoft Excel, of course. Today, in Episode #1683, Bill Looks at using his Data Set with a variety of means to get to the Location of the home, as well as a look back to an older Podcast from 2011 [Episode #1362 http://www.youtube.com/watch?v=l82wlr3kaFo ] that contains VBA Code for Hyperlink Extraction. And... be sure to tune in tomorrow, because once we have our Formulas set up and our Hyperlinks extracted, Bill will be showing us how to get the Hyperlink Data for each of those links! This mini-series is a really cool overview of some of our earlier Podcasts and how to integrate a variety of Formulas and Functions to evaluate Real Estate. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html And for more information on Excel 2013, check out "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. http://www.amazon.com/Excel-2013-Depth-Bill-Jelen/dp/0789748576
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920