LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default counting number of columns

Hi,

i am using a find action to find a specific value in a multi column
list.

i can find the value no probs and can return the cell reference the
valueis in.

What i now need to do is use that cell in an offset statement.

i need to find out how many columns over from A1 that my find data is
in.

For instance if my find data was in column d, i would use the offset
number 4

any help greatly appreaciated
 
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
Help Counting 10 Columns * X Number of Rows Rob Excel Worksheet Functions 5 April 7th 09 09:22 PM
Counting number of cells that match name AND number Ronster[_2_] Excel Worksheet Functions 4 August 18th 08 12:03 PM
Counting number of columns in CSV/Text file ExcelMonkey Excel Programming 1 November 30th 07 06:26 PM
syntax error for counting the number of columns end. Janis Excel Programming 1 September 20th 06 01:29 AM
Counting Rows Then Counting Values in Columns Michael via OfficeKB.com Excel Programming 1 June 1st 05 04:10 PM


All times are GMT +1. The time now is 07:23 PM.

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

About Us

"It's about Microsoft Excel"