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
  • 143K Content
  • 12K Contributors

Expert Spotlight
Developer

50+ years in computers
EE FELLOW 2017 — first ever recipient of Fellow accolade in EE history
EE MVE 2015,2016,2018
EE CERTIFIED GOLD EXPERT

Troubleshooting Solution

Auto Generate Button to generate number combination from a given line.

bysimon
181

Auto Generator button and Clear All


Creation  of MG Sets two tab to inputting manually   4 to  10

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
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…
Article

Getting your EE Ranking statistics in Excel

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

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

21
by Patrick G. Matthews


Introduction

VLOOKUP is a tremendously useful function …
Article

Easy Ways to do Hard Things

1
When adding new VBA features to a workbook, some parts may be difficult but you struggle through it because it's important to you or to someone you're helping. During that struggle you may say to yourself that "I wish I could find an easier way". Hopefully this article will help you do that.
Article

Modern Active Directory part 2/2

This document presents the Modern Active Directory project, which aims to bring a more modern view on your Active Directory, whether to view key indicators or to perform advanced searches in a simple way. With this PowerShell module that accesses your Active Directory in read-only mode, ...
Article
Oh no

A Guide to Writing Understandable and Maintainable VBA Code

14
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Troubleshooting Solution

Excel Zone Expert Discussion, Number 33

353
This thread is for general discussion about all things related to the Excel zone and its experts. …
Troubleshooting Solution

create the buttons in AQ AR AS and AV AW AX 3nc

46

29259480a.xlsm   3nc


1-create theses 2 buttons in AQ AR AS  and  AV  AW AX be adjuested for 3n 

please

Troubleshooting Solution

create the buttons in  AQ AR AS  and  AV  AW AX  3nc

32

29259480a.xlsm 3nc


1-create theses 2 buttons in AQ AR AS  and  AV  AW AX be adjuested for 3n 

please


Troubleshooting Solution

create key for digits 4n in data both times

35

29258783.xlsb 4n



1-Capture the exact DIGIT repeat no matter the position then show the digit in the

Troubleshooting Solution

Macro to compare 2 files data and display results by adding column at the end of the 2 files

40

Macro to compare 2 files to check if there is any matching data:


 File A

 

HeaderA1
HeaderA2
HeaderA3
Troubleshooting Solution

Adjust DMU and DMD 4n

58

29254567.xlsb  4n


1-columns I to N need be adjusted


2-Digit Matrix UP  , Digit Matrix Down are not the

Post

Once upon a time at a core conference this …

1
Once upon a time at a core conference this
Troubleshooting Solution

Update Excel worksheet tabs with data using VBA

29

Experts, 

When a response is submitted via a form, my spreadsheet has a tab labeled "Responses" that

Troubleshooting Solution

Looking for  duplet and triplet buddies while directly clicking on the latest draw numbers

bysimon
63
" Click directly on the latest draw number could display buddies and triplets" in a new tab , called
Troubleshooting Solution

Excel VBA: unable to run my add-in

14

Hello experts


Today I wake up and I have the following error message:



And I have:


My PowerPoint add-in

Troubleshooting Solution

Generating Triplet number combinations in MG sets tab and if Quadruplets and Quintuplets button added in MG TAB

bysimon
44

Automatically generating Triplet combinations in the MG Sets tab


Dedicate top row of MG Sets tab to

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more