identify

1. 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...
2. 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...
3. 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...
4. 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...
5. 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!
6. 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...
7. 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
8. 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.
9. 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...
10. 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
11. 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.
12. 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,
13. 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.
14. 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...
15. 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 -...
16. Two consecutive consonants in a name and surname

What formula can I use to identify two consecutive consonants in the name and surname columns.eg name Ndoluvo and surname Khaye formula should identify any two consecutive consonants the name and surname starts with
17. 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...
18. Find Rows that have a different value

This sounds like it should be simple, but I am struggling. Thank you in advance I have 2 columns of data similar to the below (but 44,000 rows). First column is an account number, second is an identifier. I need to identify the where an account number has both a 2 and 1...
19. Identify Overlapping Times with Multiple Criteria

I've been struggling to find a way to identify pairs of entries for which at least of portion of their time overlaps. To make the challenge more difficult, I need potentially overlapping entries to meet multiple criteria before they are determined to be overlapping. I have two fields for...
20. How do I Dynamically identify the frame of an active control?

I am using the age old loop through the controls ie. For Each cCont1 In Workshop.Frame2.Controls If TypeName(cCont1) = "TextBox" Then etc., etc. My question is "How do I identify the frame that the control resides in?" I have 10...

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 MrExcel.com.

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

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
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