Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I created following formula:
Index($E5:$I$900,Match(cell("contents",$A$2),$E$5: $I$900,0),2) E F G H I J 74 163 2345 Z Janu 164 42 165 166 786 75 189 C Janu 191 225 192 76 ............. Now I want 3 different category from the cell I want Month: January and all other months C : C or W or Z D : 74 or 75 or 76 any How can I do this any idea? |