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

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 …

1238 views
Announcing the Most Valuable Experts of 2016
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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 …

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

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

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


311 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

1231 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. …

59 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.  …

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

2115 views

I have VBA that will create an email when you click the generate email button. However, I have tried to make it pop up but it is inconsistent. How do I make this window pop up in front of any window …

39 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 an excel table with over 25000 rows. I need to check and be sure that "rank" increases to the "Next rank" by one...like grade levels.
animal    rank   next rank
cow          1        2
duck…

329 views

I'm looking for a code in Excel that computers Fibonacci results using two numbers then finding the greatest common factor between the two.   For example, if I typed in 13 in A1 and 17 in A2, the …

713 views

Hi

Can someone please advise the easiest way to colour rows which have a specific name in a column in excel. I have tried using conditional formatting but it only colours the cells not the full …

513 views

Hi Experts

i am searching for some sort of tool or way to give around 20 users possibility to work on shared directory which include MS office files

like word excel etc

we have multi shared…

29 views

Hi every one, I hope this can be done, I have this code below I need to update it so it saves the excel file but with PASSWORD.

Function ExsTexl()
Dim OutputFileName As String  
OutputFileName =…

422 views

Hello,

I'm wondering if someone can please help me with a VLOOKUP in an Excel File?

I have 2 datasheets. Stock and Datasource.

I'm trying to reference the Sheet Stock Column J to the Sheet …

1117 views

I do not want to see the total data points in the line graph, bit I do want to see the Total values in the data table.  Please see attached for my example.

In my example I want to remove 9, 15, and…

414 views

i need formula to obtain first 3 characters in a cell

thanks

224 views

The first tab of the attached is the master tab (created sheet by me) which has the all the information.

I need subsequent tabs generated based on the Member ID and all the relevant information …

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

I have an Excel file (Daily Asset Allocation Report.xlsx) and I would like an Excel formula or script which reports (in cell D23, "Start Here" worksheet) the date and time that another Excel file was …

1422 views

Hi All,

I have a large Excel spreadsheet with URL's to be imported into my web server. I need to change just the display text of the URL's to upper case.

Example

From: <a …

325 views

IF A HAVE AN NUMBER LIKE
560 I NEED WRITHE THE 0 IN THE ADJACENT COLUMN

EXAMPLE HERE

2937 views

Hello,

I need to write VB macro in Excel that would compare data in two columns within the same spreadsheet and highlight the row in red if the data is different. Please see attached a sample file.…

1728 views

I have the following formula

=IF(N32>1, IF(MIN(H32:H33, J32:J33)>N32, N32,MIN(H32:H33, J32:J33)), " ")

Which works unless H32:H33 is blank, which occasionally is the case.  I know MIN ignores …

518 views

We were assisted by EE in a question that made us place this question.  The insert that's reponsable is "it is actually possible to craft a non-addin PowerPoint macro-enabled file …

730 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