1. I

    Nested For Each Statement: Identifying Key words from Range within a Range

    Dear Mr Excel I would be so grateful for some help with this. I have 4 Sheets that contain data that i am trying to write a code for. MessagesSheet (Which is named "replies" followed by "date" and "time"): This contains text messages received. The data is organised as follows: Each row...
  2. G

    Filter - which column is filtered?

    Hi Everybody! I have a excel table with 300+ columns and when I use a filter, it is very difficult to find later in which column the filter was applied. Is there any formula that can identify the column where the filter is active? Thank you in advance! Gabor
  3. I

    How can I calculate which column contains the last time entry for multiple rows?

    Hi, so I have a file very similar to this one. It is for work. Used to track clock in/out times from employees. I am trying to create a code to identify which employees are on the clock and which ones are not. I was doing a bunch of IF formulas nested but then I realized there could be more...
  4. A

    identify distinct names in filtered list

    hi all, i am trying to work out a way of counting unique/distinct names in a list. Unfiltered is straightforward. In each row: countif($a$2:$a2,$a2). I need to be able to have a formula that will also operate on the same data when it is filtered. I aim to be able to identify distinct names by...
  5. G

    Identify Macro running from a custom button on the Ribbon Bar

    Hi folks, I added a number of buttons to my ribbon bar but can't recall the name of one of the attached macros. On a regular form button, you can just right click to Assign Macro and the current one is shown. However, the button bar does not allow this approach. Any ideas how I can identify the...
  6. N

    Calculate Day Name in a Month and then Average

    Good morning excelites, I need help with a formula to average data for a given day based on the data below. I need to first identify what day of the month (Mon, Tue etc) a day number falls on in any given month and then average those days out. For example, in the table below "Day of Month" in...
  7. A

    Identify position based on voltage data

    Hi, I am using an accelerometer to determine a patient's position on a bed. Five positions need to be identified. In the table below, corresponding accelerometer voltages were measured in each of the five positions. Orientation Vx Vy Vz Supine flat 1.666 1.68 1.007 Supine 10˚ 1.657 1.88...
  8. M

    Grouping dates from the past

    Hi, If i list of historical dates from the past in Column A and I want to identify as either "<6 months from today", "6-11 months from today", or "12+ months from today", how should I write the formula? I am having trouble. Thanks!
  9. V

    Report most common text occurrences in strings of text within a table

    Hi, I have 1400+ survey responses and wish to produce a report of the most common key words in strings of text within a table of responses. An example of a response would be: The ceremony ran very smoothly and did not go on for too long Nice short ceremony Decorated the venue brilliantly The...
  10. J

    VBA - Identify duplicate values in column

    I need assistance with a vba code that will identify duplicate values in a column and copy those cells into a new tab labeled duplicate. Thank you in advance
  11. J

    VBA - Identify rows by value and copy and paste into new tab

    I need assistance writing a code that will allow me to identify all rows that have a value of "Yellow" in column B. I then need to copy only the identified cells over to a new tab and label the new tab "Yellow" I appreciate the help Thank you.
  12. M

    How to generate a unique ID on a Excel for identification purpose

    Some dept will send me several version of Excel repeatedly whenever they have update. I need to identify which one is which version. So, is it possible once I receive it, Excel has some kind of ID of this file I can copy out to ensure this one is this version other than using file name which...
  13. D

    Activating Already Open Internet Explorer Window

    Hi, What is the code for activating an already opened session of IE? And can I identify this as a variable name that I can call from different routines? Thanks, Bobby
  14. most

    Identify if a Application.OnKey is set or not

    Is it possible to identify if a Application.OnKey is set or not? if Application.OnKey."+^{g}" = "MyMacro" then msgbox "Yeah" The final goal is ONE macro which disable or enable all shortcuts.
  15. N

    sumif - to identify duplicate values and a value +/- 10%

    Hi, i am trying to use a sumif formula to identify where a customer name (column A) is a duplicate and the value in column AY is + or - 10% of the value in the duplicate line. Is this possible using a sumif? If not would anyone be able to suggest a different solution? Many thanks,
  16. M

    Macro help

    Hi I have 1000 of website links some of them are having Java scripted and some are not. i need a macro to identify all the java scripted links. thanks for help.
  17. R

    Identifying multiple values from two reoccurring conditions in a string

    SOS, hoping someone can provide assistance to this challenge I have failed to overcome. I require to identify specific text nestled between two text values. From the example below I require to identify text values between text range '_taxonomy_' and text range ' " ', both highlighted in bold...
  18. I

    VBA: Search (Range) Column, Identify Cells Matching Criteria, Select, Delete (and shift cells up)

    Hi there, I have a a sheet of data I am trying to modify automatically through VBA to inform a Dashboard. I've worked backwards, but am struggling with one of the first steps. I am wanting to: - Search A1:A200 - Identify cells in that range with "Prospect", "Bid", and " " - Select them -...
  19. Z

    Two consecutive consonants in a name and surname

    What formula can I use to identify two consecutive consonants in the name and surname name Ndoluvo and surname Khaye formula should identify any two consecutive consonants the name and surname starts with
  20. Z

    Identify cells with unknown variable

    I have a spreadsheet with 8 columns of data. In the 3rd column, I have a variety of codes that start with 'B', 'D' and O'. However, those are just the ones that we KNOW OF in today's world. Management isn't sure if there could be other potential codes or not, and want me to include VBA that...

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