| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
specific data
Hi all, I have a column of over a 1000 account numbers , some of then end in C.
I would like to filter out these values into a separate column . for eg IF last character = C then insert value else blank. Thanks for you r help again, everyone. -- delmac |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
specific data
Say your column is A, then insert this formula in an unused column, row 2,
and drag down as necessary: =IF(RIGHT(A2,1)="C",A2,"") Regards, Stefi €˛delmac€¯ ezt Ć*rta: Hi all, I have a column of over a 1000 account numbers , some of then end in C. I would like to filter out these values into a separate column . for eg IF last character = C then insert value else blank. Thanks for you r help again, everyone. -- delmac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| specific data points in data range | Excel Discussion (Misc queries) | |||
| Import data to specific cells for a specific row | Excel Discussion (Misc queries) | |||
| Getting specific data into specific cells? | Excel Discussion (Misc queries) | |||
| HOw do i find and sort out data repeats for specific data set | Excel Discussion (Misc queries) | |||
| How do I color specific data series based on location on data she | Charts and Charting in Excel | |||
Linear Mode
