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: 3
Default Searching rows

I want to be able to search a row of data and count the number of occurrence
of a similar number in that row. I won't know how many rows of data or how
many columns to search. Once a row has been checked, I want to know how many
of each of the similar items where in each row (Ex. 15 of 900, 2 of 901,
etc.).

1 A B C D E F
2 Model Scheme Car1 Car2 Car3 Car4
3 501 02 900 901 900 900
4 501 03 901 901 901 902
5 502 00 900 900 901 950
6 505 01 900 901 901 902
7 506 02 902 902 901 905

Any and all help will be greatly appreciated.
 
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
Searching Columns and Rows Cliff Excel Worksheet Functions 3 April 3rd 06 12:52 AM
searching rows and coloumns Juuljus Excel Programming 4 December 6th 05 02:43 PM
searching for a better way to hide rows tjtjjtjt Excel Programming 6 July 7th 05 01:42 PM
searching columns and rows lsu-i-like Excel Discussion (Misc queries) 5 June 20th 05 07:08 PM
Searching for data and inserting new rows Kev427 Excel Discussion (Misc queries) 2 February 1st 05 07:15 AM


All times are GMT +1. The time now is 06:50 AM.

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"