identify

Hi, there. I'm trying (unsuccessfully) to figure out how to calculate column L. Is there a way to identify the low value in each sequence of K "days under" data in something like the L column faked below? The formulas I returned don't seem to be checking the whole sequence, or identify the...

I have a worksheet with approximately 1500 values all in column "A". I am looking to identify sections where any ten numbers within the set repeat, and identify the repeating values by highlighting them. Anyone want to take a crack at this?

Hello, can someone please help me? I need to look through 300K rows and identify unique count if 2 conditions are meet. Column A has dates which would be used to identify as unique column B contains Day mane witch it is the 1 st criteria and column C has store ID witch it is 2 criteria...

I have a below data . There is a total amount of 46286 which is an addition of some number present in a list. How can I identify of which amount when total together leads to my above mentioned answer 30,000.00 102,000.00 9,749.00 40,877.00 100,000.00...

Hi All, Can you help what formula to identify the month with specific accumulation number as per table below please? I need to identify which month has given result 300 (accumulation A2:L2/A3:L3) for column M2/M3 without helper row. <tbody> A B C D E F G H H J K L M 1 Jan...

In column G are a list of Order Numbers In my macro I'm using "mylastrow" to identify the end of the data so in mylastrow +1 I need formula =min(G2:G & mylastrow + 1) then below =max(G2:G & mylastrow + 2) So simple but.....

Is it possible to automatically Identify Destination of workbook - and Update the fullpath and name of workbook in Cell A1.

I am working on a formula to identify the amount of time an employee is scheduled with their supervisor. I have converted all start and end times to numbers. For example, 1pm-10pm will be 1300-2200. The start and end time is in a separate cell. The supervisors are setup the same. with a day...

I have a table that spans the following range: CE30:CT45 This table will consist of many blanks but will mostly contain values ranging from 0 to 1. Yes, most of the values will be in decimal form (i.e., 0.25, .3333, 0.5, 0.6667, etc.) and yes... there will likely be many duplicates. I need...

Hi Excel Gurus! I have a spreadsheet whereby I want to compare data between several columns to make sure things match up. Is there a formula/function on how to compare text fields and identify those that do not match up?

Hi, I recall seeing this on YouTube videos. Basically if the cell is highlighted it has a "bold" or "distinct shape" around it so that the cell is easy to identify. Is there a setting in excel to implement this? I am using excel 2010. Thanks

Is there a way to use conditional formatting to identify which cells contain formulas?

Hello, I have 4000+ entries that have multiple rows with account names in column F. There are multiple entries for each account throughout the sheet, what I would like to do is keep only one row for each account out of all of the entries so that I can identify how many individual accounts had...

I am working on consolidating several different employee groups. They are separated by different benefit rates. I have 25 different groups, each with 9 different rates. I am looking to consolidate the 25 groups if possible by comparing similarites in the rates. Is there a formula that can help...

Hi I have a spreadsheet that is produced by a Co-ordinate Measuring Machine. it is a simple 47 row by 11 cols with numbers in black in the cells. If the measurement is outside the tolerance of the part being measured, the result is a number but it is in red with strike-through. I need to...

I have a table that looks like this: <colgroup><col></colgroup><tbody> AL INC.(CCML) EX, LLC (FF) TG & A/C (B-FF) JING & A/C (B-FF) OKA (B-FF) EATING & A/C,INC(B-GA) MECHANICAL AIR SYSTEMS INC </tbody> I need to be able to identify the B or the C in the parenthesis of each and...

Hi all, Hope you're well. I am hoping for some assistance. I am trying to identify if there are any potential duplicate references in my spreadsheet and the system doesn't allow the same reference to be entered twice. So if there is a duplicate, it will somehow be slightly different. IE...

Can anyone show me how to identify the last used cell in a column that has a combination of data and blank cells? The rows this applies to is 8:214 so I just need the last cell within that range, (column L), that has a value.

I have been struggling longer than I expected and would love to get some assistance on this task that I am doing. I want to create a new column (column A), in which identifies the first occurrence of the number 1 in column B. If it is the first occurrence, it would be blank, for the rest it...

Hey there, I have some formulas going in five straight columns, and the results from W1:AA1 result in no, no, yes, yes, yes, which correspond to 1,2,3,4,5 (the column titles, which will never change, it will always be 1-5). I'm trying to find a formula that will identify that the first...