Home |
Search |
Today's Posts |
#1
|
|||
|
|||
2 questions - DB and number groups
In one cell in the SS, I have a comma delineated group of numbers
eg 23,4,5,36,2 Is it possible to determine that another cells contents resides within this number set? eg can somehow determine the number 5 (cell g44) resides in this group? Thanks In another worksheet we have, we wish to maintain a number of them as Flat File Databases, and dump 60,000 records in each. We have "The dummies guide to excel" and I am sure I read that if set up as a database the limitations are 256 columns/fields and 16,000 records. Is this true? if so, why? Thank you. |
#2
|
|||
|
|||
Thank you doubleDD,
worked fine. am up and cruisin' very much appreciated. | In one cell in the SS, I have a comma delineated group of numbers | eg 23,4,5,36,2 | Is it possible to determine that another cells contents resides | within this number set? | | eg can somehow determine the number 5 (cell g44) resides in this group? | | Thanks | | | In another worksheet we have, we wish to maintain a number of them | as Flat File Databases, and dump 60,000 records in each. | We have "The dummies guide to excel" and I am sure I read that | if set up as a database the limitations are 256 columns/fields | and 16,000 records. Is this true? | if so, why? | | Thank you. | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Random Number Questions | Excel Worksheet Functions | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
multiply by actual number in cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |