1. Y

    Formula to populate either "Up" or "Down" based on location of entry in Column A

    I have three columns. Only one cell in column A will have a value, which will be "Active". Column B is locations. In column C I'm trying to get anything that at or below the "Active" indicator to populate as "Down" and anything above the "Active" marker to populate as "Up". <tbody> Minn Up...
  2. D

    Speed difference in formula calculation if I use a static "indicator" column for my IF statement criteria (see pic)?

    I created a super-simplified pic of my Q below, but TLDR: I often want dozens of formula columns to calculate ONLY if a certain (sometimes-complex) criteria is met, so I use a standard =IF(criteria , if_true , if_false) syntax. Now because that criteria can often be complex, in order to keep my...
  3. S

    Search Rows For Indicator, Return Certain Values

    Hi, The Data I have covers 100 Rows and 266 Columns. The first 133 columns are going to simply contain either an “N” or a “Y” indicator. Ineed a Macro that I can attach to a button that when pressed, will go through the rows and search for the “N” indicators. If it finds an “N” indicator, I...
  4. D

    Making Comment Indicator Transparent

    Hi all Question relating to Comments using Excel 2010. I have a sheet that contains a huge amount of comments making the sheet itself very difficult to read. Is there anyway of making the comment indicator transparent? Or This there anyway of not displaying the comment indicator but the...
  5. P

    Progress Indicator

    Hi all, i need a progress indicator so that to appears on screen the percentage till end of any code which i run. Note that i cannot create the "User Form" and so if is possible to create it too. Thanks in advance
  6. H

    Active Cell Indicator Disappearing

    Hello! I've had an issue plaguing me for a while now; Most of the time, when I open my workbook, the highlighted border around my active cell disappears. I suspect that it is caused by my workbook_open() code, but any time I try to debug it, the issue goes away. Whenever I open the...
  7. E

    Chart Help!

    I was wondering if someone could help me! I want to create a simple chart which will show a range (1 to 5) and then where four different values fall on this range. To complicate things slightly I want to put two boxes at either end of the range in which will be a descriptor of what 1 looks like...
  8. P

    Progress Indicator

    Hi all, i prepared a VBA command by which i issue management accounts and it takes around 20-30 seconds when i run it. I would like to add a progress indicator in percentage into the above command, so that when i run it to appear this information on screen, e.g. Management Accounts in...
  9. T

    Ranking results using two values and specific criterea

    I have a list of two different results that i have to Rank regionally and nationally Where Column F (Region) is the region indicator and Column J (TSRs) is the first result and Column K (ACV) is the second result. For Column J's (TSRs) ranking I will have a great deal of ties. I would like...
  10. O

    Dynamic offset etc

    I have 2 sets of data, for 2 indicators, over time. Format shown below (of course, the data sets are much bigger) Data set 1 (indicator A) <tbody> City 2009 2010 2011 2012 2013 2014 2015 2016 2017 Airdrie 1 2 3 4 5 6 7 8 9 Brooks 9 8 7 8 4 2 1 2 5 Calgary 4 7 4 3 4 8 7 6 1 Duncan 7 5 6...
  11. S

    Progress bar with no loop ?

    Hi All, Does progress bars with Excel VBA works only if there is a Loop? Is it possible to have progress bar while more than one macros running, without looping at all? Thank you in advance.
  12. D

    Form Type Progress Indicator Requested.

    Form type progress indicator requested. Could anyone code a progress indicator into the following (I'm having a heck of a time trying to decipher VB): Sub addComments() ' first we'll clear existing comments For Each cmnt In ActiveSheet.UsedRange.Cells cmnt.ClearComments...
  13. J

    Updating Row Based on Value In Column

    Hello All, We use an old web-based tool at my office that can't export Excel reports. So I'm devising a way to copy an entire page, straight from the browser, and clean it up so that the data can quickly be utilized for other purposes. The data that I'm using is financial information broken...
  14. B

    Move Comment Indicators to top left of cell

    My goal is to have my comment indicators on the top left of the cell like an error indicator and when you hover the comment appears on the left too instead of everything on the right. The reason for this is that I have a floating userform on the right and the comment always appears under it on...
  15. M

    Progress Indicator - Simple!!

    Afternoon all, I've managed to come up with a very very simple progress indicator, it's that basic I have simply entered values throughout the code for the %'age of progress which gets called into the "updateprogress" procedure. Anyway, the way I've got it set up is as follows: User...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back