How to capture start and ending Ref. Nos. in an array

		Microsoft Office Forums > Microsoft Excel > Excel
How to capture start and ending Ref. Nos. in an array

FAQ

Mark Forums Read

Thread Tools

Display Modes

09-07-2011, 12:45 AM

Catalin.B

Windows Vista How to capture start and ending Ref. Nos. in an array

Office 2007

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

well, this is an option you can use, in the sample attached
(note that the formula in the yellow cell refers to the last cell value, it is different from the cells above..)

Attached Files

Query101.xlsx (11.3 KB, 12 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM
outlook programmatically read an attachment into byte array	chriskaza81	Outlook	0	11-19-2010 01:03 AM
capture sender's contact to 'Contacts Folder'	gianimpact	Outlook	0	02-09-2010 07:56 AM
Array into ComboBox + Macro-Text into ActiveDocument	Vivi	Word VBA	1	01-27-2010 07:03 AM
Add text to the beginning/ending of each line in word	ballmoney	Word	1	01-17-2010 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:02 AM.