| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with "record-oriented" spreadsheets
You could try puting the same concatentation formula...e.g. = A2 & A3 & A4 into cells B2, B3 and B4. and for the next record = A5 & A6 & A7 into cells B5, B6 and B7 etc. Then if you use auto filters you will get all three lines displayed if you get a match. Please see the attached spreadsheet. +-------------------------------------------------------------------+ |Filename: Book1.zip | |Download: http://www.excelforum.com/attachment.php?postid=4848 | +-------------------------------------------------------------------+ -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=545608 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy & paste formula between spreadsheets - not working | Excel Worksheet Functions | |||
| Spreadsheet shortcuts not working | Setting up and Configuration of Excel | |||
| More problems linking spreadsheets | Excel Discussion (Misc queries) | |||
| Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
| How do I get my actuarial spreadsheets to comply with SOx? | Excel Discussion (Misc queries) | |||
Threaded Mode
