 Excel question |
| Excel question |
 Jun 14 2007, 11:38 AM
Post
#1
|
|
|
Group: Admin Posts: 6,906 Joined: 22-February 06 From: Austin Member No.: 9  |
I'm looking for something similar to the MATCH command in Excel, specifically a command (or combination of commands) that will search for a value and return a range of cells that the value appears in, rather than just a single cell location like MATCH does. Any ideas?
-------------------- |
 |
 
|
 |
|
Jun 14 2007, 12:23 PM
Post
#2
|
|
 Group: Members Posts: 5,275 Joined: 22-February 06 Member No.: 2 |
=COUNTIF('my_tab'!D:D,"asdf") will count how many times "asdf" appears in the D column. I know you want a range of cells that contain "asdf", but this might be helpful if you could use the total number of asdf's in some sort of match loop.
|
|
|
|
Spectatrix Excel question Jun 14 2007, 11:38 AM
James I don't see a "Lookup and Reference Funct... Jun 14 2007, 12:05 PM James Oh yeah, how's your data structured? Is it co... Jun 14 2007, 12:36 PM
Spectatrix Ok, I see how to do this. I can use MATCH to find... Jun 14 2007, 12:58 PM |
| Lo-Fi Version | Time is now: 18th August 2026 - 03:26 PM |
