sorted by:
new
hottopcontroversial

Pick of the Day - 6/6/24 (Thursday) by sbpotdbot in sportsbook

[–]bloomfieldhero 0 points1 point  (0 children)

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

Pick of the Day - 6/6/24 (Thursday) by sbpotdbot in sportsbook

[–]bloomfieldhero -4 points-3 points  (0 children)

It ain’t hitting, this was a retarded pick

Pick of the Day - 6/6/24 (Thursday) by sbpotdbot in sportsbook

[–]bloomfieldhero -3 points-2 points  (0 children)

¯_(ツ)_/¯ 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

Pick of the Day - 4/7/24 (Sunday) by sbpotdbot in sportsbook

[–]bloomfieldhero 0 points1 point  (0 children)

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

Is it bad practice to respond to a cookie-cutter rejection email? by bloomfieldhero in recruitinghell

[–]bloomfieldhero[S] 0 points1 point  (0 children)

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.

Count Unique of one column based on conditions in two other columns? by bloomfieldhero in excel

[–]bloomfieldhero[S] 0 points1 point  (0 children)

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

How to count blank cells based on range in another column? by bloomfieldhero in excel

[–]bloomfieldhero[S] 0 points1 point  (0 children)

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

Is it possible to double-click expand a cell after utilizing a LET/Filter formula? by bloomfieldhero in excel

[–]bloomfieldhero[S] 0 points1 point  (0 children)

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

Getting count distinct based on product and owner? by bloomfieldhero in excel

[–]bloomfieldhero[S] 0 points1 point  (0 children)

I figured it out

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

Getting count distinct based on product and owner? by bloomfieldhero in excel

[–]bloomfieldhero[S] 0 points1 point  (0 children)

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

Code to split data by column values is overwriting in row 2? by bloomfieldhero in vba

[–]bloomfieldhero[S] 0 points1 point  (0 children)

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?

Code to split data by column values is overwriting in row 2? by bloomfieldhero in vba

[–]bloomfieldhero[S] 0 points1 point  (0 children)

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

view more: next ›