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.

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

Hello,

I'm sorry for asking the solution again as the last one did not work as required, but I thank Shams for helping me understand the way it is done. :)

But the problem stays as it is.

So…

47 views
Free Tool: IP Lookup
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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 had this question after viewing Export CSV from Excel and exclude rows based on cell value …

320 views

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

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 …

516 views

Hello everyone.
Please I really need help.
I have a matrix that I want to square (multiplying it by itself).
and then I'm gonna add the value of each row of this matrix, and then add the value of …

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

617 views
Networking for the Cloud Era
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

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

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 …

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

I have list of outputs. Say around 100,000 rows
They give results of a calculation.
The result is between say 1 and 100 on one axis and 0 to 50 on another , with 3 or 4 decimal places

I need to …

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

212 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

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
Show more content
201506-LO-Top-001

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.

Related Topics

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