Microsoft Excel

129K

Solutions

192

Articles & Videos

37K

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.

Related Topics

  1. Microsoft Office
  2. Visual Basic Classic
  3. VB Script
  4. Microsoft Applications
  5. Spreadsheets
  6. Microsoft Access
  7. VBA
  8. Microsoft Word
  9. Programming
  10. Visual Basic.NET
Refine results

I have a spreadsheet that list campaign donations sorted by the organization.  Some organizations have hundreds of rows which makes my loops very inefficient when I have to loop thru an entire …

325 views
Free Tool: Path Explorer
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Hi Experts,

I have recently switched from MS Excel 2013 to 2010 becasue of which formulas like NA, NUMBERVALUE are not working.



Any help how to get the above formulas working into Excel …

620 views

I'm running a code that has always worked, but now when I try to run it, it eventually balks, throwing the error you see in the title. Sometimes on the 30th sheet, sometimes on the first. Is it a …

229 views

How can I get the Y value of a line in VBA if I know the X value. I need the value of the line that excel creates because of the curves excel adds when it smoothes the lines between points.

Thank …

2826 views

I would like to copy/paste some data into excel, type it or import it, and prevent Excel from converting it. For example, some numbers appear as "9.00801E+12" or whatever... also, a string of zeros, …

419 views

I have time stamp field and would like to count daily on Pivot table.

515 views

When I send the SQL UPDATE statement below from Excel to Access via ADO I get 'no value given for one or more parameters'.
BUT when I run the query in the Access query window it does not give me that…

811 views

I have several named ranges in a template.  I have built into the template an ability to copy and paste non-contiguous cells from one template to another template (both are the same template, just …

527 views

Trying to use a simple formula

=SUM((K29:P29)/H29)

K29-0.0
L29-0.0
M29-0.0
N29-0.0
O29-6.0
P29-0.0

H29-8

Trying to get an average...

Get a value error?

623 views

I'm trying to perform an AutoFilter on a given set of Data, and with those Visible Rows, copy/paste the unique items from one Column to a Second Column on the same page.

The code would appear to be…

518 views
On Demand Webinar - Networking for the Cloud Era
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Hello all:
I am creating a vba script in Excel that need to retrieve data based on certain critieria.  What I want to do is to first load the data in an array (or collection) and then be able to …

721 views

Hi Experts using excel 2010

Need a macro where the user can select key file from there desktop and bacl them up to any available drive other then the c:\..using a user form interface.

313 views

I have an Excel Template file that is protected and includes several combo box lists in an excel table format.  In addition, there is extensive code that expert Martin Liss helped me figure out, as …

1014 views

User is unable to open any excel files from outlook 2013 (excel installed on her machine is 2013 also) once she double clicks on the excel file attached she gets the error - (see attached). She can …

640 views

After great work by 4 EE Pros, Brad Yandt, Professor Jim Jam, Ramin and Roy Cox, I got a great little Countdown Timer that I can use.  As generally the case, the  more I worked with this Team of …

2661 views

Hello.
I need an Excel solution for followinf task.
I have 3 colums.
Colum A have a list of numbers whtch is need to detect MATCH when I input a number on ccolum C.
Colum B have a list of numbers …

821 views

This is the formula for printing out the result of a summation of number of question marks in a range:

https://www.extendoffice.com/documents/excel/2862-excel-count-question-marks.html#a1

But in…

210 views

Hi
I am trying to connect to a SQL database using the following JavaScript code. I get an error at the line marked "ERROR"
What am I doing wrong?. Should this part of my ExcelWebAddIn rather be in …

722 views

Hi Guys,

I bought this template online and its exactly what i am looking for, however i dont know how to change the dates to 2017, any ideas?

617 views
Free Tool: Port Scanner
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

need make an query to the needed numebrs
and populate  the sheet with the selected data from data column

617 views

I need a formula to find the number of working days from due date to Today  - if today is greater than Due date.  I've used WORKDAY okay in the Due Date column, but not the NumberOfDaysOverdue column.…

410 views

Let's see if I can explain this.  On the CPC Tab on cell B3 I enter the RFQ number and the sheet populates the information based on what is being entered in cell B3.

It works great but in some …

620 views

this time i need find the duplicates but in every 26 set
like the example here

Any help please !

3222 views

Is it possible when you open up a workbook that a chart will be displayed for about 5 seconds?  I thought it would be cool to have popup to display the status of the project for example.

I wanted …

820 views

Hello,  trying to compile a formula to evaluate the following.  If Sheet4, A1 =1 and sheet1 bz1="0Z", then sheet1 by2=8 and sheet1  bz2="PM" if sheet1 bz1="6z", then sheet 1 by2=2 and sheet1 bz2="AM",…

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

Microsoft Excel

129K

Solutions

192

Articles & Videos

37K

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.

Related Topics

  1. Microsoft Office
  2. Visual Basic Classic
  3. VB Script
  4. Microsoft Applications
  5. Spreadsheets
  6. Microsoft Access