| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Helper Formula To Identify 1st Instance of a Value
I have a series of data like this.
InternalSubcriberRef 30564.00 22222.99 22222.92 30564.00 30564.00 30564.00 30564.00 30564.00 30564.00 30564.00 Would like to add a helper column that will flag the 1st instance of a given value. Thank you in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Helper Formula To Identify 1st Instance of a Value
=COUNTIF($A$1:A1,A1)=1
adapt to your own data and copy down in an adjacent cell will return TRUE for 1st occurrence -- Regards, Peo Sjoblom "carl" wrote in message ... I have a series of data like this. InternalSubcriberRef 30564.00 22222.99 22222.92 30564.00 30564.00 30564.00 30564.00 30564.00 30564.00 30564.00 Would like to add a helper column that will flag the 1st instance of a given value. Thank you in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Helper Formula To Identify 1st Instance of a Value
Try this:
If your list begins in Cell A2 B2: =IF(COUNTIF($A$2:A2,A2)=1,"First","") copy that formula down as far as you need. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "carl" wrote: I have a series of data like this. InternalSubcriberRef 30564.00 22222.99 22222.92 30564.00 30564.00 30564.00 30564.00 30564.00 30564.00 30564.00 Would like to add a helper column that will flag the 1st instance of a given value. Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify month in a period and run a formula | Excel Discussion (Misc queries) | |||
| Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
| Formula to identify cell with different value in list | Excel Worksheet Functions | |||
| How to identify an inserted picture within a formula | Excel Discussion (Misc queries) | |||
| How do identify a blank cell in a formula | Excel Discussion (Misc queries) | |||
Linear Mode
