Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

help with a formula for Excel


  • Please log in to reply

#1
diggeryo

diggeryo

    Member

  • Member
  • PipPipPip
  • 343 posts
I have Excel 2003. I don't even know if what I'm trying to do is possible, but so far everything I've tried doesn't work.

Here's the scenerio:

I have 3 columns.
Column A has phone numbers in rows 2 through 1121 (with a header in row 1).
Column B has phone numbers in rows 2 through 6324 (with a header in row 1).
In column C, I would like to put a formula that would put an asterick in column C if the phone number column B is anywhere in Column A.

For example, if the phone number in row 5/column B is equal to the phone number in any row of column A, I'd like an asterick in row 5/column C.

So far, I tried this: in row 2/column C, I typed: =if(B2=A:A,"*","")
and then I copied the formula into each row in column C. But it doesn't seem to work.

any help is appreciated.

thanks,
mike.

Edited by diggeryo, 25 September 2006 - 12:39 PM.

  • 0

Advertisements


#2
diggeryo

diggeryo

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 343 posts
I figured it out. After a lot more searching, I came across a formula called Match.

thanks though,
mike.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP