| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rows identification and deletion
I need a function to do the following task.
values in Col A1 to A6 are 2500,0,65,550,0,900 I need a function to transform these vales in Co B1 to B6 like this: B1=2500 B2=65 B3=550 B4=900 B5=blank B6=blank please don't suggest to use filter,sort options or using a macro. I am not expert in row number identification basing on condition.I think row and match function will give the appropriate results ,what I need. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Deletion of Rows | New Users to Excel | |||
| Protect formulas but allow deletion of rows? | Excel Discussion (Misc queries) | |||
| On deletion of rows | Excel Discussion (Misc queries) | |||
| Selective deletion of rows containing certain text. | Excel Worksheet Functions | |||
| Deletion of rows where a value is satisfied | Excel Worksheet Functions | |||
Threaded Mode
