Calling experienced excel users

[balbec]

Lah di dah!

[Ambrose_McNulty]

I’m shocked that @TreatyStones doesn’t have IT goons for this kind of thing.

[balbec]

Not documenting his work. Amateur hour

[Fagan_ODowd]

Possibly the most riveting thread on the Internet

[PhattPike]

You just wait until the left & right wing Excel users come on here later after a few cans.

[EstebanSexface]

@EstebanSexface

sed -n ‘s:^(/[^/]{1,}/[^/]{1,}).*:\1:p’

you have no idea how sexy a solution this was

[cluaindiuic]

[EstebanSexface]

that raised a chuckle

[TreatyStones]

I’m trying to create a web query in excel to scrape data from a website table, however I’m being scuppered by a cookie prompt.

Any idea how to get it to auto accept or bypass the cookie prompt?

[Julio_Geordio]

@TreatyStones

Any idea how to get it to auto accept or bypass the cookie prompt?

You can change chrome so it will accept all cookies on your behalf. It’s in the settings. Not a great idea security wise I’d imagine

[TreatyStones]

@Julio_Geordio

You can change chrome so it will accept all cookies on your behalf. It’s in the settings. Not a great idea security wise I’d imagine

It seems to ignore the chrome settings, so I think it’s using it’s own built in browser as opposed to the machine default.

[TreatyStones]

I think there’s a method whereby you can pass something as part of the url, but I don’t know enough about to try something.

[Biff_Egan]

Power query?

[Rocko]

@TreatyStones

I’m trying to create a web query in excel to scrape data from a website table, however I’m being scuppered by a cookie prompt.

Any idea how to get it to auto accept or bypass the cookie prompt?

I think you’ll need to give the cookie details to the query so it gets that first.

I recall taking ages trying to get it to work before.

Something like this type of thing?:

How can I bypass a cookie agreement page while web scraping using Python?

There are a few examples on Power BI forums

[habanerocat]

I have some mixed-up data in excel, integers, that I want to add up.

The data is already physically divided on the sheet into three groups that I’m currently adding and I want to leave it in that format anyway. I know how to add it once it’s grouped in-line in columns.

However, now I want to add the data into two different groups. The data is all mixed up as is. Basically I need to tag the data easily into the two groups somehow. I could add the data one by one into the formula but there’s way too much to do it singularly. There must be an easier way to tag the data into two groups.

Any ideas?

[Rocko]

@habanerocat

I have some mixed-up data in excel, integers, that I want to add up.

The data is already physically divided on the sheet into three groups that I’m currently adding and I want to leave it in that format anyway. I know how to add it once it’s grouped in-line in columns.

However, now I want to add the data into two different groups. The data is all mixed up as is. Basically I need to tag the data easily into the two groups somehow. I could add the data one by one into the formula but there’s way too much to do it singularly. There must be an easier way to tag the data into two groups.

Any ideas?

Hard to know what you mean. What’s the criteria for the two groups? Put up a screenshot or an example there

[estebandaface]

You can select the cells you want select data then group, you can nest groups too.

You can do subtotals etc then on the group

[Julio_Geordio]

Go again there with your explanation. Its in three groups you want to leave in that format but also in two groups?

Give us a mar shampla

[habanerocat]

Perhaps this explains it.

I just did out that sample there now. Manually it takes a bit of time alright but not difficult as such.
Perhaps “grouping” (if that’s the right term) them might be faster alright if I knew how to do it.

[TreatyStones]

I’ve absolutely no idea what you are trying to do