| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with text sorting
#N/A means you *don't* have more then 1 of each value!
Try manually keying in some duplicate values and see what happens. Be awa JJCX and JJ CX Are *not* a match and would not count as such. If data is imported, there could very well be invisibly imbedded characters which preclude an exact match. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "jjcx" wrote in message ... I tried the formula given above but still cant get the cell to return anything but #N/A. Thnx 4 ure help if you have any ideas whats wrong plz help. THNX JJCX. -- jjcx ------------------------------------------------------------------------ jjcx's Profile: http://www.excelforum.com/member.php...o&userid=36956 View this thread: http://www.excelforum.com/showthread...hreadid=566710 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text disappers when sorting column | Excel Worksheet Functions | |||
| I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Sorting order - text and numbers | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
