Subodh_Tiwari_sktneerSilver ContributorJoined 7 years ago1152 Posts272 Likes209 SolutionsView All Badges
Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Need help with finding data from two differing columns You're welcome Paul_Farquhar! Glad it worked for you. Re: Need help with finding data from two differing columns Paul_Farquhar An alternative would be to insert a Pivot Table, as demonstrated in the attached file and change the NumberFormat of one of the Values cells to "Yes";; to achieve the desired output. Re: action based on cell selection drdree73 Thanks for the offer! 🙂 Please look at the attached and see if this helps. List the market holidays in column AA. Re: action based on cell selection drdree73 Please check the attached. Re: action based on cell selection You're welcome drdree73! Re: action based on cell selection drdree73 Please look at the attached and let me know if this is what you were trying to achieve. Re: Count unique values among duplicates with 1 condition You're welcome Lawrence_Lam_320! Glad it worked for you. Please take a minute to accept the post with the proposed answer as the Best Response to mark your question as Solved, Re: Count unique values among duplicates with 1 condition Lawrence_Lam_320 You can also try the following formula if you have Office 365... =COUNT(UNIQUE(FILTER(A2:A11,B2:B11="C"))) Re: Need numbers from within cells You're welcome bsrujan! Glad it worked for you. Thanks! You too. Please take a minute to accept the proposed answer as the Best Response to mark your question as Solved. Re: Need numbers from within cells bsrujan Okay, please try this and see if this works for you. Function ExtractNumber(ByVal str As String) As Variant Dim Matches As Object With CreateObject("VBScript.RegExp") .Global = False .Pattern = "\d+" If .test(str) Then Set Matches = .Execute(str) ExtractNumber = Matches(0) + 0 If (Len(ExtractNumber) < 7) Or (Len(ExtractNumber) > 9) Then ExtractNumber = "" End If End With End Function Re: Need numbers from within cells bsrujan You may place this UDF on a standard module like Module1 and then use it like a regular function on the worksheet. Function ExtractNumber(ByVal str As String) As Long Dim Matches As Object With CreateObject("VBScript.RegExp") .Global = False .Pattern = "\d{7,9}" If .test(str) Then Set Matches = .Execute(str) ExtractNumber = Matches(0) End If End With End Function Assuming your string is in A2 then try... =ExtractNumber(A2) Re: How do I create a validation dropdown that uses the FILTER function? RedNectar Please look at the sheet called "Validation" in the attached which contains a setup for the validation lists and then on the attribute_tab sheet, the first validation uses =Validation!$A2# as the source for the validation list which is then copied down. See if this helps. Re: Complex validation TKIng1917 You may try this... In F2... =IF(NOT(ISNUMBER(A2)),"",INDEX(A$2:A2,,MATCH("ZZZ",A$2:A2))) and then copy it down. Re: Formula returning #value 62Mojo Do what Patrick suggested and your existing formula will work. Btw you have used the SUM function in the wrong way, try it like this and your formula will work. The advantage of using the SUM function as suggested below is, it ignores the text values. =IF(SUM(G31:G32)>0,SUM(G31*0.5,G32),"") Re: How to get all the unique distinct value from a list in Excel evilgreenred You may also try this... =SORT(UNIQUE(TOCOL(B2:D8,1))) Re: Formula to match Day of Week Name Ron_Hockman1525 For older versions of Excel, you may try the following formula... =(LEN(A2)-LEN(SUBSTITUTE(A2,TEXT($B$1,"dddd"),"")))/LEN(TEXT($B$1,"dddd")) For Excel 365, you may also try the following formula... =SUM((TEXTSPLIT(A2,"; ")=TEXT($B$1,"dddd"))*1) Re: How to remove the special Characters from the Excel List ajmal_pottekattil_yoousuf Do you want to remove the special characters from column D (serial_no)? Re: VBA Run-time error '1004' when Hide/Show Rows You're welcome jmpjmp! Re: VBA Run-time error '1004' when Hide/Show Rows jmpjmp This is because the ListFillRange is set to A1:A10 and you are trying to hide those rows. An easy fix is to use On Error Resumen Next like below... On Error Resume Next Rows(ShowRows).Hidden = False Rows(HideRows).Hidden = True On Error GoTo 0 Re: Help please Paula_Mayes You're welcome, Paula! Glad it worked for you. But you selected your own reply as the Best Response. 🙂
