Excel heed scratcher

potatolord · 21 Oct 2022 at 15:23

I'd just like to add that anyone who uses merged fields should be executed. Immediately.

I don't think that is unreasonable.

wildman · 21 Oct 2022 at 15:25

I would suggest a full re-install of Windows 98SE................

Dirk Diggler · 21 Oct 2022 at 15:28

potatolord said:
I'd just like to add that anyone who uses merged fields should be executed. Immediately.

I don't think that is unreasonable.

Cells. It's merged cells. :mad:

dlockers · 21 Oct 2022 at 15:38

sigma said:
Access >*

die in a fire

(no offence)

Sheff · 21 Oct 2022 at 16:01

Dirk Diggler said:
If I'd said it was a column on the left that I wanted on the right of the sheet, the thread would be a 20 pager by now.

The art of the Geek is dead here. Dead I tells ye.

*Hings heed in dispair*

Maybe the Geeks have transcended; Who uses data in Excel in 2022 for anything other than Power Query?

gpuerrilla · 21 Oct 2022 at 16:06

Sheff said:
Maybe the Geeks have transcended; Who uses data in Excel in 2022 for anything other than Power Query?

You dont use Power Pivot? Its all essentially the same tools as you get with Power BI. I only discovered it around 2017 but static formulas and even VBA now are not used as much for this very reason.

gpuerrilla · 21 Oct 2022 at 16:09

swillsy said:
Excel <> Database

But does it deal with blanks and null values? :cool:

Sheff · 21 Oct 2022 at 16:33

gpuerrilla said:
You dont use Power Pivot? Its all essentially the same tools as you get with Power BI. I only discovered it around 2017 but static formulas and even VBA now are not used as much for this very reason.

I do (sort of), just in Power BI! I don't really use Excel for much other than connecting Forms data in SharePoint etc. to Power BI these days, everything else is via API or SQL work.

Dirk Diggler · 21 Oct 2022 at 16:55

Sheff said:
Maybe the Geeks have transcended; Who uses data in Excel in 2022 for anything other than Power Query?

Don't give me all that, Mister Miss Mrs They *delete as appropriate.

This was a basic formatting query, and this is the forum that famously settled the jumbo jet on a treadmill conundrum.

We need to get back to basics, kids. It's all ebbing away...

gpuerrilla · 21 Oct 2022 at 17:00

Sheff said:
I do (sort of), just in Power BI! I don't really use Excel for much other than connecting Forms data in SharePoint etc. to Power BI these days, everything else is via API or SQL work.

I still see or work with people that use relic skills from ten or twenty years ago. Glad I taught myself some vba and the power tools at the time. There is so many tricks using all these apps and they can save you lots of time if you go looking!

Sheff · 21 Oct 2022 at 17:42

Dirk Diggler said:
Don't give me all that, Mister Miss Mrs They *delete as appropriate.

This was a basic formatting query, and this is the forum that famously settled the jumbo jet on a treadmill conundrum.

We need to get back to basics, kids. It's all ebbing away...

But did it solve the sandwich conundrum? I've forgotten now.

Sheff · 21 Oct 2022 at 17:56

gpuerrilla said:
I still see or work with people that use relic skills from ten or twenty years ago. Glad I taught myself some vba and the power tools at the time. There is so many tricks using all these apps and they can save you lots of time if you go looking!

I used to do a bit of vba and use macros quite a lot, but now I'm quite lucky in that most of my data sources have already been cleaned for me.

mrk · 5 Nov 2022 at 21:54

Take heed!