Microsoft Excel

129K

Solutions

187

Articles & Videos

33K

Contributors

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

Refine results

I would import the file into Excel, and it could have three columns:

Word,WordCount,File

Thanks.

1915 views
Problems using Powershell and Active Directory?
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

i have this formula, the A1 contains another formula which results to some percentage value.

how can the below formula be simplified?

(CODE)

833 views

Hello,
I am trying to save to an excel file, information from a view in lotus notes. I have already created the excel template and just place the information I want in the correct cells. All this …

412 views

Hello,

I need a formula that will extract the MIN of the Opening Balance as fond in row 2 but for 5 days date range after the expense as shown in row 11.

I have uploaded a sample.

thank you…

512 views

Hi, Please Please help, I'm stuck and frustrated by what must be a simple thing to overcome! I thought Mr Google has the answer to everything, but today he's falling short!

I'm nearly finished …

139 views

so i have a list of names in column A

in columns B-BG i have all the corresponding companies for these people.

I need to basically make a new 1:1 relationship for each person and each company. …

616 views

Hello everyone,
I need to add a rectangle inside a chart and actually make it a part of this chart.
I'm doing this because I need to display this rectangle in an image box, and the only way to do so…

919 views

hello Excel experts, I am trying, for an attendance sheet,  to find the value for the second time of Peter (16:26:03), without any success. The first time of 08:32:00 has been found by …

314 views

Dear sir , i have a code, where it contains data , i need last updated time in a cell , so i have a formula, where it extracts date and time like this 23-FEB-2017 15:30:29 in one cell , but i need …

514 views

hi EE,

1. What is the best way to re-number column No (A) from 1 to visible rows please
2. e.g if I apply filter on Group1 with Yes rows. As it is now. in the sample file attached.
3. How to make…

619 views
NAS Cloud Backup Strategies
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

I set up am excel macro to pull in a spreadsheet of line item PO's and then it formats for our shipping system.   Im able to pull in the worksheet, name ranges etc.   The problem Im having is naming …

222 views

Hi EE,
could you help with attached sample excel and how to achieve this please?

Basically
1. How to get Final Column (G) the Consolidated result using formula please?
2. If any one of the group…

58 views

Hi Experts,

    Curious if someone has a macro that will capture and notate ALL changes made to a workbook and then email out out those changes made to an email address or distribution list?  For …

315 views

Hello,

Does anyone know how to run PROPER (Propercase) on an entire Worksheet in Excel (Does ALL columns)?

Thanks.

314 views

I found the below code and it works, but it adds extra space to the column height.  How can I remove the extra space?

(CODE)

1212 views

I am attempting unsuccessfully to format data in Excel as a table from Access.  I was hoping someone could tell me what I'm doing wrong:

First way:
(CODE)

Second way:
(CODE)


Third way:

1112 views

Hi All

I have data in a spreadsheet that is exported from a guest Wi-Fi system.  Users are required to enter a name and email address, or use a social media account to use the free Wi-Fi.  That …

617 views

I'm struggling to hide a range of columns in another worksheet.  The closest I've got is this code but that only hides them on the sheet I'm on:

Private Sub Test2()
Dim sws As Worksheet, dws As …

2524 views

Hi

I have an Excel 2007 workbook with macros in it. When I open the workbook I get the following prompt.
What I can't understand is the second message asking about links to another workbook …

612 views
U.S. Department of Agriculture and Acronis Access
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Hi,
I cannot unhide columns, D, E, F, to the attached file. Why?

516 views

I have a csv file that only has data in column A. I have an excel workbook that I copy column A from the CSV to this excel workbook that I use to populate a mailing list. Problem is right now I am …

814 views

Within the enclosed sample spreadsheet I have 3 records.  I'd like to find the average call time but not sure how.

Thanks for your efforts.

1813 views

I am using the code
(CODE)

It removes some lines, but not all dups.
For instance GR 3 12x9x6 has (2) rows. Based on the code, there should only be (1) row.
It should remove anything that is the …

3515 views

Hi everyone,

I have a column in an EXCEL spreadsheet made up of a date and time in the following format - m/d/time HH:MM.  For example, 1/1/2017 18:24.  I'd like to separate this into two cells.  …

429 views

When I run my code, I'm getting the following errors:

 Error: 1004
 ExportToExcel
 Application-defined or object-defined error

 Then if I click on OK, it continues through the code, but  then …

1017 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Microsoft Office
    (57,279)
  2. Visual Basic Classic
    (163,624)
  3. VB Script
    (36,403)
  4. Microsoft Applications
    (43,172)
  5. Spreadsheets
    (6,015)
  6. Microsoft Access
    (216,192)
  7. VBA
    (5,823)
  8. Microsoft Word
    (27,067)
  9. Programming
    (52,042)
  10. Visual Basic.NET
    (92,137)