| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To have this formula work with numbers & Text ='T(INDIRECT("'"&
Can this formula be modify below to work with number & Text values?
Because in column A has mix numbers and Texts and I like it to return either one. =T(INDIRECT("'"&XWSLST&"'!A"&(2+MOD(S,N)))) I'm using this formula to return the results. =INDEX(Col_A,SMALL(IF(Col_B=C2,S),COUNTIF(C$2:C2,C 2))+1) I got this solution from the link below. http://groups.google.com/group/micro...6dd080333efba5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| identify numbers and text differently in formula | Excel Discussion (Misc queries) | |||
| work with text and numbers | Excel Discussion (Misc queries) | |||
| IF formula doesn't work with certain numbers | Excel Worksheet Functions | |||
| Why does this Formula work? | Excel Worksheet Functions | |||
Threaded Mode
