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

NEED TO COUNT HOW MANY TIMES EACH NUMBERS REPEAT

THANKS !!

1313 views
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hi,

I'm basically looking to fill column 'D' in the first sheet (Data) based on the Rates sheet (second tab). If the the first three columns match in both cases then I would like to have the rate …

423 views

Hi
I'd like to create a schedule of 12 records (monthly payments) in the "paymentSchedule" Sheet for each record in the "sales" sheet.
If you add a new record in the sales sheet, excel should append…

1029 views

need to count this numbers in this order


any help please?

2624 views

Excel 2016/Win10:

in Excel, I have a white plus sign on my current workbook. I wouldn't mind; however, it prevents me from navigating from cell to cell via the arrow keys.  I shut down Excel & …

616 views

Do you know how to compute seconds into hours, minutes and seconds via an Excel macro?

I tried the following but got a syntax error?

Private Sub CommandButton1_Click()

232 views

I NEED TO KNOW THE TOP NUMBERS

327 views

I have data in this sheet


i need populate just the ord columns in new sheet like this



here the file
any help Please !

1612 views

I have a button called "Open Word" that opens a word doc from my excel sheet.

What I'm requesting is that when you open the word doc that the RFQ number that is on cell B3 populate the Doc Ref # …

231 views

I have a protected sheet (that emanates from a protected macro-enabled template) that requires the ability to sort.  Even though I have the Sort function checked to allow users to sort, it does not …

512 views
Free Tool: Subnet Calculator
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Experts,

I have made a pivot of the attached but I cant seem to manipulate it the way I want.
The raw data is organized as DD Amount ("draw down amount"), DD Date, Repay Amount, Repay Date, …

618 views

I want a macro that asks the user to select a folder, and then to automatically open all the xlsm files in that folder, and copy data from them. The data from the source files are always at the same …

1022 views

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 …

333 views

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 …

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

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

2832 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, …

421 views

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

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

813 views
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 …

1334 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?

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

522 views

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 …

724 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.

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

1020 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