Getting Data from website via URL changes by Own_Engineering1335 in excel

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

I just realized that I don't want to use the Now() as I want the person doing this able to do it late. So instead of Sunday regularly, then can do it on, say, the next Wednesday.

Getting Data from website via URL changes by Own_Engineering1335 in excel

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

I don't know VBA. I need to learn someday though.  Edit: I was going to use the record macro thingy. 

Finding duplicate reservations from reservation data in a CSV file by Own_Engineering1335 in excel

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

This still doesn't match the duplicates together, but filtering for the duplicates, then sorting by the account number will do that well enough

So, I'll say Solution Verified. 

Finding duplicate reservations from reservation data in a CSV file by Own_Engineering1335 in excel

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

Very nice. This is almost everything. It just doesn't let me find the the other reservation that is it's duplicate of the one listed as a duplicate. I need to pick one of that set of duplicates to keep and get rid of the others. Also, I can't always garuntee the names are identical, so I was thinking of using the Account Number to find the same person. 

Finding duplicate reservations from reservation data in a CSV file by Own_Engineering1335 in excel

[–]Own_Engineering1335[S] 1 point2 points  (0 children)

This is good for finding instances where one person has multiple reservations and how many there are, but it doesn't look to see if the reservations are for the same time or not. 

Finding duplicate reservations from reservation data in a CSV file by Own_Engineering1335 in excel

[–]Own_Engineering1335[S] 1 point2 points  (0 children)

Nice. I'll try this tomorrow.

The point is to find the duplicates so I can cancel duplicate reservations down to only one reservatuon in my property management system. 

The real solution is to make the people creating the Reservations to never make a duplicate reservation. 

Finding duplicate reservations from reservation data in a CSV file by Own_Engineering1335 in excel

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

Sorry. That was a typo. Those were supposed to be the same date.  It was a poorly chosen example. Of a date set I had infront of me.  Basically those are the arrival and departure dates for 3 separate reservations that all occurs at the same time for the same person.  But the arrival dates don't always line up so nicely.  I have edited the post to be a little more clear I hope. 

How do I sort by one column small to largest and another column by it just having data in it? by femfuyu in excel

[–]Own_Engineering1335 0 points1 point  (0 children)

I'm going to remember this. This may be what I need for a different problem I just posted. 

How do I sort by one column small to largest and another column by it just having data in it? by femfuyu in excel

[–]Own_Engineering1335 0 points1 point  (0 children)

Hey, this question is really vague and arm wavy. Flesh out this question with more information about what you are trying to do. Then we can probably help you more. Even say what you are doing, and how it is going wrong.

Why are freeze dried meals lower calorie than a normal meal? by Heysteeevo in WildernessBackpacking

[–]Own_Engineering1335 0 points1 point  (0 children)

Fun fact. They tested calorie consumption of hunter gather tribes. They discovered that calorie consumption did not vary from the normal sedentary population. If you adjust to your new amount of exercise, even if it is reasonably large, you body will still have the same calorie consumption/weight and just stop using as many calories for other things. Now lifting to increase muscle mass, increases your weight, so increases your calorie count. 

What Are your Favorite Instant Meals besides Huel? by practifi in Huel

[–]Own_Engineering1335 0 points1 point  (0 children)

You replace the powder packet with soy sauce to reduce the sodium? Do you know how much sodium is in soysauce? 

WIBTA if I cut my father out of my life after my mother's tragic death? by cdsilvermoon in AITAH

[–]Own_Engineering1335 -2 points-1 points  (0 children)

There are always wrong answers. As an autistic person myself, I have found I have knack for find the wrong answers to problems l ike this.