Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 139K Content
  • 12K Contributors

Expert Spotlight
John TsioumprisSoftware & Systems Engineer

I am passionate software developer and also a competent Systems administrator.I enjoy learning new things and challenges...

Solution

Determine which record has more than 32767 characters

bybfuchs
45
Hi,

I am trying to link a CSV file to my Access database file and it gives me the attached error.…
Article

How to quickly and accurately populate Word documents with Excel data, charts, and images (including Automated Bookmark generation)

32
How to quickly and accurately populate Word documents with Excel data, charts and images
Video
Creating an Efficient Dashboard in Excel

Creating an Efficient Dashboard in Excel

1
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will …
Courses

Microsoft Excel 2016 Data Analysis

Beginner
We will begin this course with an introduction to functions and formulas, including logical and …

Microsoft Office Excel 2019: Part 1

Beginner
This course introduces students to Microsoft Office Excel 2019 and discusses performing …
Post

The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Solution

Macro to run only if the data is present in Criteria Range

66
Hi Experts,
I am using the following macro to apply advance filter and fetch the data.
Sometimes …
Solution

Restructure Sheet Columns

byMelbut
63
Experts,

I need help rearranging the column headers on all the sheets to match the original Quote…
Article

Getting your EE Ranking statistics in Excel

byQlemo
90
The code described here does no longer work. Please see replacement Article:
Solution

VBA to organize/filter a pivot table in Excel

byHannah
60
There is a tab data in excel of departments, regions, products, customers, and purchases for the …
Solution

Add/change fields in Userform

byMelbut
76
Experts,

I need help making the following changes to my userform.

1. Add  a Discount % field
Solution

VBA Dictionary created from an Excel spreadsheet.

24
After I identify a certain row in a spreadsheet, I would like to copy the value in column "S" from …
Solution

Adds rows to the Sheet Automatically

60
Hi Experts,

I am using the given macro to add 10 rows at the end of the database "Main1DB"…
Solution

Excel Flip/concatenation

47
I have an excel file of approx 1 million rows.  There are only three columns with the items …
Solution

Excel: formula if value start with

23
Hello experts,

Could you please help me to set up the following formula:

If A1 value starts …
Article

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

21
by Patrick G. Matthews


Introduction

VLOOKUP is a tremendously useful function …
Solution

Excel Zone Expert Discussion, Number 37

bybyundt
185
This thread is for general discussion about all things related to the Excel TA and its experts. Both…
Solution

Update existing VBA script to Breakdown Data and Transferring to another sheet

byMelbut
58
Experts.


I need help rewriting the current VBA script that will take the quote data from the …
Post

Ever needed to implement drag and drop between two listboxes…

Ever needed to implement drag and drop between two listboxes on a userform?

I have added a new …
Solution

Dymanic Mutliple List Selection - VBA Excel - Userform Query

29
Hello Team,

I request your kind support for my below example related with Vba Query on Userform.…

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more