 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:05 PM
Post
#2
|
|
|
Fool Group: Members Posts: 2,127 Joined: 23-February 06 From: LBB Member No.: 56 |
I don't see a "Lookup and Reference Function" that does what you described. Only thing I can think of is running a loop over your data set and flagging each cell that matches for output.
-------------------- Spam? Isn't that something poor people eat?
|
|
|
|
Spectatrix Excel question Jun 14 2007, 11:38 AM
1up =COUNTIF('my_tab'!D:D,"asdf... Jun 14 2007, 12:23 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 |
