LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Find first occurence of a number in an array 7 cols wide

In a lotto analysis spread sheet, I want to find row of the first occurence
of each number (1 to 49) in a 2 dimendional array 7 columns wide--essentially
to find how many spins since the last draw of the number. Can this be done
using functions only e.g. MATCH or do I need to learn VBA quickly?
 
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
Find numbers in an array that sum to a certain number tommydancer Excel Worksheet Functions 3 September 9th 06 03:11 PM
Find first occurence in a list that's greater than a specific num stevep Excel Worksheet Functions 2 December 9th 05 08:41 PM
Identify occurence in "array" which meets condition(s) Melissa Excel Discussion (Misc queries) 3 August 18th 05 12:59 PM
Cond Format:re color 2 cols, skip 2 cols Tat Excel Worksheet Functions 2 June 22nd 05 06:43 PM
First Occurence of Non Blank Cell in row array ExcelMonkey Excel Worksheet Functions 4 February 17th 05 10:05 PM


All times are GMT +1. The time now is 03:01 AM.

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

About Us

"It's about Microsoft Excel"