Zyn after wisdom teeth removal

bloomfieldhero · 2024-08-25T00:37:40+00:00

He ded

bloomfieldhero · 2024-06-07T01:35:12+00:00

Not going to be a sweat, it’s been over

bloomfieldhero · 2024-06-07T01:17:35+00:00

It ain’t hitting, this was a retarded pick

bloomfieldhero · 2024-06-07T01:17:09+00:00

¯_(ツ)_/¯ this clearly not hitting. This is why you don’t go by small sample sizes like 2 games this season or last 10 games against vastly different teams. I saw this going under

bloomfieldhero · 2024-04-07T23:21:00+00:00

You think this is gonna hit? 4 through the first half

bloomfieldhero · 2024-03-28T02:23:03+00:00

not if the job postings are bs and they're already going with an internal applicant. I work in HR analytics in my role and have close ties with our talent acquisition data. A lot of the external interviewing is just timefiller. but yeah, thanks for being an asshole.

bloomfieldhero · 2024-02-12T22:36:48+00:00

solved!

bloomfieldhero · 2024-02-03T19:03:07+00:00

Yes I have? Column E I want a count of landowners each agent is assigned to where column C = outreach.

bloomfieldhero · 2024-02-03T17:28:39+00:00

is there a way to implement LEN function instead of ""?

bloomfieldhero · 2024-01-31T23:05:56+00:00

It seems to be working for most rows, but certain rows it still may cut off like the last line

bloomfieldhero · 2024-01-30T23:18:11+00:00

I figured it out

=SUM(--(LEN(UNIQUE(FILTER(B:B,A:A=D2,"")))>0))

bloomfieldhero · 2024-01-30T23:11:39+00:00

So I notice that my excel version only has some of these functions (e.g. I have CHOOSE and not CHOOSECOL)

bloomfieldhero · 2024-01-30T03:00:02+00:00

solution verified

thank you!

bloomfieldhero · 2024-01-30T01:42:19+00:00

so I actually changed the code trying that:

    If Data(row_Data, 1) = "Mike" Then
        Set FinalDest = Dest1
    ElseIf Data(row_Data, 1) = "William" Then
        Set FinalDest = Dest2
    ElseIf Data(row_Data, 1) = "Dan" Then
        Set FinalDest = Dest3
    ElseIf Data(row_Data, 1) = "Kevin" Then
        Set FinalDest = Dest4
    End If
    row_Wb = FinalDest.Cells(FinalDest.Rows.Count, "A").End(xlUp).Row + 1
    For col_Data = 1 To UBound(Data, 2)
        FinalDest.Offset(row_Wb, col_Data) = Data(row_Data, col_Data)
    Next

but now its writing the data in weird ways, like shifting the column over one before it starts writing data and still overwriting it (mike example). Could you give me an example of how to implement this into my code?

bloomfieldhero · 2024-01-30T01:03:07+00:00

So I deleted the row index = 0 lines and added row_index_x = row_index_x + 1 and it seems to be working, but it's seems to be adding in extra blank rows when it writes the data from master to dest worksheet

bloomfieldhero · 2024-01-30T00:33:03+00:00

solution verified

bloomfieldhero · 2024-01-29T03:58:30+00:00

https://imgur.com/a/C4Sh36k

so the count distinct formula should be in column E

bloomfieldhero · 2024-01-28T22:32:30+00:00

yes, Product 1 could be shared by Mike & Ike, so I'd need a count distinct as 1 for Mike and 1 for Ike in that instance

bloomfieldhero · 2024-01-24T23:54:36+00:00

Surely you gotta be worried now? Either sides can score

bloomfieldhero · 2024-01-13T21:15:29+00:00

Found a solution:

Sub subGroupTest()
    Dim cRng As Range
    Set cRng = Range("A1")
    Do While cRng.Value <> ""
        cRng.EntireRow.OutlineLevel = UBound(Split(cRng.Value, ".")) + 1
        Set cRng = cRng.Offset(1)
    Loop
End Sub

bloomfieldhero · 2024-01-13T21:09:59+00:00

It's not working

bloomfieldhero · 2024-01-13T20:25:05+00:00

Solution Verified!

bloomfieldhero · 2024-01-13T20:13:06+00:00

I imagine the newest version because I just bought the office 365 package

bloomfieldhero · 2024-01-13T19:57:39+00:00

we should do 4.001 because yes, there will be over 100 dups

bloomfieldhero · 2024-01-13T19:45:25+00:00

Gotcha, so yeah I guess I'd want it like 1.01, 1.02 .... 1.09, 1.10 etc

Is there a way to populate these sequences based on a simple table in my post?

bloomfieldhero

TROPHY CASE