LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Rodney
 
Posts: n/a
Default 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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Random Number Questions Greegan Excel Worksheet Functions 1 January 5th 05 02:00 AM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM
multiply by actual number in cell CJ Cerezo Excel Worksheet Functions 3 November 29th 04 09:43 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"