Excelguru Help Site - Bob Phillips

Knowledge Base Articles By Category

Access - ADO (4)

Access - SQL (4)

Access - VBA Programming (10)

Downloads - Games (1)

Downloads - Learning Aids (11)

Downloads - Utilities (9)

Excel - ADO (4)

Excel - Charts and Data Visualization (1)

Excel - Formulas (8)

Excel - General Tips (36)

Excel - Interactive Pages (9)

Excel - PivotTables (12)

Excel - Power Query (3)

Excel - PowerPivot (7)

Excel - SQL (4)

Excel - UDF (7)

Excel - User Interface Customization (2)

Excel - VBA Programming (49)

Excel - WebApp (4)

Internet Explorer - VBA Programming (1)

Novell Groupwise - VBA Programming (2)

Other - General (1)

Outlook - General Tips (5)

Outlook - VBA Programming (7)

PDF Creator - VBA Programming (11)

Power BI (3)

PowerPoint - VBA Programming (7)

Publisher - VBA Programming (7)

Syndicated Articles (7)

Word - VBA Programming (8)

Bob Phillips

There is no available content written by Bob Phillips

Recent Forum Posts
Please assist with a split text to columns formula

Thank you, but I am looking for a formula that will do what the wizard does. Splitting needs to be done as items are selected....
Elso Today, 01:28 AM
VlookUp Crawls

In cell B2 of Sheet1:

Code:

=TEXTJOIN(",",TRUE,FILTER(Sheet2!$A$2:$A$4,ISNUMBER(SEARCH(" " & TRIM(A2) & " "," "

...
p45cal Yesterday, 06:15 PM
Please assist with a split text to columns formula

Use Text to Columns:

and finish up with:

...
p45cal Yesterday, 05:20 PM
Invoked Custom Function - SQL Queries

I have tried with this code but it does not run the query for each row (though it does not recognize the [Query] column)

Code:

NPowerQuery = Sql.Database(dBaseIP,

...
umutkoyun Yesterday, 07:58 AM
VlookUp Crawls

I have read and will follow all the rules and guideline...

Please let me know if I have missed something, here's where I have posted my...
asdf99 Yesterday, 06:58 AM

All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Version 4.2.5
Copyright © 2022 vBulletin Solutions Inc. All rights reserved.

Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.

Gravatar by 1e2.it