Posted to microsoft.public.excel.programming

nir020

external usenet poster

Posts: 31

Range updates

is it possible to create a formula so it adjust automically to number of row
or columns in a range, for example if there were values in the range C1 to C5
my countif formula would automatically adjust to countif(c1:c5) and if there
values in cells c1 to c1000 the formula would adjust to (c1:c1000)

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Updates	robert morris	Excel Discussion (Misc queries)	0	June 7th 07 01:06 PM
My chart automatically updates, but how can i keep it within a static date range????	jordanwho	Charts and Charting in Excel	1	July 14th 06 08:08 PM
Updates	schutzhund	Setting up and Configuration of Excel	0	January 31st 05 03:51 PM
Updates	Clink7	Excel Discussion (Misc queries)	5	January 12th 05 11:04 AM
Copy Range with no formal updates	[email protected]	Excel Programming	1	September 23rd 03 11:18 PM

All times are GMT +1. The time now is 10:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us