how to enter a formula using column() function for a range

Mike Peter

Posts: n/a

how to enter a formula using column() function for a range

I need to enter a formula using Data Validation. The formula is "=$B$4:$E$4".
How do I change this formula to use the Column() function instead of constant
'4'.

I want it to get the number '4' using current Column(). The formula has to
look like "=$B$(Column()):$E$(Column())". But the data validation dialog's
'Source' input box refuses to accept this as valid formula. Is there any work
around? thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Naming column in Index Function	mlkpied	Excel Worksheet Functions	3	December 7th 04 12:20 AM
Aligning Two Lists in Excel	Rich	Excel Discussion (Misc queries)	2	December 4th 04 05:44 PM
which formula or function searches for a value in a range of cell.	Roccobarocco	Excel Worksheet Functions	5	December 3rd 04 12:06 PM
which formula or function searches for a value in a range of cell.	Roccobarocco	Excel Worksheet Functions	7	December 3rd 04 09:06 AM
Can you average data in 1 column based on a range of values in another?	kman24	Excel Worksheet Functions	2	November 17th 04 02:09 PM

All times are GMT +1. The time now is 02:58 PM.

Menu

About Us