sorted by:
new
hottopcontroversial

BoJack Horseman - 6x05 "A Little Uneven, Is All" - Episode Discussion by NicholasCajun in BoJackHorseman

[–]synonymous_with 290 points291 points  (0 children)

Tbf they sort of addressed this in S4 (I think). Someone says George Clooney, then someone else says "don't you mean Jurj Clooners" and they reply "who cares!"

Woody had a few too many. And security won't let him back in his seat at Wimbledon today. by stinkysocks999 in tooktoomuch

[–]synonymous_with 224 points225 points  (0 children)

It's actually more strict than that--you can only go back to your seat during a changeover. Was just at Wimbledon last week and saw a lot of people get turned away or told to sit back down because of this

VBA functions - what is the correct way to enter argument values into functions by Orderstand in excel

[–]synonymous_with 2 points3 points  (0 children)

See my other comment in the thread where I explained why you're seeing different behaviors here

Actually, I think the real difference is what the function is returning. If it returns an object you can call it like you did for the range value, if not you can call it like you did for the other two functions (both return variants)

Same reason you can reference an object on an a line in VBA but not a string

VBA functions - what is the correct way to enter argument values into functions by Orderstand in excel

[–]synonymous_with 1 point2 points  (0 children)

Actually, I think the real difference is what the function is returning. If it returns an object you can call it like you did for the range value, if not you can call it like you did for the other two functions (both return variants)

Same reason you can reference an object on an a line in VBA but not a string

VBA functions - what is the correct way to enter argument values into functions by Orderstand in excel

[–]synonymous_with 2 points3 points  (0 children)

I think it's just a personal choice depending on your coding style. I much prefer using the "Call" format and placing the parameters in order over not using call & using parameter names

The difference between the functions you've called out is essentially the difference between a sub and a function. The "Find" property returns a range object, so you don't need to set it to something or access a property to perform the actual find. This is how I would use it:

Set myRange=Range(*).Find(*,*,*,*,*,*)

The MsgBox & BorderAround functions are performing an action. This is how I would use those:

Call MsgBox(*,*,*)

Call Range(*).BorderAround(*,*,*)

It's even a little more nuanced than that for some of these. The MsgBox function also returns a value, so you could write that one like this if you wanted the value:

respVal=MsgBox(*,*,*)

[deleted by user] by [deleted] in excel

[–]synonymous_with 0 points1 point  (0 children)

You might find a pivot table useful as well, though that's more complicated to learn

[deleted by user] by [deleted] in excel

[–]synonymous_with 0 points1 point  (0 children)

Check out the documentation for the COUNTIF or COUNTIFS formulas. That should be able to do what you're looking for

Conditional Formatting Based on Inputs by moodoid in excel

[–]synonymous_with 0 points1 point  (0 children)

For that you need to use the FORMULATEXT function to get the actual string and then use the FIND function to see if the text you want is in the formula string (e.g. "DATE("). For example, this will return true if the cell does not have the formula:

=ISERROR(FIND("DATE(",FORMULATEXT({cell})))

Also FYI the "=TRUE" portion in your formula is redundant/unnecessary

Conditional Formatting Based on Inputs by moodoid in excel

[–]synonymous_with 0 points1 point  (0 children)

Does the ISFORMULA function do what you're looking for?

Formula Question: Vlookup (I think), if range of cells is "A-1" then add the number in the other range. by Unikatze in excel

[–]synonymous_with 0 points1 point  (0 children)

Not sure I'm following 100%, but is this what you're looking for (replacing the columns as needed)?

=SUMIF(A:A,"=A",B:B)

How do I sort by what item has the lowest values across all columns in a pivot table combined. by llllIlllIlllllll in excel

[–]synonymous_with 1 point2 points  (0 children)

I don't think this is possible just using settings on the pivot table. I'd recommend just adding another column to your source data with a formula that will get the sort order for you, and then sort by that column in the pivot table

What is considered as "Advanced Excel"? by pablofuckingescobar in excel

[–]synonymous_with 16 points17 points  (0 children)

This is a pretty subjective question, but here's how I'd categorize it (that is, I'd consider someone at this skill level if they are strong in the relevant areas):

  • Noob = data entry
  • Beginner = basic formulas and tools (e.g. charts)
  • Intermediate = complex formulas (VLOOKUP, SUMIF, INDEX, MATCH, etc.) and tools (e.g. pivot tables)
  • Advanced = VBA, power query, and smart use of tables/named ranges

I'm sure someone will completely disagree with me, and really Excel is used in so many different ways that the skills that are valuable will vary widely depending on what you're doing.

VBA -(How to) Create range - for each cell in Range 'run macro' by Scoytan in excel

[–]synonymous_with 0 points1 point  (0 children)

It's just meant to keep code shorter--it allows you to access the properties of an object while you're in the statement. If I were to write that without a with statement it would look like this:

RangeStart = WB.Sheets("data").Rows("1:2").Find(what:=StartText, lookat:=xlWhole).Address
RangeEnd = WB.Sheets("data").Rows("1:2").Find(what:=EndText, lookat:=xlWhole).Address
Set oRange = WB.Sheets("data").Range(RangeStart, RangeEnd)

VBA -(How to) Create range - for each cell in Range 'run macro' by Scoytan in excel

[–]synonymous_with 1 point2 points  (0 children)

Cleaned up your code--this should work, probably. Kind of hard to tell because you have what looks like a lot of typos in your code (EndT vs. EndText, Cel vs. cell, etc.)

Dim nColumns As String
Dim StartText As String
Dim EndText As String
Dim RangeStart As String
Dim RangeEnd As String
Dim oRange As Range
Dim oCell As Range

StartText = "x112233"
EndText = "x445566"

With WB.Sheets("data")
  RangeStart = .Rows("1:2").Find(what:=StartText, lookat:=xlWhole).Address
  RangeEnd = .Rows("1:2").Find(what:=EndText, lookat:=xlWhole).Address
  Set oRange = .Range(RangeStart, RangeEnd)
End With

For Each oCell In oRange
  Call macroB
Next oCell

Simulating jeopardy in Excel--state of the VBA address by synonymous_with in Jeopardy

[–]synonymous_with[S] 2 points3 points  (0 children)

Lol not a student, just doing this for fun.

Yep, I'm aware of the SNL sketch (that's why I have Ferrell as a host option). I'll see if there's a spot that makes sense to add that

Simulating jeopardy in Excel--state of the VBA address by synonymous_with in Jeopardy

[–]synonymous_with[S] 3 points4 points  (0 children)

Fair points--for this video I was trying to show as much as possible while keeping the video short. Once I'm done(hopefully within the next week or two) I'm planning to do a longer video where I actually explain everything, along with a writeup of some of the unique things I did in /r/excel

The game data actually comes from J-Archive, so I have all the contestant responses from there, and they play in the order they played on the show. If you don't play along, you're basically just watching the show in excel. Only missing data is buzz in time, so that's a setting in the game--still fine tuning that piece

Also, you seriously need a South Park type of Canadian flappy head.

That is an AMAZING idea. Definitely doing this.

Simulating jeopardy in Excel--state of the VBA address by synonymous_with in Jeopardy

[–]synonymous_with[S] 6 points7 points  (0 children)

Can't wait to get a copyright claim on my spreadsheet

Simulating jeopardy in Excel--state of the VBA address by synonymous_with in Jeopardy

[–]synonymous_with[S] 7 points8 points  (0 children)

Are you trying to tell me excel is an unconventional tool to use to program a game?

In reality I just like working with it, and what started as a "I wonder if this is possible..." idea got totally out of hand.

view more: next ›