Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maybe a filter?
Dunno if this is the right place to post this but annyway: I have a excel file with a bunch of data, and some how I want to view only th posts with 30 chars or more. Is this possible -- Maximv ----------------------------------------------------------------------- Maximvs's Profile: http://www.excelforum.com/member.php...fo&userid=3490 View this thread: http://www.excelforum.com/showthread.php?threadid=54645 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maybe a filter?
I dont know the lengt of the cells, and therefore i dont know witch row i'm interested in. I'm trying to import the data from the exel worshee into an bussiness program something like SAP, and the length of th cells can only be 30 chars or less, and i'm trying to save time by no having to count all the rows (there is 4000 of them). So i wanted t list the rows with 30 chars or more, so i could shorten them -- Maximv ----------------------------------------------------------------------- Maximvs's Profile: http://www.excelforum.com/member.php...fo&userid=3490 View this thread: http://www.excelforum.com/showthread.php?threadid=54645 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
Extract filter items from Drop-Down Automatic Filter | Excel Programming | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |