Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 27th 04, 05:39 PM
Frank Kabel
 
Posts: n/a
Default index to a range of cells

Hi
this is something you can't achieve in Excel with formulas. You need a
kind of unique key for referencing (much easier to achieve in a
database).
So you either enter your ID manually and sort it together with the
other data or use a database

--
Regards
Frank Kabel
Frankfurt, Germany


OEMK wrote:
I am trying to build a set of worksheets, either in the same or
separate workbooks, which would allow me to do the below:

A) One worksheet has a column that contains a separate bibliographic
reference (text) in each row. It also has a number of other columns
containing various bits of data about each reference.

B) In the same worksheet, another column contains an "index" number
corresponding to the position (i.e. row) of a specific bibliographic
reference in the entire list of references. Every time I add a new
reference and sort the whole worksheet, this index should be updated.

C) In a separate worksheet, I will have listed in a column a number

or
series of numbers which will correspond (linked with), the "index"
number(s) of the first worksheet. These should automatically be
updated when new bibilio references are added and resorted.

Questions:

1) The item (C) is fairly easy except that I am not sure how I can
link multiple "index" numbers (separated by a comma) into a single
cell. Any ideas?

2) How can I accomplish (B) above? I can't set up the 'index' column
as an array formula because I can't then add a new bilbiliographic
reference to the range. I would think that there should be some type
of 'index function' which would allow me to refer to an existing
range of biblio references and return the number of the reference in
the whole range. It should also then update it if I add a new
reference and resort it alphabetically. I can't seem to find a
function that would do exactly this.
Any ideas???


Thanks,
oemk



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
Passing a range name as an argument to the Index Function Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM
Formula to count the cells in a range that have a fill color. Slainteva Excel Discussion (Misc queries) 2 January 19th 05 08:25 PM
Formula to count the cells in a range that have a fill color. Molly F Excel Discussion (Misc queries) 2 January 19th 05 06:15 PM
Converting negative numbers in a range of cells to zero Dede Excel Discussion (Misc queries) 3 January 14th 05 06:23 PM
summing part of cells in a range excelFan Excel Discussion (Misc queries) 2 December 5th 04 12:33 PM


All times are GMT +1. The time now is 11:17 AM.

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