Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating formula or macro
How can I create formula or macro to do following : to search by criteria
(make a list of values) In a range of column in worksheet (i.e. E10:E36) and if the criteria is match to the cell in range of column, then change data in a certain row (I10:E36). Example : in worksheet there is a values in E10=5 and I10= 10 . If I find by criteria from my list (2,5,7,9) that one number from the list is mach with E10, than change values in I10=0 .I must repeat that in all cells in range (E10:E25) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Macro? | Excel Discussion (Misc queries) | |||
VBA macro creating pdf | Excel Discussion (Misc queries) | |||
Creating a New Macro | Excel Discussion (Misc queries) | |||
Advice on Creating an Excel Formula or Macro - PLEASE HELP!!!! | Excel Worksheet Functions | |||
Help creating Formula (or macro) | Excel Discussion (Misc queries) |