Search results

Hi: May be overlap the graphs and show the axis as attached? Thanks

Hi May be something like this? THanks

Hi: May be this? Thanks

Hi: It would be beneficial if you could upload a sample file so that we don't have to recreate what you are looking for. Thanks

Hi: May be something like the attached. Thanks

May be this =INDEX(LookupLists!$C:$C,MATCH(1,MMULT((A2=LookupLists!$A:$A)*(TRIM(D2)=LookupLists!$B:$B),1),0)) Thanks

Hi: May be this? Thanks

HI: May be this =IF(OR(M6={0,""}),"",IF(L6="","In Service",IF(COUNTIFS(I6:I$1063,I6,K6:K$1063,K6) <=2,L6-G6,IF(M6=1,"Removed","R")))) But I am not sure how you arrived at 31 and why the logic is different only for that row. Thanks

Hi: Sorry for delay in reply, here is a link to the solution I had give earlier. https://chandoo.org/forum/threads/multiple-drop-down-lists-with-the-same-data.30596/#post-182431 Note: This uses a one line VBA code to identify the cell no if I remember correctly. Thanks

May Be you can use the following VBA Sub test() Dim l& i& = ActiveCell.Row j& = Range("B" & i) Range("D" & i).ClearContents If Range("B" & i) <= Range("C" & i) Then Do While j& <= Range("C" & i) k& = WorksheetFunction.Combin(Range("A" & i), j) l = k k = 0 Range("D" & i) = l + Range("D" & i) j...

Hi: I suggest you to use searchable drop-downs, In your method if I understand correctly you are pulling the names based on the surname. what if two people have same surname? Thanks

Hi: May be this VBA Sub test() Application.ScreenUpdating = False Dim j&, k& For l& = 2 To 4 m& = Len(Range("A" & l)) m = m - Len(WorksheetFunction.Substitute(Range("A" & l), "A", "")) For i& = 1 To m If InStr(j + 1, Range("A" & l), "A") > 0 Then j =...

Hi: May be rank function Rank(range,range). Thanks

May be this? =IF(AND(COUNTIF(B1:B5,"Yes")=2,SUMIF(B1:B5,"Yes",A1:A5)=3),"Good",IF(AND(COUNTIF(B1:B5,"No")=2,SUMIF(B1:B5,"No",A1:A5)=3),"OK",IF(AND(COUNTIF(B1:B5,"No")=2,SUMIF(B1:B5,"No",A1:A5)=4),"Not...

Hi: Please find the attached. Thanks Nebu

Hi: May be this =OFFSET(CALCS!$D$15,,,COUNTIF(CALCS!$D$15:$D$109,"<>#N/A"),1) Thanks

Hi: May be this code: Sub test() Dim b As Object Set b = ActiveSheet.Buttons(Application.Caller) With b.TopLeftCell c& = .Row End With i& = Me.Cells(Rows.Count, 4).End(xlUp).Row - 1 If Cells(i, 1) <> vbNullString Then: Rows(c + i).EntireRow.Insert End Sub Thanks

Hi: You have to use evaluate since the formula you are using is an array formula. The formula I have given is an alternative even though the formula with MMULT is an array formula it is not executed using Control+Shift+Enter, since MMULT as a native function is an array. Thanks

Hi: I had missed one dot in the code before MMULT, try including the dot the code should should work. Thanks

Hi: May be this code With Application.WorksheetFunction modlv = IfError(.Index(Sheets("Poll").Range("AE:AE"), .Match(1, .MMult((Sheets("Info").Range("$E$15") = Sheets("Poll").Range("$A:$A")) * (Sheets("Info").Range("$C17") = Sheets("Poll").Range("$G:$G")), 1), 0)), "") End With Note: The...

Hi: I have changed your WKEND HRS formula to =SUM(SUMIFS($A$6:$BK$6,$A$4:$BK$4,{7,1})) and your WKEND AVG formula to =AVERAGE(AVERAGEIFS(A6:BK6,$A$4:$BK$4,{7,1})) Thanks

Hi Shahin: This is working fine, I increased the loop from 20 to 25 and its giving me all the tweets I am looking for. Thanks for this quick turn around. Regards Nebu

Hi Shahin: This is working fine ( I had to add VBA reference library to get it working), but the only issue is that it is scrubbing only the first few lines of the webpage as @Marc L pointed out in his post the web page is not loading soon enough to capture the data. Is there a way to overcome...

Hi Marc: Is there a way to add a line of code (potentially break time for 10-15 seconds) which will allow a considerable chunk of the web page to load before scrapping the data from the site? Does that make a difference to the results? Disclaimer: I am not a programmer, my background is...

Hi Marc: Excellent!!! This is working fine for me . I can use formulas on this extract to get what I need for my analysis.However, it extracts only first few tweets on to the spreadsheet. Is there a way to dynamically decide on the no:of tweets to be extracted? say, first 100 tweets...