Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Memories of Lotus 1-2-3 - How do I do this in Excel ??
Way back in the deep dark recesses of my memory I seem to recall some way of
extracting all unique values of a certain field from a database in Lotus 1-2-3 to a different portion of the spreadsheet. I have a need to do the same thing now, but like most of the world, I am using Excel now. I can't seem to figure out how to get this done in Excel...in Lotus...I think it was with a data - extract command. Thanks for the help !! |
#2
|
|||
|
|||
Put a label cell on top of the column containing the data
Click on the label cell and then pulldown: Data Filter Advanced Filter... Check Copy to another location and unique records only FInally enter the destination location. -- Gary's Student "Eric @ SEASH, Evansville" wrote: Way back in the deep dark recesses of my memory I seem to recall some way of extracting all unique values of a certain field from a database in Lotus 1-2-3 to a different portion of the spreadsheet. I have a need to do the same thing now, but like most of the world, I am using Excel now. I can't seem to figure out how to get this done in Excel...in Lotus...I think it was with a data - extract command. Thanks for the help !! |
#3
|
|||
|
|||
I knew it had to be something rather simple.....I'm just feeling my age today !
Thanks for your help...that worked like a charm ! "Gary's Student" wrote: Put a label cell on top of the column containing the data Click on the label cell and then pulldown: Data Filter Advanced Filter... Check Copy to another location and unique records only FInally enter the destination location. -- Gary's Student "Eric @ SEASH, Evansville" wrote: Way back in the deep dark recesses of my memory I seem to recall some way of extracting all unique values of a certain field from a database in Lotus 1-2-3 to a different portion of the spreadsheet. I have a need to do the same thing now, but like most of the world, I am using Excel now. I can't seem to figure out how to get this done in Excel...in Lotus...I think it was with a data - extract command. Thanks for the help !! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't AOL email communicate with lotus notes email? | Excel Discussion (Misc queries) | |||
text and numbers same cell and formulas still work (like lotus) | Excel Worksheet Functions | |||
how to convert Lotus 123 to Excel directly and can running normal | Excel Worksheet Functions | |||
Can one open a password protected Lotus 1-2-3 (wk4) file from Exce | Excel Discussion (Misc queries) | |||
Still Convert Lotus 123 to Excel 2003 | Excel Discussion (Misc queries) |