identify

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

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

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

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

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

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

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

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!

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

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

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.

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

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

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.

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,

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.

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

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

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

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