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

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
So you either enter your ID manually and sort it together with the
other data or use a database

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

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.


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???


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 03:52 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017