Learn how to get maximum of comma-separated values in a cell In Excel <br /><br />In Excel, extracting and manipulating data from cells containing comma-separated values can be efficiently achieved using various functions. To get the maximum value among comma-separated values in a cell, one can utilize the combination of functions like SUBSTITUTE, TEXTJOIN, and MAX. <br /><br />Max Value From Comma Separated Value <br />=MAX(--(TEXTSPLIT($B2,","))) <br /><br />Min Value From Comma Separated Value <br />=MIN(--(TEXTSPLIT($B2,","))) <br /><br />1) TEXTSPLIT($B2,","): This function splits the text in cell $B2 into an array of substrings, using the comma (",") as the delimiter. For example, if cell $B2 contains "10,20,30", this function will return an array containing three elements: "10", "20", and "30". <br />2) --: The double unary operator (--) is used to coerce the resulting array of strings into an array of numbers. This is done by converting each string element into a number. If any element of the array cannot be converted into a number, it will result in a NaN (Not-a-Number) value. <br /><br />🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗 <br />Sum comma separated values in Excel - Excel Tips and Tricks <br />https://youtube.com/shorts/1GUx7zi2wzc?si=Rc8Oidvtr6t-dOFV <br /><br />Sum comma separated values in Excel Without Using TEXTSPLIT() Function - Excel Tips and Tricks <br />https://youtube.com/shorts/z6ghCP7G3ew?si=rIS6nZL31jA41g17 <br /><br />Separate data from one cell in Excel with commas - Excel Tip and Tricks <br />https://youtube.com/shorts/xuhpFwb5TWg?si=8YYj22Elb2Ez2rMp <br /><br />Text Split with multiple delimiters - Excel Tip and Tricks <br />https://youtube.com/shorts/LXZkMlGZWXQ?si=v-ovLGoZ2SdQ-baC <br /><br />[NO FORMULA] Separate data from one cell in Excel with commas - Excel Tip and Tricks <br />https://youtube.com/shorts/4AhokAuE5Nc?si=ObQffk0YBaj0SgyU <br /><br />Sum comma separated values in jaggered format in Excel - Excel Tips and Tricks <br />https://youtube.com/shorts/ijC7qhRK6s0?feature=share <br /><br />Get maximum of comma-separated values in a cell In Excel - Excel Tips and Tricks <br />https://youtube.com/shorts/UHdjAsSx6C8?feature=share <br /><br />Sum comma separated values in Google Sheets - Excel Tips and Tricks <br />https://youtube.com/shorts/bYOX6V_iWnI?feature=share <br /><br /><br />Get maximum of comma-separated values in a cell In Excel,Get maximum of comma separated values in a cell,How to Count Comma Separated Values in One Cell in Excel,Get maximum of comma separated values in a cell, <br /><br />Check out my complete suite of Microsoft Excel Tips and Tricks. <br />https://www.youtube.com/@jjnet247/shorts <br />https://www.tiktok.com/@exceltips247 <br />https://www.instagram.com/exceltips247/ <br />https://www.dailymotion.com/ExcelTips247 <br />https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/ <br />https://x.com/ExcelTips247/media <br />https://www.reddit.com/r/Excel247/ <br />https://www.facebook.com/XyberneticsInc/reels/ <br /><br />#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks
