IPB

Welcome Guest ( Log In | Register )


> Excel question
Spectatrix
post 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?


--------------------
QUOTE (pebkac @ Oct 14 2006, 03:15 PM) *
You and your logic.

QUOTE (Foamy)
Open your fucking minds, you text-fucking, pixel pricks!

http://xkcd.com/386/
Go to the top of the page
 
+Quote Post

Posts in this topic
- 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
- - 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

« Next Oldest · The Nerdery · Next Newest »
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Lo-Fi Version Time is now: 18th August 2026 - 03:13 PM
Powered By IP.Board © 2026  IPS, Inc.
Licensed to: Techsans.net
Skin made by: skeedio.com