Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 17th 06, 09:46 AM posted to microsoft.public.excel.misc
steev_jd
 
Posts: n/a
Default Call list length in formula


Hi,

I am using the below formula in several spreadsheets;

=CONCATENATE("F",(MATCH($A4,$E$1:$E$7985,0)))

Currently I have to look at the length of the array in column E in each
spreadsheet and input it into the formula.

Is there anyway of having the formula automatcally call the length of
the array to save me doing this?

Thanks in advance,
Steve


--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107
View this thread: http://www.excelforum.com/showthread...hreadid=542820


  #3   Report Post  
Old May 17th 06, 10:11 AM posted to microsoft.public.excel.misc
macropod
 
Posts: n/a
Default Call list length in formula

Hi steev_jd,

If you give your array a name (eg MyArray), you could use:
=CONCATENATE("F",(MATCH($A4,MyArray,0)))
or, even simpler:
="F"&MATCH($A4,MyArray,0)

Cheers


"steev_jd" wrote in
message ...

Hi,

I am using the below formula in several spreadsheets;

=CONCATENATE("F",(MATCH($A4,$E$1:$E$7985,0)))

Currently I have to look at the length of the array in column E in each
spreadsheet and input it into the formula.

Is there anyway of having the formula automatcally call the length of
the array to save me doing this?

Thanks in advance,
Steve


--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile:

http://www.excelforum.com/member.php...o&userid=33107
View this thread: http://www.excelforum.com/showthread...hreadid=542820





Reply
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
How to Change List Based on Value Chosen in Another List Edwin Kelly Excel Worksheet Functions 4 March 2nd 06 07:31 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Data Validation List Length Alex Mackenzie Excel Worksheet Functions 4 November 1st 05 01:27 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
list box length Larry M Excel Worksheet Functions 2 November 24th 04 12:17 AM


All times are GMT +1. The time now is 06:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017