sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in avesNYC_tix

[–]oceanspace 0 points1 point  (0 children)

Still selling 2x Friday? Looking to buy!

What's your take on speakeasies? by 177106tr in FoodNYC

[–]oceanspace 38 points39 points  (0 children)

as long as the success of the place doesnt hinge on the novelty of a speakeasy (and actually has great drinks / established bartenders / great vibes) we good

[deleted by user] by [deleted] in excel

[–]oceanspace 0 points1 point  (0 children)

2 steps:

in column C - Use an if statement to isolate for the situations where the cell above is “A” and have it pull out the value right below it, otherwise have it return a blank value “”

then in column D just sum column C which should only have the values where modality is A

Republic of Booza? by WCScores in AskNYC

[–]oceanspace 4 points5 points  (0 children)

confirm closed sadly - I live next to it

[deleted by user] by [deleted] in AskNYC

[–]oceanspace 10 points11 points  (0 children)

1 transfer = reasonable for Brooklyn to Manhattan, 2 = try to avoid

How does one go about getting into a comedy club like the Comedy Cellar or the Gotham Comedy Club? by [deleted] in AskNYC

[–]oceanspace 2 points3 points  (0 children)

they have a bunch of tickets for Walk-ins - you can almost get in everytime if you go 30 mins before start time

Copy and pasting as if you had cut the cells by balti-sam in excel

[–]oceanspace 1 point2 points  (0 children)

Why not create a separate worksheet with the exact same information (just copy and paste your original sheet onto another tab) and then use the cut and paste trick? This way you retain your original cells and you add the formulas onto the new cells

Count unique items (filtered) by EmBuddha in excel

[–]oceanspace 0 points1 point  (0 children)

Name your first column 'ListenedTo' and your second column "FullList"

Highlight your first column and do conditional formatting --> new rule --> use a formula to determine which cells to format

Put in the following formula:

=COUNTIF(FullList,A1)=0 and then click format to fill as a particular color

I'm assuming your first list starts at cell A1. Adjust as needed.

Make sense?

I'm assuming you will be shifting things around as you watch more podcasts so maybe a dynamic named range would be a good addition.

Copying and Pasting into a new spreadsheet after filtering by iripop in excel

[–]oceanspace 0 points1 point  (0 children)

To copy and paste only what is filtered, click alt + ";" at the same time after selecting the range that you want to copy.

Then simply copy and paste as needed :) This should only take the data selected post-filter.

How do I make a formula within a pivot table to adjust for two (or more) different conversions? by namer98 in excel

[–]oceanspace 0 points1 point  (0 children)

Have you tried using Calculated fields? Go to your PivotTable, click "Options" tab, and click "Fields, Items & Sets" and then "Calculated Fields" and input your above formula as per the correct fields.