tag:blogger.com,1999:blog-8807805591547673516.post5878657872471681928..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Determine Unique Count Of Entities Based On Characters A to Z Only Regardless Of CaseYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8807805591547673516.post-56952179497709289102012-03-02T08:17:07.835-08:002012-03-02T08:17:07.835-08:00Hi Tim:
You have not tightened up your specificat...Hi Tim:<br /><br />You have not tightened up your specification in regard to naming of the films. I have however, updated my formulas to cover all the cases you have specifically mentioned so far.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-13017532524763791472012-03-01T20:52:24.321-08:002012-03-01T20:52:24.321-08:00When I apply it to all the lists it is not working...When I apply it to all the lists it is not working.<br />Here is the link for what I've got going on. The "unique" values on the right side are not unique.<br />https://docs.google.com/spreadsheet/ccc?key=0Auk8e_QiDnJOdFZ1eER4QjI5dG9salBfMWlET0pfVmc<br /><br />Thanks againtimrecordshttps://www.blogger.com/profile/14142624227063010281noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-70848283320390408992012-03-01T20:02:14.632-08:002012-03-01T20:02:14.632-08:00Hi Tim:
I have set it up to extract only alphabet...Hi Tim:<br /><br />I have set it up to extract only alphabetical characters and space characters only from the name and disregard everything else.<br /><br />If you can tighten up your specification so that it is unambiguous and covers all the bases, I can update my formula accordingly.<br /><br />In regard to your question, how my formula works -- I have used regular expression function REGEXEXTRACT to pull only alphatecial characters regardless of case and space characters from listed Film names, then I extract from this modified list UNIQUE names, and finally I use the COUNTUNIQUE function to get the count of unique names only.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-13059520224086025252012-03-01T19:49:43.402-08:002012-03-01T19:49:43.402-08:00Also it is cutting some of the names off after a p...Also it is cutting some of the names off after a punctuation it seems. dr. strangelove is cut to dr.<br />it's a wonderful life is cut to it.<br />Any thoughts?<br />You're awesometimrecordshttps://www.blogger.com/profile/14142624227063010281noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-34149802592719414632012-03-01T19:42:00.499-08:002012-03-01T19:42:00.499-08:00I see that it works, which is awesome, but I am ha...I see that it works, which is awesome, but I am having difficulties understanding it. Which I would like to.timrecordshttps://www.blogger.com/profile/14142624227063010281noreply@blogger.com