Microsoft Office

57K

Solutions

109

Articles & Videos

33K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Related Topics

  1. Microsoft Excel
  2. Microsoft Applications
  3. Outlook
  4. Microsoft Word
  5. Microsoft Access
  6. Visual Basic Classic
  7. Exchange
  8. Spreadsheets
  9. Windows XP
  10. Office / Productivity
Refine results

I am looking for a formula to put the "status" of a project from the worksheet Matrix (2) in the right row of the reference table (1). I tried index match but could not solve the problem.

In the ws…

612 views
Free Tool: Postgres Monitoring System
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

I have this formula in Q13:

=IF(OR($Q19="2: 1/4";"2: halv");0.225*1*0.25;0.225*1*0.5)

Then in Q19 I have a drop-down list with these values:

   -  
2: 1/4
2: halv

Note that the first …

1515 views

I have a worksheet with multiple sheets within. In column A (RUP) of sheet 1 I have check boxes (which aren't working). I need all of the data in each row from the main sheet to copy to the RUP sheet …

318 views

I have a daily routine that involves downloading a list that I need the cell contents of several columns to be populated into a comment for the cell in column A for the same row -- but also have the …

810 views

Hello,
I'm new in excel and vlookup, so consider me a near zero knowledge in vlookup and conditional formatting.

query:

Advisor:      Total  CSAT%
 Abhishek Deb                    77.92%
 AJAY KUMAR …

614 views

HAVE A COLUMN WITH DATA  NEED TO BE REORGANIZED

THIS WAY

5920 views

I'm trying to sum the number of dates with in a range for a given document type using SUMPRODUCT in the attached example spreadsheet.

I can get the formula to return the correct value for a single …

615 views

i need a formula to count the number of capital letters in an excel formula

38 views

Hi Experts,

I have a somewhat complicated issue that I think might be resolved with the use of a combination of an Index Match Array formula but can't see how to do it.  That said, there may be …

533 views

I need a vba loop to remove all instances of these shapes.
There are multiple, and for some reason and this code only removes one, not all.
I need to loop through until there are no more.


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

Loan amount = $61,000
Annual interest rate = 3.5%
Period of load = 30 years
Monthly payment = $0.00
Balloon payment amount at the end of 30 years = ?

I am trying to develop a schedule in Excel …

513 views

I have a list of phone service providers with their area code beginnings such as ( 307-650      : Provide: SPRINT SPECTRUM)  and  I want to find whether which one (who) is the phone carrier using 10 digit …

1413 views

I am trying to change shapes using VBA, but getting error on the  With Selection.Shapes("ARROW_US_EMEA_DC").
Can anyone help?

(CODE)

610 views

we have a spread sheet that stores unallocated IT stock (e.g laptops in stock, yet to be assigned to an end user). When an order is received the spread sheet is updated with the end user who the …

646 views

I NEED TRANFER A BIG DATA COLUMN

LIKE THIS SAMPLE   ANY HELP ??

719 views

Hello I am trying to keep in place or make it possible for my Excel chart to remain linked in my PowerPoint file. I have tested this with a download of a zip file and when I open the PowerPoint there …

749 views

Attached is a sample Excel file.   The Pivot WorkSheet has two Pivot Tables.  That obtains the data from the Data Worksheet. The Pivot Table on the Top has a Sum of Product 1 and Product 2 as well as …

210 views

I have a column that contains data formatted like this "nnnnn, text".  There is one sheet per month.  I wish to "fill" (color?) any cell that has identical data in any other sheet with a light …

452 views

Hi, I've been testing with users and recording their response times during the period of an hour and a little bit after that hour.  Now that i have the exact response times, I'm trying to figure out …

1843 views
Free Tool: Site Down Detector
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

I need to add a button that, if clicked, will
copy C2:G2 to the next empty line line.
then copies MOVES VIA, COUNTRY & CONSIGNEE into the new line.


313 views

I have been given a text file which I need to place the data into a MySQL table, Excel or Even Access.

The text file contains:
A | win
B | howdy
C | go home
D | have lunch
A | happy
B | sad

1236 views

I have a daily routine that involves downloading a list that I need the cell contents of column H (BRKR) and column I (CUSIP) to be populated into a comment for the cell in column A for the same row. …

614 views

We are trying to build and excel spreadsheet for our sales people on their commission they earn and are have difficulties putting in the correct formulas.  Here is what we are trying to accomplish.  …

217 views

Attached is a Workbook where Column B (Table1 Worksheet) is filtered and the results for Col A can be recorded in P1, Q1, R1, etc.  Currently, it's a bit of a work around to display the values of Col …

2118 views

Programming in PowerPoint 2010 VBA, an automatic bio slide maker.  The user selects up to 6 bios from a picklist, then the macro inserts photos and text elements.  Name, title, and bio text for each …

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

Microsoft Office

57K

Solutions

109

Articles & Videos

33K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Related Topics

  1. Microsoft Excel
  2. Microsoft Applications
  3. Outlook
  4. Microsoft Word
  5. Microsoft Access
  6. Visual Basic Classic