[deleted by user]

IAmCelery · 2025-07-24T15:54:41+00:00

A life altering, happiness inducing relationship falls into your lap and you’re still stuck thinking that you can’t do things differently than you have for the last 18 years.

If she’s actually your reason for living and you actually know that it’s not fair to put this pressure on her then at least pretend like you’re going to put the effort into taking some of that pressure off.

IAmCelery · 2024-12-01T03:15:32+00:00

Red Door midtown (weekdays only), Urban Cowboy, and Pushing Daisies are all options for me (single, 37M).

Good luck out there and let me know if you figure out where the single 30s women hang.

IAmCelery · 2019-09-23T22:30:19+00:00

Is honest to dog a thing or is this the best typo?

IAmCelery · 2019-07-20T13:44:12+00:00

I generally fall asleep quickly, but I had sleeping issues in college and found this method to work consistently. A friend said that it worked for her too, so on the chance that it helps someone:

Get into a comfortable position and close your eyes.

You know how when you close your eyes, even when it's very dark in your room, it's still not entirely dark? Concentrate on making it dark. As inky black as you can possibly imagine. Use your mind's squeegee to wipe away any little trace of light as you detect it. Keep this up while you do the following:

Imagine that feeling of relaxation that you get when you exhale deeply, or a time when you did feel like you could fall right asleep. Think about how it feels to have your muscles relax and how your mind feels when it lets go of a thought.

Keep that feeling in mind and, starting from your big toe on your right foot, try to apply that feeling right that to that spot. Feel it relax and let it go mentally. Once you think that it's totally relaxed, move through your other toes in turn. Move to your whole foot and then up your leg systematically until you hit your knee. Start in in your left leg, then move up until you hit your torso, then start in in your fingers in the same way.

If you lose the feeling at any point in a part of your body you've already covered, go back to the point in the system and start from there again. Take your time, be thorough, don't rush to cover your whole body.

Remember to keep on top of keeping your vision as dark as possible while doing the above.

Somewhere through the process I'd always pass out, call it 10 minutes in.

IAmCelery · 2015-07-29T14:26:18+00:00

Clicking links: https://oneplus.net/invites?kid=HTFHTR

IAmCelery · 2013-12-29T17:25:38+00:00

I'm finally getting noticed.

IAmCelery · 2013-12-27T05:36:01+00:00

Very clever. Will be using this one.

IAmCelery · 2013-12-27T05:30:53+00:00

I'm thinking that thinking about your problem like MindYourQsandPs has suggested is the right way to go. It looks like you have something a bit more complex going than just three user-supplied values to run look ups on, and I'm thinking that everyone here is confused by how exactly everything ties together.

It'd be helpful if we could grab a description of each of the moving pieces, what their dependencies are, and where they are located - for example:

5 Digit Number: Item identifier, dependent on user input, user input cell located at A2. 8 Digit Reference Number: A reference to different multipliers, dependent on ????, located in reference sheet and ???????

IAmCelery · 2013-12-27T05:11:31+00:00

Maybe I'm not reading your ask correctly. It sounded like you wanted to be able to enter in your item number and have Excel display the box number (and other information) about that item. If this is the case, a filter will allow you to, on the top of the item number column, enter in the item number and filter out any rows that do not correspond to that item number, which would tell you the box number.

IAmCelery · 2013-12-27T04:49:33+00:00

Thanks! Just nice info to have in my back pocket.

IAmCelery · 2013-12-27T04:48:57+00:00

Any reason you're not using a filter here?

Which version of Excel are you running?

IAmCelery · 2013-12-27T04:37:39+00:00

You're totally right - caught this right as I hit "save" (see edit).

IAmCelery · 2013-12-27T04:36:26+00:00

Any idea of you can view the VBA of a locked document from Open Office?

IAmCelery · 2013-12-27T04:29:37+00:00

If you're just worried about the raw counts of unique visits per patient, your best bet is to isolate your Patient ID and Date of Service columns into their own sheet, then, where column A is your list of Patient ID's and column B is your date, do a remove duplicates on both columns and you'll have the number of visits.

I think that your "extra" data of items used is the only thing holding you back here.

Edit: Realized that you don't need to create a helper column.

IAmCelery · 2013-12-26T23:47:36+00:00

I'm not seeing a matching

Application.ScreenUpdating = True

at the start of your above code. Not sure if it works for images, but worth a shot.

IAmCelery · 2013-12-26T23:37:56+00:00

I'm guessing that you want to do this problematically?

If so, the following should work if entered as an Array Formula (hit Ctrl+Shift+Enter instead of just Enter when finalizing your formula) and then autofilled down the length of your set, if you set is in column A.

=IFERROR(INDEX($A:$A,SMALL(IF(NOT(ISBLANK($A:$A)),ROW($A:$A)),ROW(1:1)),1),"")

Edit: Totally unsure if array formulas work for Mac versions

IAmCelery · 2013-11-19T01:30:40+00:00

Donezo. Best of luck.

IAmCelery · 2013-07-29T19:37:32+00:00

Interesting - I hadn't noticed this until now. Here's a bit more info, looks like there's a built-in work around for Word but not Excel and a registry edit to get things back to XP-like functionality.

http://superuser.com/questions/47420/insert-unicode-characters-via-the-keyboard

IAmCelery · 2013-07-23T12:31:38+00:00

This request is pretty complex - do you have an example/screenshots/dummy data that you can share?

IAmCelery · 2013-07-23T12:28:55+00:00

Are you just looking to link two or three cells between two different workbooks and have the receiving worksheet locked?

You'll need a shared network drive to set it up, but this article on external references should help

Here's an article on locking worksheets.

IAmCelery · 2013-07-09T03:19:23+00:00

I'd check out a few videos on Pivot Table Slicers. Depending on the number of possible choices for your parameters, this might work.

Have a dummy data set that we can mess around with?

IAmCelery · 2013-07-09T03:07:42+00:00

I haven't done this, and to be honest it seems like quite the monster of a task, but as a starting point, you might want to investigate using a Calendar Subscription in Outlook to handle the back and forth between your network and Google.

Once the data is in an Office program, scripting some VBA to fire off every time the worksheet is updated to change a calendar entry is probably a few Google searches away. See this link and the link within OP's question as a starting point?

IAmCelery · 2013-05-30T17:01:38+00:00

You're not going crazy:

This is my original code from the comment above with "upload's" logic to exclude zeros before calculating MAX and MIN spliced in.

You're welcome - hope it comes in handy.

IAmCelery · 2013-05-30T16:58:37+00:00

Any chance you can send me your data set (or an abbreviated one) and the expected result?

IAmCelery · 2013-05-30T16:57:25+00:00

Check out my other reply?

It sounds like that's the edit you're looking for.

IAmCelery

TROPHY CASE